Note: We currently support Dremio Cloud only. If you are using Dremio Software, please contact us for assistance.

​
Create a user for Elementary cloud

Create an email account for the Elementary user. Example: [email protected] On your dbt project, run: 
## Print the query you should run to generate a user.
dbt run-operation create_elementary_user --args '{user: the_mail_of_the_elementary_user}'
This command will generate a query to create a user with the necessary permissions. Run this query on your data warehouse with admin permissions to create the user. It will send an email invitation, you need to accept that invitation. After the invitation was accepted, you need to sign in to Dremio as the Elementary user, and open “Account Settings” by clicking on the bottom-left corner of the Dremio UI. Click Generate Token:
Generate Token in Dremio
Set the maximum lifetime allowed by Dremio (currently 180 days). ⚠️ Put a reminder to renew the token before it expires. You can update the token in Elementary’s UI at any time.

​
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:
    • US: api.dremio.cloud
    • EU: api.eu.dremio.cloud
  • Object Storage: Name of the object storage where the Elementary schema is stored.
  • Object Storage Path: Path inside the object storage where the Elementary schema is stored.
  • Project ID: Your Dremio Cloud project ID.
  • User: The email address of the Elementary user.
  • Token: The token you generated for the Elementary user.

​
Need help with onboarding?

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