Query Analysis

A process in databases that employ SQL to figure out how to better optimize queries for performance

1. Write your SQL query in the text box, you can click the arrow of the data column to add the column quickly.

2. Click Execute to run the command fully, the results from your query will show up in the below space.

3. Click Add chart to use the results to build a chart. You can visit our article about Chart Builder.

4. Click Save Analysis to save the results to an available folder, or you can create a new one.

5. Click Add Param to add a variable or placeholder used within a query statement.

Parameters allow you to pass specific values into a query dynamically, enabling flexibility and customization. By using parameters, you can create reusable query templates that can be executed with different input values, enhancing the versatility and efficiency of your queries.

6. Click Action to show some actions you can do with the results

  • Create Table: You create a table from the results, and save it in an available database. The table can be created in two types: View (the virtual table formed from the base table and updated each time the View is used), and Materialized (the physical copy of the base table has to be updated manually or using triggers.

  • Download CSV: Retrieve data in CSV format, facilitating easy access and analysis of information in spreadsheet applications.

  • Add Chart To Dashboard: Save the query visualization in Folder or Dashboard

Last updated