In this step, you will learn how to query your data using the data models you created in the previous step. Cube provides several ways to query your data, and we'll go over them here.
Playground is a web-based tool which allows for
model generation and data exploration. On the Build tab, you can
select the measures and dimensions, and then run the query. Let's do this for
orders cube you generated in the previous step.
Click + Measure to display the available measures and add
orders.count, then click + Dimension for available dimensions and
Then, click Run to execute the query and see the results:
Please feel free to experiment: select other measures or dimensions, pick a granularity for the time dimension instead of w/o grouping, or choose another chart type instead of Table.
Connectivity to BI tools and data notebooks is enabled by the SQL API which is Postgres-compatible: if something connects to Postgres, it will work with Cube. Check the Connect to BI tab for connection instructions for specific BI tools:
Now that we've seen how to use Cube's APIs, let's take a look at how to add pre-aggregations to speed up your queries.