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 execute a query against.
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 ;

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"