Events /

Watch On-Demand: Get Started with Cube Cloud

Check out our Office Hours to Set Up Your Cube Cloud Account

  • Cube

Register here to watch on-demand.

A recent webinar with Rory Gatto, Customer Experience Engineer at Cube, offered insights into the functionality of Cube as a universal semantic layer and its critical role in modern data stack. Here are five key takeaways for the data engineers intrigued to explore Cube and its capabilities in detail.

1. Introduction to Cube

Rory introduced Cube as a singular, reliable resource in a modern data stack. It focuses on ensuring data consistency, offering robust security, superior performance, quick time to value, and a flexible data stack. These features collectively make Cube a powerful tool, elevating the efficiency and potential of any data infrastructure.

2. Setup of Cube Instance

Rory simplified the process of setting up a Cube instance with Snowflake as the data source. The practical steps include initiating a deployment, choosing tables, defining dimensions, setting primary keys, and crafting a data model using JavaScript or YAML. Such a detailed walk-through fosters clarity and confidence among data engineers eager to get started with Cube.

3. Data Model, Cubes and Views

Once the data model is in place, Rory elaborated on the concept of cubes and views within the architecture. He showed how one could create measures within the data model and highlight the accessibility feature. The users can control the visibility of these views and either make them public or maintain their privacy, substantiating the robust access control mechanics synonymous with Cube.

4. Business Intelligence Integration

The integration of Cube with business intelligence (BI) tools offers an expanded horizon of functionalities. Rory exhibited the process using Preset as a reference BI tool. Key steps in the integration process involve creating a sync in the BI integration tab, generating an API key, and kickstarting the sync. Additionally, the Cube Playground provides a platform to test and visualize data efficiently and intuitively.

5. Advanced Features

The final segment of the webinar explored the creation of pre-aggregations in Cube Cloud for faster query processing, an invaluable technique for data engineers. Moreover, Rory introduced the query history feature, offering insights into individual queries' specifics and data blend options using roll-up joins. Cube Cloud's advanced features such as security context and multi-tenancy further enhance its functionality, setting a new bar for modern data handling tools.