We are pleased to announce the release of SQL Runner 0.6.0, with support for running SQL queries in parallel and in series on the Snowflake cloud data warehouse.
You’ll find the release notes here:
How to use
Programmatically running SQL against Snowflake is now as simple as preparing a playbook for SQL Runner which looks like this - note the new Snowflake-specific database configuration:
targets: - name: "My Snowflake database" type: snowflake account: ADD HERE # Your Snowflake account name region: ADD HERE # Leave blank for default us-east-1 database: ADD HERE # Name of database warehouse: ADD HERE # Name of warehouse to run the queries username: ADD HERE password: ADD HERE host: # Leave blank port: # Leave blank ssl: true # Snowflake connection is always secured by TLS variables: foo: bar steps: - name: ADD HERE queries: - name: ADD HERE file: ADD REL/ABS PATH template: true - name: ADD HERE queries: - name: ADD HERE file: ADD REL/ABS PATH template: true - name: ADD HERE file: ADD REL/ABS PATH template: true
For existing Postgres and Redshift users
Using SQL Runner 0.6.0 against Postgres and Redshift targets is unchanged from the 0.5.x series.
Snowflake support at Snowplow
We added this support to SQL Runner to complement the Snowplow Snowflake loader that we recently released - check it out here:
Expect more database technologies to be added to SQL Runner over the coming 12 months!