Skip to content

Connect to Dremio Cloud

3 min read · Updated 9 Nov 2026

This guide connects Astrato to Dremio Cloud. When you finish, the connection appears in Data & AI → Data Connections and you can build a semantic layer on it. The form is the one described in Data connections; this page covers what is specific to Dremio.

  • Astrato permission. You need a workspace role that can create data connections: Owner, Admin or Creator. See Create a connection for how to check your role.
  • A Dremio personal access token. Create one in Dremio Cloud; see Dremio’s personal access tokens. This is the only sign-in method: Astrato does not accept a Dremio username and password.
  • Your Dremio Cloud region’s domain: eu.dremio.cloud for the EU control plane, or dremio.cloud for the US one. Astrato adds the api. and data. prefixes itself.
  • Access in Dremio for the token’s user to the project and the source or space you want to read.

You do not need the project’s name or ID: after validating, you choose the project from the ones the token can reach.

  1. Open Data & AI → Data Connections, select New connection and choose Dremio. The panel becomes New Dremio connection.

  2. Under Authentication, paste the token into Personal access token.

  3. Under Connection details, enter the Host, such as eu.dremio.cloud. There is no port to enter.

    The New Dremio connection panel with a masked Personal access token under Authentication and Host eu.dremio.cloud under Connection details, above the Validate Connection button, and Project and Source under Data to use waiting for validation

  4. If your workspace shows Deployment Region, choose one or leave it for now; see Choose a Deployment Region.

  5. Select Validate Connection. The Validation result reads “Connected to Dremio in n ms.”

  6. Under Data to use, choose a Project. If the token reaches only one project, it is chosen for you. The Source list then shows that project’s sources and spaces; choosing another project lists its sources instead.

  7. Choose a Source. Schema is optional.

    The New Dremio connection panel after validating: Connected to Dremio in 140 ms, Data to use with Project Sales analytics and Source sales_space chosen, and the Connection name above the Save connection button

  8. Review the Connection name, select Save connection, then choose a schema or leave it for later and select Finish.

If you save without choosing a schema, the source you selected is used as the schema.

Personal access tokens expire. To give a saved connection a new one, select the pencil (Edit connection) on its row in Data & AI → Data Connections, select Replace personal access token, paste the new token, select Validate Connection and then Save changes.

Symptom Fix
Validation fails with a host such as api.eu.dremio.cloud Enter only the region’s domain, eu.dremio.cloud or dremio.cloud
“Connection validation failed: the source refused the credentials or sign-in.” The token is wrong, expired or revoked. Create a new one in Dremio and paste it again
The Project list is empty after validating The token’s user has no project it can use. Ask a Dremio administrator to add it to the project
A source is missing from the Source list The token’s user has no access to it in that project. Grant access in Dremio, or choose the project that holds it
A saved connection stops working The token may have expired. Replace the token

When a data connection will not validate explains every notice the panel shows.