Introduction to Snowflake

Start Free Preview

Buying via our links supports this free directory · Affiliate disclosure.
Course facts
  • Payment: Free Preview (Paid Upgrade)
  • Learning style: Self-paced, start anytime
  • Format: Text & Interactive
  • Video access: Streaming Only
  • Before you start: Intermediate SQL
DataCamp details
  • Chapters: 2
Created byDataCamp
Available onDataCamp

Course Details
Learning Style

Start Anytime

Level

Beginner

Study Mode

100% Online

Duration

Short (< 10 Hours)

Languages
Audio Language

English

Outcomes
Certificate

Certificate of Completion

Price & Terms
Pricing Model

Free Preview (Paid Upgrade)

Technical
Content Medium

Text & Interactive

Video Access

Streaming Only

Specification
Access

Subscription

SKU: introduction-snowflake Category: Tags: , , , Brand:

Learn to query tables in Snowsight, track query activity, load data into Snowflake and set up roles, users and warehouses for access.

At a glance
Duration2 hrs
LevelBeginner
CertificateCertificate of Completion
LanguageEnglish
Taught byDanny Hong
AccessSubscription
Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare

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.


Our take

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.

User Reviews

0.0 out of 5
★★★★★
0
★★★★★
0
★★★★★
0
★★★★★
0
★★★★★
0

No reviews yet. Be the first to review this course.

There are no reviews yet.

Write your review

Reviews can only be posted by registered learners. Log in, then you will return here to post.

×

    Report this page
    Introduction to Snowflake
    Introduction to Snowflake
    LiveTalent
    Logo
    Compare items
    • Total (0)
    Compare
    0