Create a Snowflake Warehouse and load data!

What is snowflake ?

Snowflake is a cloud-based data warehouse that runs on Cloud platforms like Amazon Web Services or Microsoft Azure. It's great for enterprises that don't want to devote resources to the setup, maintenance, and support of in-house servers because there's no hardware or software to choose, install, configure, or manage.

Customers can utilize and pay for storage and computing separately thanks to the Snowflake architecture, which allows storage and compute to scale independently. Furthermore, the sharing feature enables enterprises to instantly communicate controlled and secure data in real time.

Benefits of snowflake
  1. Performance and speed
    The cloud infrastructure allows auto scaling which adds performance and speed.
  2. Storage and support for structured and semi structured data
    For analysis, you can aggregate structured and semi structured data and load it into a cloud database without first converting or transforming it into a set relational schema.
  3. Concurrency and accessibility
    Snowflake's innovative multi cluster architecture addresses concurrency issues: queries from one virtual warehouse never influence queries from another, and each virtual warehouse may scale up or down as needed.
  4. Seamless data sharing
    Snowflake’s architecture enables data sharing among Snowflake users.
  5. Availability and security
    Snowflake is dispersed throughout the platform's availability zones, which are either AWS or Azure, and is designed to function continuously while tolerating component and network failures with minimal impact on users. It is SOC 2 Type II certified, and it offers additional security features such as PHI data support for HIPAA clients and encryption across all network connections.

Creating trial account

Go to the signup location at : https://signup.snowflake.com/ and create an account.

Validate your account via email and create an instance account in snowflake instance.

After clicking on the activation link, you need to choose an username and password.

You will have an unique URL generated for your account as below:


Exploring Snowflake ❄

Now, our account is all set! We can start exploring Snowflake ❄

  1. Create a new database -
    Select Database and click create Table
    2-2
    Next Create a database
    3-1
  2. Create a new table -
    Select the newly created database
    Now create a table with some columns. In my case it's employees
    4-2
    You can see the table created
    5-1
  3. Load Data with CSV
    Select Load Table
    load_tabl_1-1
    Select Warehouse
    1-3
    Select CSV as data
    load_tabl_select_csv
    Select file format as CSV
    load_tabl_select_dt
    Select load options
    Here, I will skip all errors and load valid data
    load_tabl_2
    Finally, data is loaded
    load_tabl_loaded

Thus we now have our very first hands on with Snowflake.

Hope you liked it. Cheers. 🍻

Tirthankar Kundu

Tirthankar Kundu