Docs

SKOOR Data Queries are a very powerfull way to prepare data for usage in dashboards and widgets. Similar to SQL views, Data Queries allow to transform data from any number of tables into whatever shape the frontend expects.

In order to make it easier to work with Data Queries, we reworked the Data Query editor in SKOOR Dashboard 7.0. Changes include an improved data preview (including ordering and filtering), simplified publishing, as well as a search bar in the Data Queries navigation.

Maybe most importantly, Data Queries can now be materialized. Much like materialized views in SQL, the contents of a materialized Data Query are computed in advance to ensure very fast data loading times when accessing a dashboard. Materialization can be triggered manually or via an API (for example from SKOOR ETL, whenever new data is loaded).