Skip to main content

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​

NameReferenceTypeRequiredDefaultOptionsDescription
UsernameSNOWFLAKE_USERNAMEAlphanumericβœ…--The Snowflake Username that has access to the table, schema, and warehouse that you want to execute a query against.
PasswordSNOWFLAKE_PASSWORDPasswordβœ…--The password associated with your Username.
Account NameSNOWFLAKE_ACCOUNTAlphanumericβœ…--Typically found in the URL you use to access Snowflake, before .snowflakecomputing.com
WarehouseSNOWFLAKE_WAREHOUSEAlphanumericβž–--If left blank, will use the default warehouse associated with the provided username.
DatabaseSNOWFLAKE_DATABASEAlphanumericβœ…--The name of the Database that you want to run a query against.
SchemaSNOWFLAKE_SCHEMAAlphanumericβž–--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.
QuerySNOWFLAKE_QUERYAlphanumericβœ…--The contents of the SQL query that you want to run. Does not support running multiple queries separated by ;

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 ## REQUIRED
SNOWFLAKE_ACCOUNT: null ## REQUIRED
SNOWFLAKE_WAREHOUSE: null
SNOWFLAKE_DATABASE: null ## REQUIRED
SNOWFLAKE_SCHEMA: null
SNOWFLAKE_QUERY: null ## REQUIRED
type: BLUEPRINT
guardrails:
retry_count: 1
retry_wait: 0s
runtime_cutoff: 1h0m0s
exclude_exit_code_ranges:
- "200-205"