We’re extremely happy to announce Cube.js v0.28
Cube.js v0.28 includes tons of goodies for developers in the form of the Developer Playground, not to mention incredible improvements to Cube Store and a raft of reliability improvements to our database drivers.
Only one deprecation this release
- Redis configuration variables are all now prefixed with
CUBEJS_. This is part of an ongoing process to cleanly separate and mark environment variables used by Cube.js.
Be sure to check the Deprecation document for more details on the above.
queryTransformerproperty in the
cube.jsconfiguration file is replaced by
A new environment variable
CUBEJS_REFRESH_WORKERis introduced, which replaces
A new environment variable
CUBEJS_ROLLUP_ONLYis introduced, which ensures all requests only target pre-aggregations of type
rollupand that your database is not invoked
Partition evaluation responsibilities have been moved from the schema compiler to the query orchestrator. This allows all time queries for partitioned rollups and fixes querying issues beyond a rollup’s build range. This is also the first step towards rolling window rollups being supported
Run timer refresh keys in Cube Store instead of your source database. This means the source database is now free of those pesky refresh SQL queries spamming the query log
The database connection wizard works in both Node and Docker-based installs
The default type for pre-aggregations is now
rollup. This can still be overridden by explicitly specifying the
typeproperty, but we strongly recommend using rollups instead of
originalSqlfor most workloads.
Pre-aggregation definitions now set the following as defaults:
refreshRangeEndto be replaced by
You can write
We’re working our way through the supported drivers so that Cube.js doesn’t talk to your database any more than is necessary. To this end, the following drivers now default to
readOnly: true automatically:
We’ve been cranking out improvements to pre-aggregations too, here are the highlights:
- Cube Store is now the default storage for external pre-aggregations in new projects
Batching is now also supported for
- MySQL (now in
readOnly: trueas well)
Export bucket is now also supported for
- Redshift (on S3)
- Snowflake (now on GCS as well as S3)
Snowflake’s HyperLogLog format is now supported, which enables using
countDistinctApprox-type measures in pre-aggregations
- Improved CSV ingestion time through distributed processing
- Now supports
- Decimal/float values
We have so many improvements here that we’re really excited to share with you all:
You can now search for dimensions and measures. The members are also grouped by cube, which makes it easy-as-pie to pick out the ones you want.
A long-requested item on our agenda has been Vue 3 support, which is now available.
You can now have multiple tabs with their own queries in the Developer Playground - super useful when you want to keep queries at-hand without needing a separate instance of the Playground open
The brand new Rollup Designer makes creating pre-aggregations an absolute treat.
We have a long list of contributions from the community this release, and we’d like to thank each and every person who took the time to help us improve Cube.js
- JK Go
- Chitraansh Popli
Apologies to anyone who we forgot to mention; please get in touch and we’ll make sure to add your name to the list