This entry-level lab introduces you to the user interface and basic capabilities of both Snowflake and Sigma, and how to use both solutions to build analytics. After the lab you should be ready to load your own data into Snowflake, analyse and visualise it with Sigma.
What you'll learn
The exercises in this lab will walk you through the steps to:
- Create databases, tables, stages and warehouses
- Load structured and semi-structured data
- Use Partner Connect to start up a free Sigma trial account connected to Snowflake
- Explore and analyse data and turn it into visualisations and dashboards
What you'll need:
1) AÂ Snowflake free 30-day trial environment: https://trial.snowflake.com
2) Download .SQL file: https://sigma-snowflake-vhol.s3-us-west-1.amazonaws.com/sql/sigma_vhol.sql
What you'll build:
By walking through this lab you will:
- Sign up for a Snowflake free trial and load the instance with some sample data
- Create a Sigma free trial through Snowflake Partner Connect
- Build a Sigma Dataset that models the sample data in Snowflake
- Build a polished Sigma Workbook that analyzes the sample data
Steps to Prepare Your Lab Environment:
Register for a Snowflake free 30-day trial at https://trial.snowflake.com
You will have different Snowflake editions (Standard, Enterprise, e.g.), cloud providers (GCP, AWS, or Azure), and Regions (US Central, Europe West, e.g.) Available to you.
We suggest you select the cloud provider and region which is physically closest to you and your data, and select the Enterprise edition so you can leverage advanced capabilities that are not available in the Standard Edition.
After registering, you will receive an email with an activation link and your Snowflake account URL. Bookmark this URL for easy, future access. After activation, you will create a username and password. Write down these credentials.
Click here and download the "sigma_vhol.sql" file to your local machine. This file contains pre-written SQL commands and we will use this file later in the lab.
