0 votes
1 view
in BI by (17.6k points)

Oftentimes I need to troubleshoot a workbook that another person at my company has created and published to our server. To troubleshoot, I need to see their connection details, specifically their Custom SQL, to understand what data they are using in their extract.

Is there any way to view this connection info (specifically their SQL code) when viewing the published workbook on the server (web) version?

I am an admin and I am able to download their workbook to my desktop version of tableau, then open it, then reconnect to the data, then look through the data connections they created, to see their SQL. But it's a really cumbersome process.

All I'm looking to do is, when looking at a published workbook, see the data connection details so that I can see the Custom SQL, without going through the process of downloading I described above.

1 Answer

0 votes
by (47.2k points)
  • Some of the details are available on the SQL statement by creating a performance recording.

  • From the Tableau Server Admin Guide:

  • Enable Performance Recordings:

  1. Choose the Admin button in Tableau Server.

  2. Choose Site.

  3. Select a site.

  4. Choose Edit.

  5. select Allow Performance Recording in the Edit Site dialog box

  6. Choose OK.

  • You have to start performance recording for a specific view by adding ?:record_performance=yes to the URL. For example http://server.site.com/views/Variety/BaseballStatistics?:record_performance=yes

  • Now, you can notice a new link at the top of your view called "Show Performance Recording".Now, click this to open the generated performance workbook dashboard. And then click on the bar chart and observe the SQL appear at the bottom of the view. You have to make a note that the SQL text will truncate after about 250 characters.

  • Basically, admin guide suggests viewing the "Tableau Log" to find the full SQL statement.. I have looked at all the server-side logs in C:\ProgramData\Tableau\Tableau Server\data\tabsvc\logs but cannot locate the SQL. 

  • You can also be able to run a database trace to see the SQL that the database sees. Let see an example, for MS SQL Server, run the Profiler tool, set up a default trace, and filter on "Application Name" = "Tableau Protocol Server 8.0" or similar.

I would recommend sign up for Tableau Training Course from Intellipaat, they will also help you get a job. 

Welcome to Intellipaat Community. Get your technical queries answered by top developers !

Categories

...