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).
2. Click Create.
- Name: A name for your instance
- Size: The size of your data warehouse. It could be something like X-Small, Small, Large, X-Large, etc.
- Auto Suspend: This is the time of inactivity after which your warehouse is automatically suspended.
- Auto Resume: If the warehouse is suspended, it will be automatically resumed the next time a query is issued. If you do not enable it, you will need to start the warehouse from the Snowflake web interface or using ALTER WAREHOUSE command.
You may also create a data warehouse in SQL with CREATE WAREHOUSE command. Read more here.
Create a Snowflake Database
Next, we’ll create a database.
1. Click on Databases
2. Click on Create
3. Add a Name
4. Click Finish.