Cube.js is an open-source analytical API platform that empowers developers to build custom and scalable analytics solutions. By acting as an intermediary between your data sources and front-end applications, Cube.js simplifies the process of querying large datasets and ensures efficient data management and visualization.Integrating Cube.js with Firebolt significantly enhances the data processing capabilities of your analytics stack. Firebolt’s ability to execute complex queries with minimal latency aligns perfectly with Cube.js’s goal of delivering fast and responsive analytics. As a result, users benefit from a seamless and highly performant analytics experience, making it an ideal solution for businesses looking to scale their data operations without compromising on speed or efficiency.
Follow these steps to quickly connect Cube.js to Firebolt and start building powerful analytics solutions using Docker. For this demo we’ll be using Cube Core. For other deployment options follow the Cube documentation.
Docker: Ensure you have Docker installed. You can download it from here.
Firebolt Account: You need an active Firebolt account. Sign up here if you don’t have one.
Firebolt Database and Table: Make sure you have a Firebolt database and table with data ready for querying. Follow our Getting started tutorial to set up some sample data.
Firebolt Service Account: Create a service account in Firebolt and note its id and secret.
The Playground has a database connection wizard that loads when Cube is first started up and no .env file is found. After database credentials have been set up, an .env file will automatically be created and populated with credentials.
Select measures, dimensions and filters to explore your data!Congratulations! You have successfully connected Cube.js to Firebolt and can now start building high-performance analytics solutions. For more detailed configuration and advanced features, refer to the Cube.js documentation and Firebolt documentation.
After setting up Cube.js with Firebolt, you can explore and leverage several powerful features to enhance your analytics capabilities. Here are some resources to help you get started:
Cube.js Data Blending: Understand how to combine data from different sources for more comprehensive analysis.
Cube.js Data Blending Documentation
Cube.js Security: Implement row-level security to ensure your data is accessed appropriately.
Cube.js Security Documentation
Cube.js API: Explore the Cube.js REST API to programmatically access your data and build custom integrations.
Cube.js API Reference
Cube.js Visualization Tools: Build and deploy powerful dashboards using Cube.js and your favorite front-end frameworks.
Cube.js Visualization Tools
These resources will help you unlock the full potential of Cube.js and create robust, high-performance analytics solutions.