I use Looker to manage my data stored in Amazon RedShift database. Though Looker has dash-boarding capabilities, I would like to use Tableau for better visualization. Is there a way I can connect Tableau to Looker database.
(P.S: I don't wish to connect Tableau to RedShift/ S3 directly as this exposes my data to Tableau server). Thank you.
Connect Tableau to Looker database
1.4k Views Asked by Nandini Chakladar At
2
There are 2 best solutions below
0
On
You want to get connected to Looker Database ? Does that mean, you want to get data extracted from looker views and use same data in Tableau ? or You want to use looker Metadata ?
I don't think you can directly connect to the data fetched by looker but you can get all the metadata used by all looker views and models using Looker API.
Metadata will have all data base, schema, table , underlying fields from table or fields created in looker.
This can be achieved by 1) generating API3 keys 2) Connect to looker with restful API and load received data to a file 3) Use the file as part your tableau dashboard.
Try if Same process can be used to get table data via looker.
Visualising looker itself is a good option as we get easy drill details and flexibility.
Looker connects to your Amazon Redshift database directly via JBDC connection. If you would like to visualize queries generated from Looker you'd be best to utilize the API to generate a result set to access via Tableau. The API will allow you to generate result sets in a number of different formats (JSON, CSV, HTML, TXT,...). Looker connects directly to the underlying datasource via JDBC connection and only stores the application metadata (users, saved content, etc.) in it's application Database.
Looker is also releasing custom visualizations to compliment the existing visualization options. This will allow the development of javascript visualizations that render alongside the out of the box options provided by Looker.
*full disclosure I work for Looker