Connect to Snowflake
Join our Cube Cloud Office Hours on August 23rd (opens in a new tab) to jumpstart your Cube Cloud account and gain insights on connecting data sources, creating data models, and integrating your data apps.
In this section, we’ll create a Cube Cloud deployment and connect it to Snowflake. A deployment represents a data model, configuration, and managed infrastructure.
To continue with this guide, you'll need to have a Cube Cloud account. If you don't have one yet, click here to sign up (opens in a new tab) for free.
First, sign in to your Cube Cloud account (opens in a new tab). Then, click Create Deployment:
Give the deployment a name, select the cloud provider and region of your choice, and click Next:
Next, click Create to create a new project from scratch:
The last step is to connect Cube Cloud to Snowflake. First, select it from the grid:
Then enter your Snowflake credentials:
- Username: Your Snowflake username. Please note, it is usually not your email address.
- Password: Your Snowflake password.
CUBE_DEMO, that is the database we've created in the previous step.
- Account: Your snowflake account identifier. You can find it in your
Snowflake URL as the
- Region: Your Snowflake account region. You can find it in your Snowflake
URL. If your URL includes a
cloudpart, use both the
us-east-2.aws, otherwise just use
CUBE_DEMO_WH, that is the warehouse we've created in the previous step.
- Role: You can leave it blank.
Click Apply, Cube Cloud will test the connection and proceed to the next step.
Cube can now generate a basic data model from your data warehouse schema, which
helps getting started with data modeling faster. Select all four tables in our
ECOM schema and click through the data model generation wizard. We'll inspect
these generated files in the next section and start making changes to them.