Understanding and Editing the SQL Query
The SQL section is where you can view, modify, and execute queries that define the dataset used for chart visualization.
Last updated
The SQL section is where you can view, modify, and execute queries that define the dataset used for chart visualization.
Last updated
Key Features of the SQL Section
The SQL query displayed here is either:
AI-generated based on the selected intent and data sources.
User-defined if imported from the Data Explorer flow.
Users can modify the query manually if they need to adjust the dataset.
Click "Execute" to run the query.
The system will process the query using the syntax of the selected data source.
The Data Table section displays the results of the executed query.
This provides a preview of the dataset before applying it to the chart.
If there is a syntax error, an error message will be displayed.
The system will provide a prompt to fix the error.
You can manually edit the query or use the AI assistant for corrections.
Once the query is error-free, click the "Apply" button.
This step is mandatory as it provisions the dataset for chart customization.
📌 Without applying the dataset, the chart cannot proceed to customization.
Clicking the "Explorer" button takes you back to the Data Explorer flow.
This allows users to refine their dataset before finalizing the chart.
Once the query is successfully applied, you can move to the Chart Customization section to configure the visualization settings. 🚀
