Back to Cube

Connect to Databricks

docs/content/product/getting-started/databricks/connect-to-databricks.mdx

1.6.432.5 KB
Original Source

Connect to Databricks

In this section, we’ll create a Cube Cloud deployment and connect it to Databricks. 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 for free.

First, sign in to your Cube Cloud account. Then, click <Btn>Create Deployment</Btn>:

Give the deployment a name, select the cloud provider and region of your choice, and click <Btn>Next</Btn>:

<Screenshot alt="Cube Cloud Create Deployment Screen" src="https://ucarecdn.com/2338323e-0db8-4224-8e7a-3b4daf9c60ec/" />

<InfoBox>

Microsoft Azure is available on Enterprise and above plans. Contact us for details.

</InfoBox>

Set up a Cube project

Next, click <Btn>Create</Btn> to create a new project from scratch:

<Screenshot alt="Cube Cloud Upload Project Screen" src="https://ucarecdn.com/46b72b61-b650-4271-808d-55203f1c8d8b/" />

Connect to your Databricks

The last step is to connect Cube Cloud to Databricks. First, select it from the grid:

<Screenshot alt="Cube Cloud Setup Database Screen" src="https://ucarecdn.com/1d656ba9-dd83-4ff4-a59e-8b5f97a9ddcc/" />

Then enter your Databricks credentials:

  • Access Token: A personal access token for your Databricks account. You can generate one in your Databricks account settings.
  • Databricks JDBC URL: The JDBC URL for your Databricks SQL warehouse. You can find it in the SQL warehouse settings screen.
  • Databricks Catalog: This should match the same catalog where you uploaded the files in the last section. If left unspecified, the default catalog is used.

Click <Btn>Apply</Btn>, Cube Cloud will test the connection and proceed to the next step.

Generate data model from your Databricks schema

Cube can now generate a basic data model from your data warehouse, which helps getting started with data modeling faster. Select all four tables in our catalog and click through the data model generation wizard. We'll inspect these generated files in the next section and start making changes to them.