SQL Runner 0.6.0 released with Snowflake database support


#1

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!