JSON in Snowflake Masterclass Hands-On
- Description
- Curriculum
- FAQ
- Reviews
There is a growing demand on the market today to build and query hybrid relational databases, enhanced with JSON extensions. We used to have separate NoSQL document stores, like MongoDB or Couchbase. But most relational database systems today – including Snowflake – added powerful data types and built-in functions to store and query JSON along tabular data, from SQL. Learn how to properly upload, query and design relational-hierarchical databases, as you will need them more and more in your professional career or your job!
What you will learn
-
All you need to know about JSON used as a data storage format.
-
How to design hybrid databases in Snowflake, using tabular data extended with JSON hierarchies.
-
How to create and manipulate the two complex structures in JSON: OBJECT dictionaries and ARRAY lists.
-
How to use LATERAL FLATTEN, to explode array elements and key-value pairs into tabular rows.
-
How to aggregate key-values or row elements into single OBJECT or ARRAY values.
-
How to create all sorts of simple to complex queries for JSON data in Snowflake.
-
How to manually enter JSON data into Snowflake tables.
-
How to upload JSON files into tables, using the STRIP_OUTER_ARRAY option.
-
How to unload Snowflake table data into a JSON format.
-
How to switch between tabular and hierarchical topologies, to extract data.
-
How to use the JSON dot notation, to locate specific elements in the hierarchy.
-
How to interpret JSON data returned by system functions or as ACCOUNT_USAGE metadata.
-
How to create custom JSON data profilers and schema on-read extractors.
-
How to represent in a graphical manner JSON hierarchies.
-
How to perform JSON transformations with higher-order functions, UDFs or with Snowpark DataFrame.
-
How to find JSONPath equivalent queries in Snowflake.
-
How to transpose data between relational and hierarchical representations.
-
How to convert JSON to JSON, or other hierarchical formats, like YAML and XML.
My credentials for this course
-
The only world-class expert from Canada selected for their Snowflake Data Superhero program in 2021.
-
SnowPro Certification SME (Subject Matter Expert) – I helped create many SnowPro exam questions.
-
Passed five SnowPro certification exams to date, all on the first attempt.
-
Certified Professional Couchbase Developer – in querying their JSON document stores using SQL.
-
Expert in many NoSQL databases, including MongoDB and Couchbase JSON document stores.
-
Professional workplace experience with MongoDB NoSQL JSON document stores since 2012.
Enroll today, and learn how to master everything JSON in Snowflake!
-
5Introduction to JSON FundamentalsVideo lesson
-
6JSON Objects and ArraysVideo lesson
-
7JSON from Python Dictionaries and ListsVideo lesson
-
8JSON Viewers and ValidatorsVideo lesson
-
9JSON Data Profiler and ModelerVideo lesson
-
10Hierarchical Data FormatsVideo lesson
-
11JSON Graphical RepresentationsVideo lesson
-
12JSONPath from XPath (Dot Notation)Video lesson
-
13Test Your KnowledgeQuiz
-
14Introduction to JSON Insertion in SnowflakeVideo lesson
-
15JSON Document DatabasesVideo lesson
-
16Dynamic JSON with SELECTVideo lesson
-
17JSON Storage with INSERTVideo lesson
-
18OBJECT Creation FunctionsVideo lesson
-
19ARRAY Creation FunctionsVideo lesson
-
20JSON Data Visualization in SnowflakeVideo lesson
-
21JSON Dot Notation in SnowflakeVideo lesson
-
22JSON Extraction FunctionsVideo lesson
-
23Test Your KnowledgeQuiz
-
24Introduction to JSON Uploading in SnowflakeVideo lesson
-
25Manual JSON File UploadVideo lesson
-
26Data Transfer in SnowflakeVideo lesson
-
27Bulk JSON File UploadVideo lesson
-
28Upload JSON with STRIP_OUTER_ARRAYVideo lesson
-
29Upload JSON with Inferred SchemaVideo lesson
-
30Upload Validation and ErrorsVideo lesson
-
31Unload JSON DataVideo lesson
-
32Test Your KnowledgeQuiz
-
33Introduction to JSON Transformations in SnowflakeVideo lesson
-
34OBJECT Manipulation FunctionsVideo lesson
-
35ARRAY Manipulation FunctionsVideo lesson
-
36Higher-Order Functions for Array ElementsVideo lesson
-
37LATERAL KeywordVideo lesson
-
38Flattening ArraysVideo lesson
-
39Flattening DictionariesVideo lesson
-
40JSON from String ListsVideo lesson
-
41JSON from Row AggregationsVideo lesson
-
42JSON Transformations with UDFsVideo lesson
-
43JSON Transformations with Data FramesVideo lesson
-
44Test Your KnowledgeQuiz
-
45Introduction to JSON Querying in SnowflakeVideo lesson
-
46JSONPath Equivalent in SnowflakeVideo lesson
-
47More JSON Queries for SnowflakeVideo lesson
-
48Even More JSON Queries for SnowflakeVideo lesson
-
49Count Distinct Values with ArraysVideo lesson
-
50EXPLAIN Query in JSON FormatVideo lesson
-
51Query Profile Info with JSON DataVideo lesson
-
52JSON Metadata for Data LineageVideo lesson
-
53JSON Query Performance OptimizationsVideo lesson
-
54Test Your KnowledgeQuiz
-
55Introduction to JSON Modeling in SnowflakeVideo lesson
-
56Hierarchical to Relational ModelVideo lesson
-
57Relational to Hierarchical ModelVideo lesson
-
58JSON to JSON ConversionsVideo lesson
-
59JSON-Based ViewsVideo lesson
-
60Direct Access to Staged JSON FilesVideo lesson
-
61External TablesVideo lesson
-
62Design Patterns for Data PipelinesVideo lesson
-
63Design Patterns for Data ModelingVideo lesson
-
64Test Your KnowledgeQuiz
External Links May Contain Affiliate Links read more