You will connect Elementary Cloud to Databricks for syncing the Elementary schema (created by the Elementary dbt package).

​
Create service principal

  1. In your Databrick console, go to the admin settings by clicking your username in the to right corner -> Admin settings (add photo)
  1. Go to the Service principals tab, then click Add service principal (add photo)
  1. Give the service principal a good name (e.g elementary) and click Add (add photo)
  1. Then, from the service principal configuration view, copy the Application Id (add photo)
  1. Finally, run the following query:
GRANT SELECT ON SCHEMA <elementary_schema> TO `<service_principal_id>`;

Make sure to replace the <elementary_schema> and <service_principal_id> placeholders with the correct values

​
Permissions and security

Elementary cloud doesn't require read permissions to your tables and schemas, but only the following:

  • Read-only access to the elementary schema.
  • Access to read metadata in information schema and query history, related to the tables in your dbt project.

It is recommended to create a user using the instructions specified above to avoid granting excess privileges. For more details, refer to security and privacy.

​
Fill the connection form

Provide the following fields:

  • Host: The hostname of your Databricks account to connect to.
  • Http path: The path to the Databricks cluster or SQL warehouse.
  • Token: The token you generated for Elementary. For more information, see Generate a token in the Databricks docs.
  • Catalog (optional): The name of the Databricks Catalog.
  • Elementary schema: The name of your Elementary schema. Usually [schema name]_elementary.

​
Add the Elementary IP to allowlist

Elementary IP for allowlist: 3.126.156.226

​
Need help with onboarding?

We can provide support on Slack or hop on an onboarding call.

RedshiftPostgres