How to get the SQL for a data source

Question

I have "inherited" a set of Tableau workbooks and dashboards. No documents around how the data sources are built. I am familiar with databases and tables but how the SQLs and/or logic behind the data sources.

In order to troubleshoot and answer questions I am getting how can I figure out the data source details (SQLs).

I saw some answers around looking at the log files after data source refresh etc but do not have access to the Tableau server.

Any input would be appreciated.

demircioglu · Accepted Answer · 2019-01-19 00:42:40Z

1

I was able to figure it out. Posting here just in case someone would have the same question in the future

The data source was a published data source, I had to right-click on it and create a local copy. After that since database was behind a jumpbox I had to create an SSH tunnel to connect to database using local data source and was able to see the custom SQL.

answered Jan 19, 2019 at 0:42

demircioglu

3,5151 gold badge21 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

matt_black · Accepted Answer · 2019-01-30 14:51:15Z

1

It is also posible to see the emitted SQL for a Tableau workbook by turning on performance monitoring from the Help|Settings and Performance|Start Performance Recording menu. This records all queries and generates a workbook containing the queries and analysis of which things took what time in the original Table workbook.

answered Jan 30, 2019 at 14:51

matt_black

1,3301 gold badge13 silver badges18 bronze badges

Collectives™ on Stack Overflow

How to get the SQL for a data source

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related