Query Studio

Query Studio is a powerful SQL-based interface that empowers users with data discovery, exploration, and self-serve analytics capabilities. By leveraging the intuitive interface, you can write and execute SQL queries against supported data sources, enabling quick insights and analysis. Query Studio is ideal for both technical users, such as data analysts and engineers, and non-technical users familiar with SQL who wish to perform ad hoc data analysis. Let’s quickly take a look at all that Query Studio offers:

Getting Started with Query Studio

1. Navigate to the Query Studio under Analytics within the ZMP left-hand Nav bar.

Ensure that you have the necessary permissions to access the module and the connected data sources.

2. All permitted data tables will be listed under the Databases Tab.

• The Column section displays Column metadata with options to:

  • Preview the table

  • View Data Dictionary

3. Use the SQL editor to write your query.

• The editor provides SQL keyword highlighting and type assist to help with query formation.

• Queries are auto-saved and an option exists to save your work.

• Click the Run Query button to execute your query.

4. Query results are displayed in a tabular format under the Results tab for easy review.

• Use Search to look up a specific value in Results.

• Select specific columns within Results to quickly analyze selected columns without rerunning queries with fewer columns.

5. To download results, click the Download CSV button.

6. To save results for Visualization and ongoing Reporting in ZMP, use the Create New Dataset under the Save option and provide a meaningful name and description for Visualization in Report Builder.

Use Cases

• Ad Hoc Analysis: Effortlessly analyze data trends, apply aggregations, and detect anomalies using flexible, custom SQL queries.

• Self-Serve Analytics: Empower your team to independently explore and manipulate data without relying on pre-built datasets or dashboards.

• Seamless Reporting: Generate and save datasets from your final query results, enabling ongoing reporting and visualization.

• Scheduled Reports: Configure automated report delivery using query outputs generated through the Report Builder.

Best Practices

• Optimize Queries: Use filters, indexed columns, and efficient joins to improve query performance.

• Save Frequently Used Queries: Reuse saved queries for consistency and efficiency.

• Validate Results: Cross-check query outputs with expected results to ensure data accuracy.

• Appropriate Permissions: Restrict Query Studio access to users proficient in SQL to prevent accidental query or dataset deletions or costly long-running queries.

• Leverage Aggregation Policy: Control access to granular data by managing aggregation policy and permissions.

Troubleshooting