Cube Cloud: December 2021

Following Cube Cloud becoming generally available in October 2021, we’ve been hard at work making improvements across the board. Let’s have a quick run through them:

Database Connections

Cube Cloud now supports configuring your own specified SSL certificates when connecting to databases. When creating a new deployment, check the ‘SSL’ box, and paste the relevant SSL certificates:

Git integration

We’ve made it really easy to quickly add more Git branches to your Cube Cloud deployment and switch between them, just click the branch name in the status bar:

Speaking of Git branches, you can now easily add and remove branches with the same switcher; click ‘Add Branch’ and enter a name for the new branch in the popup:

These branches are shared; meaning everyone on your Cube Cloud team can see and edit them. This makes them super useful for out-of-band experiments where you can quickly test things in Cube Cloud without having to go through a CI/CD process.

To round things off, you can also delete unused branches too; first make sure you are already on the branch, then open the switcher and click ‘Remove Branch’:

GitHub integration

When connecting your GitHub repo to Cube Cloud, you can now choose a default branch for deployments:

Developer Mode

We’ve seen a round of improvements to the Cube Cloud Developer Mode experience. When you’re in Developer Mode, the status bar is now purple so you always know when it’s active:

If you’ve been editing a schema and navigate away, we warn you if there are any unsaved changes:

And last but not least, we’ve added a new ‘Generate Schema’ button to the Schema page. Clicking this will let you re-generate schemas from your source database, or alternatively add rollups to existing schemas:

Query Tracing

When inspecting queries in the Queries tab, you can now also see whether or not the query used a pre-aggregation:

If you click a query from the list, we now provide more relevant information, like if the query built a pre-aggregation or not:

SQL API

Following the release of the SQL API in Cube, we’re happy to announce that you can also use it in Cube Cloud. You can enable it by clicking ‘Deploy SQL API’ from the Overview page, then click the ‘How to connect your BI tool’. You should then see something similar to the following:

You can read more about the Cube SQL API in the documentation, and we even have a recipe that shows you how to connect the SQL API to Apache Superset.

GraphQL API

In parallel to the SQL API, we also are excited to announce a new GraphQL API. You can copy its’ URL from the Overview page, just under the SQL API:

More information can be found in the documentation; we hope you enjoy using it as much as we are :nerd_face:

Other Notable Improvements

  • When a deployment is connected to a Git monorepo, only commits to the Cube project folder will trigger a rebuild on Cube Cloud.
  • When switching from stable track to latest, Cube Cloud will now automatically restart the deployment.
  • COMPILE_CONTEXT now works correctly in Developer Mode.
  • Automatically switch to Developer Mode after adding a rollup using the Rollup Designer.

That’s all for this release, stay tuned for the release notes next time :grinning:

3 Likes