Once the report is saved, it will be listed in the Queries section.
Each query listing comes with several options on the right:
Run Now: This option runs the query. By default, all the queries are saved in the ElasticStore so every time, this option is chosen, the query is executed against the warehouse. If chosen otherwise, the query is executed real-time against the database.
Edit: This option lets you edit the queries and save them again.
Data Config: This option tells you about the underlying structure of the query. For example, the figure below gives the following information:
Query Report named TestReport is executed on the dataset named TestReport and is represented by the widget called TestReport
Add a Derived Dataset: This option allows you to create new derived queries and datasets from the data. The original dataset will be the parent and the new one will be derived from it. Applicable for data stored in ElasticStore.
Share: Lets you share the query report with other user groups or users.
Clone: Lets you build a query, using the existing query as a baseline.
History: Lets you view the change history for this query. Note: you must have edit privileges for the query.
- Additional query revert button is available as soon as any historical item is expanded.
- Refresh will refresh the query with any subsequent changes that may have been made whilst on that page
Delete: Deletes a query. You can opt to remove all widgets/visualizations associated with the particular query.
Cancel (Beta): Cancel a currently running query. The behavior of this action depends on datasource type of the running query. the thread that is executing the query will be interrupted, thereby allowing it to disconnect and return. A new run of the same query can then be executed.
Click on Download Queries button if you want to download the queries (to track in your source control).