How to connect Tableau to Google Cloud Spanner DB

  1. On GCP console, create a Service Account and grant it an appropriate machine role, for example roles/spanner.databaseUser or roles/spanner.databaseReader
  2. On GCP console, create and download a JSON Private key file to the machines you run Tableau Desktop and Tableau Server.
  3. Download the latest Simba JDBC Driver for Google Cloud Spanner (version 4.2 compatible, for Java 8.0 and greater).
  4. Place the .jar files in the folder for your operating system (you need to create the folder if it doesn’t already exist):
  • Windows: C:\Program Files\Tableau\Drivers
  • Mac: ~/Library/Tableau/Drivers
  • Linux: /opt/tableau/tableau_driver/jdbc
  • Tableau Desktop: Documents\My Tableau Repository\Datasources
  • Tableau Server — Windows: ProgramData\Tableau\Tableau Server\data\tabsvc\vizqlserver\Datasources
  • Tableau Server — Linux: /var/opt/tableau/tableau_server/data/tabsvc/vizqlserver/Datasources
  • URL example (replace information under brackets):
  • Dialect: MySQL

Tableau support for Other Databases (ODBC) connections

--

--

--

Love podcasts or audiobooks? Learn on the go with our new app.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Alex Eskinasy

Alex Eskinasy

Data Geek

More from Medium

Universal Analytics is Dead — is Google Analytics Dead?

Free Google Analytics Alternatives

Big Data : Know everything here

Load Testing Tableau Server Using Tabjolt

KMS Basic