This is a straight forward “Cut the bulltshit and give me what I need” manual to install Tableau on windows machine on GCP. Naturally, added my personal tips.
- Be sure to install Windows with Desktop (I may try later with linux, and more complex HW environments , stay tuned)
- Machine type – minimum 8 cores (to maximize network bandwidth), 30 GB ram, 1024 GB SSD to maximize IO. Be sure to install the machine in a region close to your GCP BigQuery dataset region. assuming public IP 18.104.22.168
- Assign password to the user
- Download chrome RDP plugin for GCP (optional)
- make sure you added port 3389 to your network ingress ports.
- RDP to the machine, Turn Off Windows Firewall.
- download the tableau server and Run it.
- login to TSM requires a windows user in admin group. I created a new user with an easier password for this installation.
- You need a license for tableau server, usually , you can use it once for PROD and twice for NON PROD. Note you have a 14 day trial options for days. you have an option to offline license activation for air gapped environment.
- Once installation is done, you are going to configure admin user, and open port 80 to the instance. access the server from your desktop using web browser and you server IP. eg. https://22.214.171.124
- from Tableau desktop, sign to tableau server using the credentials from step 10. you should be able to publish now.
- Notice when you create a scheduled extract expected metrics are 40% cpu utilization(!) and about 15 GB RAM. Network will unlikely be bottleneck, but will ossicalte from 0 to 5Mbps (about 10000 per second). This blog is about extract optimization. also log into to TSM and add more instances based on the amount of CPU cores.
- Notice after restart, login to the TSM and start tableau server.
Below is example of CPU core allocation for Tableau
Video Blog on getting started on Tableau Desktop:
Resources to improve performance of Tableau extracts :
I put a lot of thoughts into these blogs, so I could share the information in a clear and useful way. If you have any comments, thoughts, questions, or you need someone to consult with, feel free to contact me: