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 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.
orders.count, then click for available dimensions
Then, clickto 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, or choose another chart type instead of .
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 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.
Did you find this page useful?