To see a visual mapping of how widgets are related to datasets and their associated queries, click on More Settings -> Data Diagram on the widget settings.
You can preview visualizations, edit the query directly from the diagram, and zoom into any derived datasets.
The diagrams are also accessible on the query listing page.
Query Diagnostics
The Query Diagnostics feature provides users with a comprehensive view of the status and performance of queries directly from within the widget. This feature is designed to streamline the process of managing queries without the need to navigate away from the dashboard.
Accessing Query Diagnostics
To access the Query Diagnostics, follow these steps:
- Navigate to the Widget Menu: In the widget containing your query, click on the menu icon to reveal additional options.
- Select "Query Diagnostics": From the dropdown, choose the "Query Diagnostics" option.
Features and Functionality
Upon selecting "Query Diagnostics," a modal will appear displaying the following details:
- Query Type Indication: If the query is non-direct, this will be clearly indicated in the modal.
- Date: The timestamp of the execution of the query.
- Level: The status of the query (e.g., Running, Completed, Failed).
- Duration: How long the query took to execute.
- Records: How many records were returned.
- Refresh: Refreshes the Query Diagnostics modal with the most recent query execution information. It does not run the query.
- Edit Query: Redirects the user to the edit query page.
- Run Again: For non-direct queries, users can also execute the query directly from the Query Diagnostics modal by clicking the Run Again button.
Permissions and Access
Users with appropriate permissions can view the diagnostics and, if authorized, execute the query. If a query is shared as "View Only," users will be able to see the log and status but will not have the ability to edit or run the query.