Cube Core v0.31 release brings a number of major new features such as:
- Support for YAML syntax for data modeling
- Support for ksqlDB as the data source
- Lambda pre-aggregations
Breaking changes and deprecations
Two breaking changes and one deprecation in this release:
- BREAKING CHANGE: Foreign cube references must now reference a cube member
- BREAKING CHANGE: The
shownproperty now hides cubes/views from the
/metaendpoint when set to
- DEPRECATION: The
driverFactoryproperty should return a
DriverConfigobject or a Promise that returns a
Please check the Deprecation document for more details on the above.
Multiple Data Sources
Cube has had support for multiple data sources for quite some time now, but we’ve made it even easier to configure them now with environment variables. Read the documentation to see how it works.
Modeling in YAML
Designed as a layer over cubes, views act as a façade of your whole data model. They are a great tool for to defining metrics, managing governance and data access, and controlling ambiguous join paths. Learn more about them in the introductory blog post, read more about them in the documentation or watch our in-depth webinar on the topic.
Lambda pre-aggregations allow combining batched/processed data with fresh data at query time, this is super useful for real-time data applications. You can even take it a step further and combine batched data from a data warehouse with streaming data from ksqlDB; find more information in the documentation.
We’re really excited to present two new drivers, Firebolt and Trino. And to top it off, we’ve also added a brand-new driver for ksqlDB.
The Cube SQL API now speaks the Postgres protocol instead of MySQL; the Postgres protocol is better supported and allows us to extend supports to dozens of downstream tools. We’ve also made a number of improvements relating syntax and operator support, and we’ve documented any difference in behaviour from regular SQL.
We’ve been busy since the last release adding support for downstream tools. Cube now connects to:
- Microsoft PowerBI
- Amazon QuickSight
Let us know if there’s a tool that you’d like supported by opening an issue on GitHub.