Databricks

Before you start

You need a Databricks workspace with a SQL Warehouse or cluster, plus a token or service principal with access to the catalog and schema Querio should query.

1. Create an access token

What: Create a token Querio can use to authenticate.

How:

1. In Databricks, open your user settings
2. Go to Developer > Access tokens
3. Click Generate new token
4. Give it a clear description
5. Copy the token and store it securely

For production, use a service principal when possible.

2. Find connection details

What: Get the server hostname and HTTP path.

How:

1. Go to SQL Warehouses
2. Open the warehouse Querio should use
3. Open Connection details
4. Copy the Server hostname and HTTP path

3. Grant catalog and schema permissions

What: Give the token identity read access to the target catalog and schema.

GRANT USE CATALOG ON CATALOG my_catalog TO `querio-service-principal@domain.com`;
GRANT USE SCHEMA ON SCHEMA my_catalog.my_schema TO `querio-service-principal@domain.com`;
GRANT SELECT ON SCHEMA my_catalog.my_schema TO `querio-service-principal@domain.com`;

4. Share the connection details

Provide the token, server hostname, HTTP path, catalog, and schema to Querio.