JSON in Snowflake Masterclass Hands-On

سرفصل های دوره

Learn all you need about semi-structured JSON data in Snowflake

1 - Introduction

1 - Welcome to this Course

2 - How to Benefit Most from this Course

3 - Create a Free Snowflake Trial Account

4 - Frequently Asked Questions.html

4 - GitHub Repository with all Code for this Course.txt

4 - JSON-in-Snowflake-All-Slides.pdf

2 - JSON Fundamentals

5 - Introduction to JSON Fundamentals

6 - JSON Objects and Arrays

7 - JSON from Python Dictionaries and Lists

8 - JSON Viewers and Validators

9 - JSON Data Profiler and Modeler

10 - Hierarchical Data Formats

11 - JSON Graphical Representations

12 - JSONPath from XPath Dot Notation

Files.zip

3 - JSON Insertion in Snowflake

13 - Introduction to JSON Insertion in Snowflake

14 - JSON Document Databases

15 - Dynamic JSON with SELECT

16 - JSON Storage with INSERT

17 - OBJECT Creation Functions

18 - ARRAY Creation Functions

19 - JSON Data Visualization in Snowflake

20 - JSON Dot Notation in Snowflake

21 - JSON Extraction Functions

Files.zip

4 - JSON Uploading in Snowflake

22 - Introduction to JSON Uploading in Snowflake

23 - Manual JSON File Upload

24 - Data Transfer in Snowflake

25 - Bulk JSON File Upload

26 - Upload JSON with STRIPOUTERARRAY

27 - Upload JSON with Inferred Schema

28 - Upload Validation and Errors

29 - Unload JSON Data

Files.zip

5 - JSON Transformations in Snowflake

30 - Introduction to JSON Transformations in Snowflake

31 - OBJECT Manipulation Functions

32 - ARRAY Manipulation Functions

33 - HigherOrder Functions for Array Elements

34 - LATERAL Keyword

35 - Flattening Arrays

36 - Flattening Dictionaries

37 - JSON from String Lists

38 - JSON from Row Aggregations

39 - JSON Transformations with UDFs

40 - JSON Transformations with Data Frames

Files.zip

6 - JSON Querying in Snowflake

41 - Introduction to JSON Querying in Snowflake

42 - JSONPath Equivalent in Snowflake

43 - More JSON Queries for Snowflake

44 - Even More JSON Queries for Snowflake

45 - Count Distinct Values with Arrays

46 - EXPLAIN Query in JSON Format

47 - Query Profile Info with JSON Data

48 - JSON Metadata for Data Lineage

49 - JSON Query Performance Optimizations

Files.zip

7 - JSON Modeling in Snowflake

50 - Introduction to JSON Modeling in Snowflake

51 - Hierarchical to Relational Model

52 - Relational to Hierarchical Model

53 - JSON to JSON Conversions

54 - JSONBased Views

55 - Direct Access to Staged JSON Files

56 - External Tables

57 - Design Patterns for Data Pipelines

58 - Design Patterns for Data Modeling

Files.zip

8 - Wrapping Up

59 - Congratulations You Made It

60 - Bonus Lecture.html

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy