Snowflake¶
Snowflake can either be used as a data source or a data destination in Zuar Runner.
![Zuar Runner and Snowflake](../_images/snowflake-1.png)
Source plugin example: Query
Destination plugin examples: CSV, Salesforce, SQL
Snowflake as a Data Destination¶
Zuar Runner automatically creates the Snowflake database schema if it doesn’t exist
Zuar Runner automatically creates the Snowflake database tables if they don’t exist
Zuar Runner automatically determines data types for Snowflake columns
Zuar Runner automatically adds new columns to Snowflake tables based on new fields in source systems
Zuar Runner automatically adjusts Snowflake tables based on changes in source data
Snowflake Specific Setup¶
Below is the database url structure for connecting to a Snowflake database:
snowflake://<username>:<password>@<account_name>/<database>?warehouse=<warehouse>
Examples of Snowflake account_name
based on cloud platform/region:
AWS - US West (Oregon) -
xy12345
AWS - US East (Ohio) -
xy12345.us-east-2.aws
GCP - US Central1 (Iowa) -
xy12345-us-central1.gcp
Azure - West US 2 (Washington) -
xy12345.west-us-2.azure
Learn more about Your Snowflake Account Name.
Here’s an example of using a Snowflake database as a destination in a CSV job:
![CSV JOB](../_images/snowflake__output.png)
Note
When outputting to a Snowflake database, leaving the “Schema” blank will create a table in the public schema.
SQL¶
Zuar Runner can send SQL statements to a Snowflake database. Use Snowflake syntax in these Zuar Runner SQL jobs.
Cheat Sheet¶
The Zuar team has ample experience working with Snowflake. The team has created this cheat sheet to help you get started: Snowflake Cheat Sheet