🧭
SQL Explore
Previously called Explores
Sprinkle SQL Explore helps you do analysis, build reports, and visualizations using SQL.
📊
📈
💹
SQL Explore : Explanation & Feature Walkthrough
Good to Know: Use the "Select" query to generate outputs as required for analysis. "Create" or "update" table queries are not supported in SQL Explore, as Explore is meant only for reporting and visualizations. For data preparation and transformations, refer to SQL Transform where you can write any SQL Query.
On the left side, there's the Schema Browser to search for any table in the warehouse and see its schema in the same window.
You can download the results in a CSV file from the download icon above the output table.
By default, data is shown in tabular format. You can use various charts to visualise the data. After selecting the chart, Click Save to keep that as the default view.
🖱
After selecting your desired visualisation and saving it, you can add the report to an existing Dashboard.
You can set the Explore on Auto-Run from the menu on the top right corner. Navigate to Auto-Run and then switch the Auto-Run on.
If explore is part of a Dashboard, then Dashboard needs to be set on Auto-Run to refresh it automatically. Refreshing of Explore output and Dashboard which uses the Explore are independent of each other.
If you want to run the explore, only when its input tables are updated, you can select that on the Auto-Run page. Learn more about Auto-Run in Schedules and Notifications.
When SQL Explore query is run, its output is cached in the cloud bucket. You can control the number of rows to be written. The default value is 500,000. You can change the limit from the Settings menu.
