Snowflake - Download Query Results to Workflows
Overview
Turn the results of your SQL SELECT statement into a CSV file. Extract your Snowflake data into files for easier delivery to clients and partners.
Variables
Name | Reference | Type | Required | Default | Options | Description |
---|---|---|---|---|---|---|
Username | SNOWFLAKE_USERNAME | Alphanumeric | ✅ | None | - | The Snowflake Username that has access to the table, schema, and warehouse that you want to use. |
Password | SNOWFLAKE_PASSWORD | Password | ➖ | None | - | The password associated with your Username. |
Account Name | SNOWFLAKE_ACCOUNT | Alphanumeric | ✅ | None | - | Typically found in the URL you use to access Snowflake, before `.snowflakecomputing.com`. |
Warehouse | SNOWFLAKE_WAREHOUSE | Alphanumeric | ➖ | None | - | The name of the Warehouse you want your query to run in. If left blank, will use the default Warehouse associated with the Username. |
Database | SNOWFLAKE_DATABASE | Alphanumeric | ✅ | None | - | The name of the Database that you want to run a query against. |
Schema | SNOWFLAKE_SCHEMA | Alphanumeric | ➖ | None | - | The name of the Schema you want to run a query against. If left blank, it's expected that your query will include the schema in it. |
Query | SNOWFLAKE_QUERY | Alphanumeric | ✅ | None | - | A SQL query with a SELECT statement that returns data. |
Workflows File Name | SNOWFLAKE_DESTINATION_FILE_NAME | Alphanumeric | ✅ | None | - | The file name that you want your generated CSV to have. |
Workflows Folder Name | SNOWFLAKE_DESTINATION_FOLDER_NAME | Alphanumeric | ➖ | None | - | The folder structure that you want your CSV to be created in. If left blank, the file will be created in the home directory. |
Include Column Names as Header? | SNOWFLAKE_FILE_HEADER | Boolean | ✅ | True | - | If checked, your CSV file will include a header row with column names. |
User Role | SNOWFLAKE_USER_ROLE | Alphanumeric | ➖ | - | - | The optional role of the database user |
Private Key | SNOWFLAKE_PRIVATE_KEY | Alphanumeric | ➖ | - | - | The optional private key to use for authentication |
Private Key Passphrase | SNOWFLAKE_PRIVATE_KEY_PASSPHRASE | Password | ➖ | - | - | The passphrase for the private key file. Is required only if authenticating with private key |
YAML
Below is the YAML template
source:
template: Snowflake - Download Query Results to Workflows
inputs:
SNOWFLAKE_USERNAME:
SNOWFLAKE_PASSWORD:
SNOWFLAKE_ACCOUNT:
SNOWFLAKE_WAREHOUSE:
SNOWFLAKE_DATABASE:
SNOWFLAKE_SCHEMA:
SNOWFLAKE_QUERY:
SNOWFLAKE_DESTINATION_FILE_NAME:
SNOWFLAKE_DESTINATION_FOLDER_NAME:
SNOWFLAKE_FILE_HEADER: true
SNOWFLAKE_USER_ROLE:
SNOWFLAKE_PRIVATE_KEY:
SNOWFLAKE_PRIVATE_KEY_PASSPHRASE:
type: TEMPLATE
guardrails:
retry_count: 1
retry_wait: 0h0m0s
runtime_cutoff: 1h0m0s
exclude_exit_code_ranges:
- 200
- 201
- 202
- 203
- 204
- 205
- 206
- 207
- 208
- 209
- 249
- 101
- 102
- 103
- 104
- 105
- 106
- 107