# Snowflake

[Snowflake](https://www.snowflake.com/) can either be used as a data
source or a data destination in Zuar Runner.

.. image:: assets/snowflake-1.png
   :alt: Zuar Runner and Snowflake

Source plugin example: [Query](/jobs/query/)

Destination plugin examples: [CSV](/jobs/csv/),
[Salesforce](/connectors/salesforce/),
[SQL](/jobs/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](/databases/database-urls/)
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](https://docs.snowflake.com/en/user-guide/connecting.html#your-snowflake-account-name).

Here's an example of using a Snowflake database as a destination in a
[CSV](/jobs/csv/) job:

.. image:: assets/snowflake__output.png
   :alt: CSV JOB

.. 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](/jobs/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](https://www.zuar.com/blog/snowflake-cheat-sheet/)