Snowflake - Execute Query
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.
|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 |
|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 |
Below is the YAML template for this Blueprint and can be used in the Fleet YAML Editor.
blueprint: Snowflake - Execute Query
SNOWFLAKE_USERNAME: null ## REQUIRED
SNOWFLAKE_PASSWORD: null ## REQUIRED
SNOWFLAKE_ACCOUNT: null ## REQUIRED
SNOWFLAKE_DATABASE: null ## REQUIRED
SNOWFLAKE_QUERY: null ## REQUIRED