Snowflake Connection Guide

Delphina connects to Snowflake using a dedicated user and role. The role needs SELECT access to the data you want the agent to query, and — optionally — access to query history and Cortex Analyst objects so Delphina can learn from existing usage and semantics.

We recommend the warehouse provided be sized Small or larger so Delphina can execute queries with acceptable performance.

Connecting Snowflake

Step 1: Gather connection details

You’ll need the following from your Snowflake account:

Field	Where to find it	Example
Account identifier	Snowflake account URL (without `.snowflakecomputing.com`)	`xy12345.us-east-1`
Warehouse	Name of the warehouse Delphina should use	`DELPHINA_WH`
Database	Default database for the connection	`ANALYTICS`
Role	Role granted to the Delphina user	`DELPHINA_ROLE`

Step 2: Create the user, role, and grant data access

Run the following DDL in Snowflake. It creates a dedicated user and role and grants SELECT access to every object in a database. Prune the grants down to a smaller set of schemas/tables if you’d rather scope Delphina narrowly.

CREATE USER delphina_user <any additional user properties>;
CREATE ROLE delphina_role;
GRANT ROLE delphina_role TO USER delphina_user;

GRANT USAGE ON WAREHOUSE <warehouse_name> TO ROLE delphina_role;
GRANT USAGE ON DATABASE <database_name> TO ROLE delphina_role;

GRANT USAGE ON ALL SCHEMAS IN DATABASE <database_name> TO ROLE delphina_role;
GRANT USAGE ON FUTURE SCHEMAS IN DATABASE <database_name> TO ROLE delphina_role;

GRANT SELECT ON ALL TABLES IN DATABASE <database_name> TO ROLE delphina_role;
GRANT SELECT ON FUTURE TABLES IN DATABASE <database_name> TO ROLE delphina_role;

GRANT SELECT ON ALL VIEWS IN DATABASE <database_name> TO ROLE delphina_role;
GRANT SELECT ON FUTURE VIEWS IN DATABASE <database_name> TO ROLE delphina_role;

-- Repeat for any other relevant databases.

Step 3: Grant access to query history

Delphina uses query histories from trusted users to prioritize tables and learn how your data is used. Choose one of the two patterns below.

Option A — IMPORTED PRIVILEGES (simplest)
Option B — Scoped secure view

Give the role read access to the shared SNOWFLAKE database, which exposes ACCOUNT_USAGE.QUERY_HISTORY.

-- Read access to the SNOWFLAKE shared DB objects
GRANT IMPORTED PRIVILEGES ON DATABASE SNOWFLAKE TO ROLE delphina_role;

-- Allow the role to read account usage views
GRANT MONITOR USAGE ON ACCOUNT TO ROLE delphina_role;

If you’d rather not grant broad access to ACCOUNT_USAGE, create a secure view that exposes only the columns and lookback window Delphina needs.

CREATE OR REPLACE SECURE VIEW <database_name>.<schema_name>.QUERY_HISTORY_SCOPED AS
WITH q AS (
  SELECT
    QUERY_ID, USER_NAME, ROLE_NAME, WAREHOUSE_NAME,
    DATABASE_NAME, SCHEMA_NAME, QUERY_TEXT, START_TIME, END_TIME,
    EXECUTION_STATUS, TOTAL_ELAPSED_TIME
  FROM SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY
  WHERE START_TIME >= DATEADD(day, -365, CURRENT_TIMESTAMP())  -- pick your lookback
)
SELECT
  QUERY_ID, USER_NAME, ROLE_NAME, WAREHOUSE_NAME,
  DATABASE_NAME, SCHEMA_NAME, QUERY_TEXT, START_TIME, END_TIME,
  EXECUTION_STATUS, TOTAL_ELAPSED_TIME
FROM q;

GRANT SELECT ON VIEW <database_name>.<schema_name>.QUERY_HISTORY_SCOPED TO ROLE delphina_role;

Step 4: (Optional) Grant access to Cortex Analyst objects

If you use Snowflake Cortex Analyst and want Delphina to reuse your existing semantic definitions, grant the following additional permissions:

-- For an internal stage that holds semantic models
GRANT READ ON STAGE <db>.<schema>.<models_stage_name> TO ROLE delphina_role;

-- For semantic views
GRANT SELECT, REFERENCES
  ON SEMANTIC VIEW <db>.<schema>.<semantic_view_name>
  TO ROLE delphina_role;

Step 5: Create the connection in Delphina

Navigate to analytics.delphina.ai.
Click your name in the bottom-left, then Org Admin > Warehouse Connections.
Click Add Connection on the target workspace.
Set the Warehouse Type to Snowflake.
Fill in the account identifier, warehouse, database, role, and user credentials from the steps above.
Click Create Connection, then Test Connection to verify Delphina can reach your warehouse, list tables, and access query history.

Troubleshooting

Problem	Fix
Test Connection fails	Verify the account identifier, warehouse, and role exist and that `delphina_user` can log in with the supplied credentials.
”Browse Tables” empty	Confirm `USAGE` is granted on the database and schema, and `SELECT` on the tables. Future grants only apply to objects created after the grant.
”Show Top Users” empty	Either `IMPORTED PRIVILEGES ON DATABASE SNOWFLAKE` is missing or the scoped `QUERY_HISTORY_SCOPED` view hasn’t been shared with `delphina_role`.
Queries time out or feel slow	Size and scale the warehouse for Delphina’s workload — see Snowflake Performance & Tuning.
Cortex Analyst semantics not picked up	Check that `READ` is granted on the models stage and `SELECT, REFERENCES` on the semantic view.

Getting Started

Analytics

Context Layer

Administration

Sandbox

Legal

Snowflake Connection Guide

Connecting Snowflake

Step 1: Gather connection details

Step 2: Create the user, role, and grant data access

Step 3: Grant access to query history

Step 4: (Optional) Grant access to Cortex Analyst objects

Step 5: Create the connection in Delphina

Troubleshooting

​Connecting Snowflake

​Step 1: Gather connection details

​Step 2: Create the user, role, and grant data access

​Step 3: Grant access to query history

​Step 4: (Optional) Grant access to Cortex Analyst objects

​Step 5: Create the connection in Delphina

​Troubleshooting

Connecting Snowflake

Step 1: Gather connection details

Step 2: Create the user, role, and grant data access

Step 3: Grant access to query history

Step 4: (Optional) Grant access to Cortex Analyst objects

Step 5: Create the connection in Delphina

Troubleshooting