Step 1: How to Setup a Snowflake Data Warehouse
This guide will explain how to setup a Snowflake Data Warehouse instance. Once you have your instance ready we will see how to connect to Blendo in order to send your data to Snowflake.
If you already have a Snowflake instance read how to connect Snowflake to Blendo.
What will you need to setup Snowflake Setup
To set up Snowflake and connect it with Blendo, you need:
- A Snowflake account.
- ACCOUNTADMIN role privileges in Snowflake, OR privileges equivalent to the SECURITYADMIN and SYSADMIN roles. More info on Snowflake’s user roles can be found here.
- Familiarity with Snowflake’s SQL Worksheet feature OR access to to a SQL client.
- This tutorial will use the SQL Worksheet in the Snowflake web app to run SQL commands
Setup Snowflake Account
1. Click on Warehouses (you may try the Worksheet option too).
You may also create a data warehouse in SQL with CREATE WAREHOUSE command. Read more here.
Create a Snowflake Database
3. Add a Name
4. Click Finish.