Prerequisites
- A Snowflake account.
- A user with at least read access to the target database, schema, and warehouse.
Required fields
| Field | Description | Example |
|---|---|---|
| Name | A display name for this datasource. | Graphics Press warehouse |
| Account | Your Snowflake account identifier. | xy12345.us-east-1 |
| Username | The Snowflake user. | admin |
| Password | The user’s password. | |
| Warehouse | The compute warehouse to use for queries. | COMPUTE_WH |
| Database | The database to connect to. | MY_DATABASE |
| Schema | The default schema. | PUBLIC |
Optional fields
| Field | Description | Example |
|---|---|---|
| Role | The Snowflake role to assume for the session. If omitted, the user’s default role is used. | ACCOUNTADMIN |
Steps
- Open Settings → Datasources → New.
- Enter a name and select Snowflake as the type.
- Fill in the fields above.
- Click Test connection to verify.
- Click Create.
Finding your account identifier
Your account identifier is in the URL you use to access Snowflake. For example, if you log in athttps://xy12345.us-east-1.snowflakecomputing.com, your account identifier is xy12345.us-east-1.