Skip to main content

View SQL and Logs

View SQL#

You can view the SQL used to create this dataset using the "View SQL" button via the three dots in the upper right-hand corner of any chart widget. This will open up a modal that shows you two different SQL statements:

  • Generated SQL: SQL that ran against Transform's cache to generate the current metric dataset
  • Source SQL: SQL that ran against the data warehouse in the past to originally compute this metric

View Server Logs#

If you want to go deeper into the query and troubleshoot, you can optionally navigate to the full logs by clicking "View Server Logs" at the bottom of the modal window.

This page is broken up into four components for a particular query:

  1. Server Log - Shows details of the query execution and any errors or failures if the query didn't succeed
  2. SQL - Shows both SQL used to generate the data from Transform's cache in the current execution, as well as the source SQL used to create the dataset from your data warehouse (same as modal above).
  3. Result - This will show the metric line chart with an option to toggle to Table View. You can also optionally download as CSV or PNG using the "More actions" menu.
  4. Debug - This will show any debug logs that can be used to troubleshoot