Snowflake - Execute Query
Overviewβ
Execute a query against Snowflake, without returning any of the resulting data. This Blueprint should primarily be used for queries that perform functionality other than SELECT, like multi-step SQL jobs, or DML statements.
This Blueprint is limited to executing a single query. You cannot run multiple queries separated by ;
(this is prohibited by the Snowflake Python connector). Instead, you'll have to set up multiple Vessels with this Blueprint to run one after the other.
Variablesβ
Name | Reference | Type | Required | Default | Options | Description |
---|---|---|---|---|---|---|
Username | SNOWFLAKE_USERNAME | Alphanumeric | β | - | - | The Snowflake Username that has access to the table, schema, and warehouse that you want to use. |
Password | SNOWFLAKE_PASSWORD | Password | β | - | - | The password associated with your Username. |
Account Name | SNOWFLAKE_ACCOUNT | Alphanumeric | β | - | - | Typically found in the URL you use to access Snowflake, before .snowflakecomputing.com |
Warehouse | SNOWFLAKE_WAREHOUSE | Alphanumeric | β | - | - | If left blank, will use the default warehouse associated with the provided username. |
Database | SNOWFLAKE_DATABASE | Alphanumeric | β | - | - | The name of the Database that you want to run a query against. |
Schema | SNOWFLAKE_SCHEMA | Alphanumeric | β | - | - | 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 | β | - | - | The contents of the SQL query that you want to run. Does not support running multiple queries separated by ; |
User Role | SNOWFLAKE_USER_ROLE | Alphanumeric | β | - | - | The optional role for 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 a private key |
YAMLβ
Below is the YAML template for this Blueprint and can be used in the Fleet YAML Editor.
source:
blueprint: Snowflake - Execute Query
inputs:
SNOWFLAKE_USERNAME: null ## REQUIRED
SNOWFLAKE_PASSWORD: null
SNOWFLAKE_ACCOUNT: null ## REQUIRED
SNOWFLAKE_WAREHOUSE: null
SNOWFLAKE_DATABASE: null ## REQUIRED
SNOWFLAKE_SCHEMA: null
SNOWFLAKE_QUERY: null ## REQUIRED
SNOWFLAKE_USER_ROLE: null
SNOWFLAKE_PRIVATE_KEY: null
SNOWFLAKE_PRIVATE_KEY_PASSPHRASE: null
type: BLUEPRINT
guardrails:
retry_count: 1
retry_wait: 0h0m0s
runtime_cutoff: 1h0m0s
exclude_exit_code_ranges:
- '101'
- '102'
- '103'
- '104'
- '105'
- '106'
- '107'
- '200'
- '201'
- '202'
- '203'
- '204'
- '205'
- '206'
- '207'
- '208'
- '209'
- '249'