KNOWLEDGE BASE

Viewing Underlying SQL Queries


Published: 22 Oct 2013
Last Modified Date: 08 Mar 2017

Question

How to view the SQL queries issued from Tableau Desktop to the data source.

Environment

Tableau Desktop

Answer

To see underlying queries, use one of the following options.

Option 1: Use "Convert to Custom SQL"

  1. Right-click the data source and select Edit Data Source
  2. Select Data > Convert to Custom SQL 
A text box will open showing the SQL used to connect to the selected data source.
 

Option 2: Use the Performance Recording Feature

For more information, see Create a Performance Recording and Interpret a Performance Recording Workbook in Tableau Help.

Option 3: Review the Tableau Desktop Logs

  • Navigate to the Logs folder inside the My Tableau Repository folder. 
  • By default, the My Tableau Repository can be found inside the My Documents folder on Windows or the Documents folder on a Mac.
  • If you have a live connection to the data source, check the log.txt and tabprotosrv.txt files.
  • If you are using an extract, check the tdeserver.txt file.
  • The tabprotosrv.txt file often shows detailed information about queries.

 

Did this article resolve the issue?