Master Snowflake

Explore the Snowflake web interface, SnowSight, and its key components—worksheet, dashboards, Streamlit apps, and data marketplace—along with roles, databases, schemas, and sample data.

Explore Snowflake worksheets to write, run, filter, and visualize SQL statements using an IDE-like interface with objects, auto-complete, and clear navigation across databases, schemas, and tables.

Master Snowflake 2024 teaches you to sort and filter query results, view stats, manage query history, format queries, and download or refine results for efficient analysis.

Visualize Snowflake worksheet results by turning SQL query outputs into charts with built-in tools such as bar, line, and heat maps, and aggregations like count, sum, max, and min.

Create your first compute warehouse in Snowflake, choosing between standard and Snowpark optimized types. Configure the size, auto resume, auto suspend, and multi-cluster options to optimize performance and cost.

Create and manage Snowflake warehouses with SQL, defining type, size, cluster settings, auto suspend and resume, and deploying programmatically from Python or the worksheet.

Learn how to create a Snowflake database, define schemas, and build a stocks table with stock code, stock name, and close price, then insert and query data.

Explore the Snowflake container system and its hierarchy, then review data types, table types, constraints, loading methods, external and semi-structured data, table statistics, storage costs.

Explore the snowflake hierarchy, from account and users to roles, warehouses, and integrations, then drill into databases, schemas, and tables to understand object relationships.

Navigate the Snowflake hierarchy from account to database and schema, and learn how users, roles, warehouses, integrations, and shared objects organize tables, views, and storage.

Create and manage tables in Snowflake using describe and create table syntax, explore data types, auto increment, drop and show commands, and inspect generated DDL with get DDL.

Learn to insert data into a table with insert into, specifying columns and values, including multiple rows and auto-incremented IDs, and using fully qualified names.

Explore Snowflake text data types such as varchar, char, string, and text, plus size and encoding limits. Create a sample table, insert text data, and view ddl and queries.

Explore how Snowflake handles boolean values, including true, false, and null, and learn to create boolean tables, insert data, and query with boolean logic.

Explore Snowflake timestamps, time zones, and precision, including date, time, current timestamp defaults, and session time zone control for accurate 24-hour data in Snowflake.

Master creating a table from an existing one using create or replace table as select to copy the structure and data.

Explore how Snowflake handles constraints, showing that primary keys and unique constraints are not enforced, while not null remains enforced, with ETL considerations.

Learn bulk loading with warehouses, stages, and fast copy command, including data transformations, and contrast with continuous loading using Snowpipe for real-time updates.

Explore Snowflake data staging by comparing internal and external stages, where internal stores data within Snowflake and external stages reference data in S3, Google Cloud, or Azure, with regional costs.

Learn how to load data from Amazon Web Services to Snowflake by setting up a free AWS trial, creating an AWS account, and provisioning an S3 bucket.

Create an S3 bucket in the North Virginia region, ensure a unique bucket name, and configure access for Snowflake. Organize files in CSV and JSON folders to load into Snowflake.

Upload csv and json sample files to an S3 bucket, verify uploads of Tesla historical prices, and configure external access for loading data into Snowflake.

Create an Azure free account to access $200 credit for 30 days, authenticate with your email, and set up services to load data from Azure into the Snowflake ecosystem.

Create a storage account in Azure, set up a container, and prepare to load data from Azure to Snowflake, detailing naming, region, and security settings.

Create two storage containers named csv snowflake and json snowflake in the azure container account, upload countries.csv and movies.json, and configure an integration to access these files in Snowflake.

Set up a Snowflake storage integration to connect to Azure external storage by creating an integration object, specifying type external storage, provider Azure, tenant ID, and allowed locations.

Configure a role assignment to enable Snowflake to access an Azure storage container by granting the storage blob data contributor role and consenting to Azure authentication.

Create a csv file format and a stage in Snowflake to access an Azure csv file. Configure storage integration, reference the csv format, and verify access.

Connect Snowflake to the Azure csv stage, access countries.csv with select, define a table for country, capital, and population, and copy data from the stage into the table.

Load json data into snowflake by creating a json file format and a stage using the csv integration, then transform fields into a table and load via copy into.

Explore a two-stage load of json into Snowflake using a raw variant table, then transform into the target table, with validation of original data.

Set up a Google Cloud Platform free trial, claim $300 in credits, create a cloud storage bucket, and prepare data loading from Google Cloud to the Snowflake ecosystem.

Create and configure a Google Cloud project, set up storage buckets for CSV and JSON data, upload files, and prepare an integration object to connect Snowflake with Google Cloud.

Learn to query data from Google Cloud Storage and load CSV and JSON into Snowflake using GCS stage and copy into, then create or replace tables.

Classifies JSON data into simple, complex, sparse, and inconsistent formats, and explains how processing power scales with structure; apply flattening for Snowflake querying and validation.

Learn how Snowflake native json support validates and parses json data using the variant data type, parse_json, and a json raw table for inserting and querying nested json.

Learn how to parse json data in Snowflake, insert and query json raw, cast to specific types, access keys with column: key notation, handle case sensitivity, and alias results.

Learn to query nested json in Snowflake by accessing root and sublevels, using dot notation and array indexing to extract names, addresses, and phone lists.

Apply functions to JSON data using dot and list indices to extract phone types and counts, with array size and centimeter-to-foot conversion examples.

Flatten nested json data in Snowflake by using lateral flatten to turn historical price arrays into tabular rows, extracting stock code, stock name, date, and close price.

Flatten JSON data into a tabular format and build a master stock table with code and name, plus a stock prices transaction table in Snowflake, linked by code and date.