Get Started with Snowflake

Snowflake is an SQL analytic data warehouse provided as Software-as-a-Service (SaaS). It is built from the ground up for the cloud, with a new architecture to handle data and analytics. Snowflake provides a data warehouse that is faster, easier to use, and far more flexible than traditional data warehouses.

A few words to get started with Snowflake as data warehouse destination

Snowflake runs completely on cloud infrastructure. At this time, Snowflake runs on Amazon Web Services (AWS) and uses AWS EC2 compute instances and S3 for persistent storage of data.

Read more about Snowflake on their website.

Snowflake’s pricing model

Pricing for Snowflake is based on the volume of data you store in Snowflake and the compute hours you use.Snowflake offers multiple editions: for usage-based pricing with no long-term commitments, choose the On Demand, for to secure price discounts choose a pre-purchased Capacity option. You are more than welcome to check the Snowflake Pricing Model.

Automating Warehouse Suspension & Resumption

You may choose to automate the management of your Snowflake warehouse. Warehouses can be set to automatically suspend when there’s no activity after a specified period of time and automatically resume when there is. Enabling/disabling auto-resume depending on how much control you wish to exert over usage of a particular warehouse. Learn more here.

Note: Blendo will only impact your Snowflake usage when loading data.

Auto Resume: Please note that Auto resume should be enabled for Blendo to be able to sent data to your Snowflake db.

Setup

In the following section we will see how to:

Snowflake tables and Schema.

As soon you connect your Snowflake data warehouse, you can start connecting data sources from Blendo.  For any of these data sources, a schema relevant to that integration will be created in your Snowflake data warehouse.


How Blendo replicates your data

Replication

Blendo replicates data from your sources based on the replication setup on each integration. The time from the sync start to data being loaded into your data warehouse can vary depending on a number of factors, especially for initial historical loads.


Next Steps:

How to Setup a Snowflake Data Warehouse.

in Snowflake