Playground and Execute
Once your semantic layer is defined, Aptrics generates optimized queries that are executed against your data warehouse. Understanding how to access and execute queries is essential for getting insights from your data.
This guide shows you how to retrieve queries, execute them, and work with the results in different applications.
Query Execution
Build Your Query
Use Studio's query builder to select metrics, add dimensions, apply filters, and specify time ranges. The visual interface translates your selections into optimized SQL queries that run against your data warehouse.
Preview Results
Before executing a query at scale, preview the results with a sample of your data. This helps you verify that your query is configured correctly and returning the expected metrics and dimensions.
Execute Full Query
Click "Execute" to run the full query against your data warehouse. Aptrics displays the complete results with support for pagination, sorting, and downloading data in various formats.
Export and Share Results
Export query results as CSV, Excel, or JSON files. Share results with team members or embed them in dashboards and reports. Aptrics maintains audit logs of all query executions for compliance and troubleshooting.