Programming in Snowflake Masterclass 2024 Hands-On! → Review: JSON Data Flattening - Learn with Chris

Skip to content

Home
Courses
Website
- Blog
- About
- Contact
My Account
etc

Home
Courses
Website
- Blog
- About
- Contact
My Account
etc

Home
Video Courses

Programming in Snowflake Masterclass 2024 Hands-On!

Curriculum

23 Sections
173 Lessons
Lifetime

Expand all sectionsCollapse all sections

Introduction
1
- 1.1
  Welcome to this Course
Warehouses and Cost Estimates
8
- 2.1
  Introduction
- 2.2
  Hands On: Sign-up for a Free Trial Account
- 2.3
  Hands On: Use a Very Small Warehouse
- 2.4
  Hands On: Use Very Large Warehouses
- 2.5
  Review: Overview of the Snowflake Architecture
- 2.6
  Hands On: Apply Best Practices for Data and Warehouses
- 2.7
  Review: Snowflake Best Practices for Compute and Storage
- 2.8
  Check Your Knowledge
  10 Minutes0 Questions
Loading and Accessing CSV Data
7
- 3.1
  Introduction
- 3.2
  Hands On: Create Query Context
- 3.3
  Hands On: Infer Schema from Staged CSV Files
- 3.4
  Hands On: Copy Data into Tables
- 3.5
  Hands On: Create External S3 Stage
- 3.6
  Review: End-to-End CSV File Uploading
- 3.7
  Check Your Knowledge
  10 Minutes0 Questions
Loading and Processing JSON Data
10
- 4.1
  Introduction
- 4.2
  Review: File Formats
- 4.3
  Hands On: Upload JSON Data
- 4.4
  Hands On: Transform JSON Data
- 4.5
  Review: JSON Data Transformations
- 4.6
  Hands On: Flatten JSON Data
- 4.7
  Review: JSON Data Flattening
- 4.8
  Hands On: Add Constraints and Materialized Views
- 4.9
  Review: Temporary Tables and Materialized Views
- 4.10
  Check Your Knowledge
  10 Minutes0 Questions
Sample Data Extraction and Generation
7
- 5.1
  Introduction
- 5.2
  Hands On: Extract Data Samples with Snowflake
- 5.3
  Hands On: Generate Synthetic Data with Snowflake
- 5.4
  Hands On: Generate Synthetic Data with Python
- 5.5
  Review: Data Sample Extraction and Generation
- 5.6
  Review: Sequences and Identity Columns
- 5.7
  Check Your Knowledge
  10 Minutes0 Questions
Stored Procedures and Recursive SQL
9
- 6.1
  Introduction
- 6.2
  Hands On: Prepare Hierarchical Data
- 6.3
  Hands On: Query Hierarchical Data with Joins
- 6.4
  Hands On: Query Hierarchical Data with Recursive SQL
- 6.5
  Review: SQL Queries for Hierarchical Data
- 6.6
  Hands On: Create UDFs in SQL
- 6.7
  Hands On: Create Stored Procedure in JavaScript
- 6.8
  Review: Stored Procedures and Functions
- 6.9
  Check Your Knowledge
  10 Minutes0 Questions
SQL and Snowflake Scripting
16
- 7.1
  Introduction
- 7.2
  Hands On: Use Case Sensitive Identifiers
- 7.3
  Hands On: Use Identifier References
- 7.4
  Hands On: Access JSON Object Properties
- 7.5
  Review: Identifiers and Variables in Snowflake SQL
- 7.6
  Hands On: Clone Table Data
- 7.7
  Review: Duplicating Table Data and Zero-Copy Cloning
- 7.8
  Hands On: Snowflake Scripting Procedure with Cursor
- 7.9
  Hands On: Snowflake Scripting Procedure with ResultSet
- 7.10
  Hands On: Snowflake Scripting Procedure Calling a JavaScript Function
- 7.11
  Hands On: Test the Generic Hierarchical Viewer in SQL
- 7.12
  Review: Snowflake Scripting
- 7.13
  Hands On: Implement Transaction
- 7.14
  Hands On: More Transaction Use Cases
- 7.15
  Review: Transactions in Snowflake
- 7.16
  Check Your Knowledge
  10 Minutes0 Questions
Snowflake Data Pipelines
10
- 8.1
  Introduction
- 8.2
  Batch & Stream Data Transfer to Snowflake
- 8.3
  Hands On: Manual CDC with MERGE Statement
- 8.4
  Hands On: Enable Change Tracking on a Table
- 8.5
  Hands On: CDC with Streams and Tasks
- 8.6
  Hands On: CDC with Dynamic Table
- 8.7
  Review: CDC (Change Data Capture) in Snowflake
- 8.8
  Hands On: Continuous Data Loading with Snowpipe on S3
- 8.9
  Review: Snowpipe on Amazon S3
- 8.10
  Check Your Knowledge
  10 Minutes0 Questions
Hierarchical Data Visualizations
7
- 9.1
  Introduction
- 9.2
  Hands On: Transform Tabular Data into JSON Format
- 9.3
  Review: Hierarchical Data Formats (JSON, XML, and YAML)
- 9.4
  Hands On: Show Graphs (with GraphViz)
- 9.5
  Hands On: Show Hierarchical Charts (with Plotly)
- 9.6
  Hands On: Show Animated Charts (with D3)
- 9.7
  Check Your Knowledge
  10 Minutes0 Questions
Streamlit Web Applications
10
- 10.1
  Introduction
- 10.2
  Hands On: Create Your First Streamlit Web App
- 10.3
  Hands On: Add Functionality with a Streamlit Tab Control
- 10.4
  Review: Introduction to Streamlit
- 10.5
  Review: Streamlit Layout Components and Interactive Widgets
- 10.6
  Hands On: Cache Streamlit Data
- 10.7
  Review: Streamlit Session and Data Caching
- 10.8
  Hands On: Deploy and Share a Web App in Streamlit Cloud
- 10.9
  Review: Deploying a Web App in Streamlit Cloud
- 10.10
  Check Your Knowledge
  10 Minutes0 Questions
Client Programming with Snowflake
9
- 11.1
  Introduction
- 11.2
  Hands On: Install Snowflake Tools and Utilities
- 11.3
  Review: Snowflake Tools and Utilities
- 11.4
  Hands On: Connect to Snowflake from a Python Client
- 11.5
  Hands On: Connect to Snowflake from .NET in C#
- 11.6
  Hands On: Connect to Snowflake from NodeJS in JavaScript
- 11.7
  Review: Snowflake Connector for Python
- 11.8
  Hands On: Connect the Hierarchical Data Viewer to Snowflake
- 11.9
  Check Your Knowledge
  10 Minutes0 Questions
Snowpark API
11
- 12.1
  Introduction
- 12.2
  Review: Snowpark for Python Architecture
- 12.3
  Hands On: Create Query with DataFrame API
- 12.4
  Snowpark API: The Object Model
- 12.5
  Hands On: Create Stored Procs and UDFs in Python/Java/Scala
- 12.6
  Review: Procedures and UDFs in Python, Java, Scala
- 12.7
  Hands On: Customize Stored Proc from Python Worksheet
- 12.8
  Review: Python Worksheets
- 12.9
  Hands On: Create and Call Stored Procs and UDFs from Python
- 12.10
  Review: Snowpark for Python
- 12.11
  Check Your Knowledge
  10 Minutes0 Questions
Streamlit in Snowflake
5
- 13.1
  Introduction
- 13.2
  Hands On: Deploy a Streamlit Web App in Snowflake
- 13.3
  Review: Streamlit in Snowflake
- 13.4
  Review: Event Tables and Alerts
- 13.5
  Check Your Knowledge
  10 Minutes0 Questions
Access Control in Snowflake
7
- 14.1
  Introduction
- 14.2
  Hands On: Create Script for Users, Roles and Privileges
- 14.3
  Hands On: Inspect Users, Roles and Privileges
- 14.4
  Review: Users, Roles and Privileges
- 14.5
  Hands On: Run SnowSQL Scripts using Variable Substitution
- 14.6
  Review: Multi-Tenant Architectures with Var Substitution
- 14.7
  Check Your Knowledge
  10 Minutes0 Questions
Snowflake REST APIs
8
- 15.1
  Introduction
- 15.2
  Hands On: Configure Key Pair Authentication and Generate JWT
- 15.3
  Review: Key Pair Authentication in Snowflake
- 15.4
  Hands On: Run a Query from Script with the SQL REST API
- 15.5
  Review: The Snowflake SQL REST API
- 15.6
  Hands On: Ingest Files with Snowpipe REST API
- 15.7
  Review: The Snowpipe REST API
- 15.8
  Check Your Knowledge
  10 Minutes0 Questions
Data Governance in Snowflake
10
- 16.1
  Introduction
- 16.2
  Hands On: Tag Objects
- 16.3
  Hands On: Classify Data
- 16.4
  Review: Data Governance in Snowflake
- 16.5
  Hands On: Create a Restricted View
- 16.6
  Hands On: Create a Masking Policy
- 16.7
  Hands On: Create a Tag-Based Masking Policy
- 16.8
  Hands On: Create a Row Access Policy
- 16.9
  Review: Column Masking and Row Access Policies
- 16.10
  Check Your Knowledge
  10 Minutes0 Questions
Data Sharing in Snowflake
10
- 17.1
  Introduction
- 17.2
  Hands On: Create an Inbound Data Share
- 17.3
  Hands On: Consume an Outbound Data Share
- 17.4
  Review: Secure Data Sharing and Reader Accounts
- 17.5
  Hands On: Create a Listing for Private Data Shares
- 17.6
  Review: Data Exchange and Snowflake Marketplace
- 17.7
  Hands On: Solve Yao’s Millionaire Problem for Data Clean Rooms
- 17.8
  Hands On: Create Data Clean Room with Row Access Policies
- 17.9
  Review: Data Clean Rooms
- 17.10
  Check Your Knowledge
  10 Minutes0 Questions
Create a Multi-Page Hierarchical Metadata Viewer
14
- 18.1
  Introduction
- 18.2
  Review: Information Schema vs Account Usage
- 18.3
  Hands On: Create ER Diagram Viewer
- 18.4
  Review: ER Diagram Viewer
- 18.5
  Hands On: Create Users and Roles Inspector
- 18.6
  Review: Users and the Role Hierarchy
- 18.7
  Hands On: Create Object Dependency Inspector
- 18.8
  Review: Object Dependencies in Snowflake
- 18.9
  Hands On: Create Data Lineage Inspector
- 18.10
  Review: Data Lineage in Snowflake
- 18.11
  Hands On: Create Task Dependencies Inspector
- 18.12
  Review: Task Dependencies and Task Workflow Runs
- 18.13
  Hands On: Deploy as Multi-Page Streamlit in Snowflake App
- 18.14
  Check Your Knowledge
  10 Minutes0 Questions
Snowflake Native App Framework
4
- 19.1
  Introduction
- 19.2
  Hands On: Deploy the Hierarchical Data Viewer as a Native App
- 19.3
  Review: Snowflake Native App Framework
- 19.4
  Check Your Knowledge
  10 Minutes0 Questions
Create an Admin Dashboard in Snowsight
4
- 20.1
  Introduction
- 20.2
  Hands On: Create an Administration Dashboard in Snowsight
- 20.3
  Review: System Views for Account Usage
- 20.4
  Check Your Knowledge
  10 Minutes0 Questions
Data Analytics with Snowflake
8
- 21.1
  Introduction
- 21.2
  Hands On: Convert Subqueries to CTEs
- 21.3
  Hands On: Create Aggregated Queries
- 21.4
  Hands On: Pivot and Unpivot Data
- 21.5
  Review: Intermediate Data Analytics in SQL
- 21.6
  Hands On: Query Data from the Past
- 21.7
  Review: Time Travel and Fail-safe
- 21.8
  Check Your Knowledge
  10 Minutes0 Questions
Advanced Analytics with Snowflake
9
- 22.1
  Introduction
- 22.2
  Hands On: Query with QUALIFY
- 22.3
  Hands On: Moving Average Query
- 22.4
  Hands On: Query with Rank Functions
- 22.5
  Hands On: Query with Offset Functions
- 22.6
  Review: Window Functions
- 22.7
  Hands On: Use Statistical Functions
- 22.8
  Review: Statistical Functions
- 22.9
  Check Your Knowledge
  10 Minutes0 Questions
Snowflake Query Optimization
11
- 23.1
  Introduction
- 23.2
  Hands On: Use the Query History
- 23.3
  Hands On: Use the Result Cache
- 23.4
  Hands On: Interpret the Query Profile
- 23.5
  Hands On: Interpret a Query Plan from EXPLAIN
- 23.6
  Hands On: Enhanced Query Profile and Analyzer
- 23.7
  Review: Query Performance Tools
- 23.8
  Hands On: Inspect a Table Cluster Distribution
- 23.9
  Review: Clustering Keys
- 23.10
  Check Your Knowledge
  10 Minutes0 Questions
- 23.11
  Congratulations, You Made It!

This content is protected, please login and enroll in the course to view this content!

Hands On: Flatten JSON Data

Hands On: Add Constraints and Materialized Views

Copyright © 2026 Learn with Chris. All Rights Reserved.

Powered by EduPress

Modal title

Main Content