Snowflake Source
Snowflake is a cloud-based data platform.
less than a minute
About
Snowflake is a cloud data platform that provides a data warehouse-as-a-service designed for the cloud.
Available Tools
Snowflake Source Tools
| Tool Name | Description |
|---|---|
| snowflake-execute-sql Tool | A "snowflake-execute-sql" tool executes a SQL statement against a Snowflake database. |
| snowflake-sql Tool | A "snowflake-sql" tool executes a pre-defined SQL statement against a Snowflake database. |
Requirements
Database User
This source only uses standard authentication. You will need to create a Snowflake user to login to the database with.
Example
kind: sources
name: my-sf-source
type: snowflake
account: ${SNOWFLAKE_ACCOUNT}
user: ${SNOWFLAKE_USER}
password: ${SNOWFLAKE_PASSWORD}
database: ${SNOWFLAKE_DATABASE}
schema: ${SNOWFLAKE_SCHEMA}
warehouse: ${SNOWFLAKE_WAREHOUSE}
role: ${SNOWFLAKE_ROLE}
Tip
Use environment variable replacement with the format ${ENV_NAME} instead of hardcoding your secrets into the configuration file.
Reference
| field | type | required | description |
|---|---|---|---|
| type | string | true | Must be “snowflake”. |
| account | string | true | Your Snowflake account identifier. |
| user | string | true | Name of the Snowflake user to connect as (e.g. “my-sf-user”). |
| password | string | true | Password of the Snowflake user (e.g. “my-password”). |
| database | string | true | Name of the Snowflake database to connect to (e.g. “my_db”). |
| schema | string | true | Name of the schema to use (e.g. “my_schema”). |
| warehouse | string | false | The virtual warehouse to use. Defaults to “COMPUTE_WH”. |
| role | string | false | The security role to use. Defaults to “ACCOUNTADMIN”. |
| timeout | integer | false | The connection timeout in seconds. Defaults to 60. |
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.