Sunday, June 18, 2023

How do you view underlying SQL queries in Tableau?

 In Tableau, you can view the underlying SQL queries using the Performance Recording feature. Here's how you can do it:

  1. Open the workbook in Tableau.
  2. Go to the "Help" menu at the top of the Tableau window.
  3. Select "Settings and Performance" from the dropdown menu.
  4. In the submenu, choose "Start Performance Recording." This will start recording the performance data for the workbook.
  5. Perform the actions in Tableau that you want to analyze, such as filtering, adding or modifying data sources, or creating visualizations.
  6. Once you're done with the actions, go back to the "Help" menu and select "Settings and Performance" again.
  7. This time, choose "Stop Performance Recording" from the submenu.
  8. Tableau will save the performance recording as a .tdr file on your computer.
  9. Locate the saved .tdr file and double-click on it to open it in Tableau.
  10. The Performance Recording workbook will open, showing various performance-related information.
  11. In the workbook, navigate to the "Performance" tab, and you'll find a sheet named "SQL Statistics."
  12. Open the "SQL Statistics" sheet to view the underlying SQL queries executed by Tableau.

By examining the SQL queries, you can gain insights into how Tableau is interacting with your data sources and optimize the performance of your workbook if necessary.

No comments:

Post a Comment

If you have any doubts. Please let me know

How can you create an alias for a table in a SQL query?

In SQL, you can create an alias for a table in a query to give the table a temporary, alternative name that you can use in the query. Table ...