Category: SQL Status: base
Connects to Snowflake — a cloud data warehouse. Supports browsing databases and schemas, running SQL queries, and transferring tables.
| Field | Default | Description |
|---|---|---|
| host | localhost | Snowflake account hostname (e.g. myorg-myaccount.snowflakecomputing.com) |
| account | (empty) | Snowflake account identifier |
| user | (empty) | Username |
| password | (empty) | Password |
| dbname | (empty) | Database name |
| schema | (empty) | Default schema |
| warehouse | (empty) | Virtual warehouse name |
| url | (empty) | Full connection URL (overrides above) |
Snowflake username and password. Key-pair authentication can be configured via the connection URL.
Requires the snowflake-connector-python Python package:
pip install snowflake-connector-python