Introduction to Snowflake
Learn to query tables in Snowsight, track query activity, load data into Snowflake and set up roles, users and warehouses for access.
Snowflake holds an organization’s data in the cloud, but working with it means knowing where tables live, how queries run and who is allowed to see what. The lessons stay inside Snowsight, the platform’s UI tool, to browse databases and schemas, run and inspect SQL queries, and review past activity. They then bring in outside data through CSV uploads, Marketplace listings and cloud storage, and set up roles, users and warehouses so access stays controlled.
What You Will Achieve
- Find a database, schema and table in Snowsight and run a SQL query against it
- Check Query History and Copy History to see what recent queries and data loads did
- Bring external data into Snowflake through a CSV upload, a Marketplace listing or a cloud stage
- Set up new roles, users and warehouses to control who can reach which data
Program Overview
Snowflake Basics and the Snowsight UI
Introduces Snowflake and its UI tool, then works through finding tables, running queries and reviewing what has run.
- What Snowflake is and why companies use it
- Navigating databases, schemas and tables
- Running queries on sales and product category data
- Query details, Query History, Copy History and Python worksheets
Managing Data and Access in Snowsight
Covers several ways to load data and to control access, and ends with a first notebook.
- Snowflake Marketplace data
- CSV uploads and loading data held on AWS, GCP or Azure
- Tables created with an external stage
- Roles, users, warehouses and notebooks
Certificate Awarded (Paid)
Complete the course to earn it.
Job Outlook
Snowsight skills apply in data engineering, data analysis and business intelligence work at organizations that run their data warehouse on Snowflake.
Good for: Data analysts, data engineers and BI professionals who are starting to work in Snowflake and want to find their way around Snowsight.
Keep in mind: The lessons center on the Snowsight interface, loading data and setting up roles; no lesson is devoted to tuning queries or performance.
Bottom line: A practical tour of Snowsight that pairs querying and monitoring with loading data and creating roles, users and warehouses.
Frequently Asked Questions
Which data sources can I load into Snowflake in the lessons?
The second chapter loads data in several ways: a Snowflake Marketplace listing, an uploaded CSV file, data kept with a cloud provider such as AWS, GCP or Azure, and a table created with an external stage.
What is the difference between Query History and Copy History?
The course presents them as two monitoring tools in Snowsight: Query History tracks the queries that have run, while Copy History tracks data loads. A separate lesson opens a single query's details to inspect it.
How is access control handled in the lessons?
Learners create new roles, users and warehouses in Snowsight, and the course frames these settings around least-privilege access, so each role receives only the privileges its workload actually requires.
Does the course use Python as well as SQL?
Most of the work is SQL queries in Snowsight, but the first chapter includes a lesson exploring Python worksheets, and the second chapter closes with creating a first notebook.


There are no reviews yet.