Companies Home Search Profile
TrainingHub TrainingHub

JSON in Snowflake Masterclass Hands-On

Focused View

Cristian Scutaru

12:11:06

0 View
  • 1 - Welcome to this Course.mp4
    05:29
  • 2 - How to Benefit Most from this Course.mp4
    03:58
  • 3 - Create a Free Snowflake Trial Account.mp4
    05:21
  • 4 - Frequently Asked Questions.html
  • 4 - GitHub Repository with all Code for this Course.txt
  • 4 - JSON-in-Snowflake-All-Slides.pdf
  • 5 - Introduction to JSON Fundamentals.mp4
    02:44
  • 6 - JSON Objects and Arrays.mp4
    15:39
  • 7 - JSON from Python Dictionaries and Lists.mp4
    07:55
  • 8 - JSON Viewers and Validators.mp4
    06:51
  • 9 - JSON Data Profiler and Modeler.mp4
    07:18
  • 10 - Hierarchical Data Formats.mp4
    10:00
  • 11 - JSON Graphical Representations.mp4
    07:01
  • 12 - JSONPath from XPath Dot Notation.mp4
    08:24
  • Files.zip
  • 13 - Introduction to JSON Insertion in Snowflake.mp4
    03:10
  • 14 - JSON Document Databases.mp4
    12:39
  • 15 - Dynamic JSON with SELECT.mp4
    20:13
  • 16 - JSON Storage with INSERT.mp4
    12:46
  • 17 - OBJECT Creation Functions.mp4
    21:06
  • 18 - ARRAY Creation Functions.mp4
    13:37
  • 19 - JSON Data Visualization in Snowflake.mp4
    14:09
  • 20 - JSON Dot Notation in Snowflake.mp4
    17:35
  • 21 - JSON Extraction Functions.mp4
    10:33
  • Files.zip
  • 22 - Introduction to JSON Uploading in Snowflake.mp4
    02:30
  • 23 - Manual JSON File Upload.mp4
    09:09
  • 24 - Data Transfer in Snowflake.mp4
    20:21
  • 25 - Bulk JSON File Upload.mp4
    17:00
  • 26 - Upload JSON with STRIPOUTERARRAY.mp4
    12:30
  • 27 - Upload JSON with Inferred Schema.mp4
    11:10
  • 28 - Upload Validation and Errors.mp4
    17:59
  • 29 - Unload JSON Data.mp4
    17:39
  • Files.zip
  • 30 - Introduction to JSON Transformations in Snowflake.mp4
    04:01
  • 31 - OBJECT Manipulation Functions.mp4
    19:59
  • 32 - ARRAY Manipulation Functions.mp4
    17:47
  • 33 - HigherOrder Functions for Array Elements.mp4
    08:24
  • 34 - LATERAL Keyword.mp4
    16:03
  • 35 - Flattening Arrays.mp4
    24:39
  • 36 - Flattening Dictionaries.mp4
    15:12
  • 37 - JSON from String Lists.mp4
    18:40
  • 38 - JSON from Row Aggregations.mp4
    23:31
  • 39 - JSON Transformations with UDFs.mp4
    19:05
  • 40 - JSON Transformations with Data Frames.mp4
    07:41
  • Files.zip
  • 41 - Introduction to JSON Querying in Snowflake.mp4
    04:09
  • 42 - JSONPath Equivalent in Snowflake.mp4
    13:19
  • 43 - More JSON Queries for Snowflake.mp4
    17:58
  • 44 - Even More JSON Queries for Snowflake.mp4
    11:17
  • 45 - Count Distinct Values with Arrays.mp4
    10:14
  • 46 - EXPLAIN Query in JSON Format.mp4
    15:06
  • 47 - Query Profile Info with JSON Data.mp4
    11:05
  • 48 - JSON Metadata for Data Lineage.mp4
    08:12
  • 49 - JSON Query Performance Optimizations.mp4
    05:45
  • Files.zip
  • 50 - Introduction to JSON Modeling in Snowflake.mp4
    04:22
  • 51 - Hierarchical to Relational Model.mp4
    26:23
  • 52 - Relational to Hierarchical Model.mp4
    17:20
  • 53 - JSON to JSON Conversions.mp4
    19:21
  • 54 - JSONBased Views.mp4
    25:06
  • 55 - Direct Access to Staged JSON Files.mp4
    06:08
  • 56 - External Tables.mp4
    17:07
  • 57 - Design Patterns for Data Pipelines.mp4
    13:55
  • 58 - Design Patterns for Data Modeling.mp4
    12:38
  • Files.zip
  • 59 - Congratulations You Made It.mp4
    01:53
  • 60 - Bonus Lecture.html
    •

    Description

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

    What You'll Learn?

    • How to load and unload data in JSON format in and from Snowflake
    • How to query JSON data from a VARIANT data type
    • How to use built-in Snowflake functions for JSON objects and arrays
    • How to FLATTEN semi-structured data into tabular data
    • How to dynamically extract schema-on-read from JSON data
    • How to convert JSON data to other hierarchical formats
    • How to call the Snowflake COPY INTO commands for JSON data
    • How to design databases using both tabular and hierarchical topologies
    • How to create all sorts of simple to complex queries using JSON in Snowflake

    Who is this for?

  • Data Engineers collecting semi-structured data in their data pipelines
  • Database Administrators learning new design patterns for hybrid tabular-hierarchical data
  • Data Analysis who need querying hybrid data stores
  • Data Architects willing to learn how to flatten key-value JSON dictionaries and JSON arrays
  • SnowPro certification exam candidates, learning about LATERAL FLATTEN in detail
  • OLAP and OLTP practitioners, in need to understand how JSON fits into a relational model

    • What You Need to Know?

  • Basic SQL query programming skills
  • Basic Python programming skills
  • Basic beginner-level knowledge of Snowflake, as a data warehouse
  • Optional JavaScript programming skills
  • Optional knowledge of Streamlit
  • No prior knowledge of JSON or other semi-structured data format

    • More details

    Description

    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!

    Who this course is for:

    • Data Engineers collecting semi-structured data in their data pipelines
    • Database Administrators learning new design patterns for hybrid tabular-hierarchical data
    • Data Analysis who need querying hybrid data stores
    • Data Architects willing to learn how to flatten key-value JSON dictionaries and JSON arrays
    • SnowPro certification exam candidates, learning about LATERAL FLATTEN in detail
    • OLAP and OLTP practitioners, in need to understand how JSON fits into a relational model

    User Reviews
    Rating
    0
    0
    0
    0
    0
    average 0
    Total votes0
    Focused display
    Category

    Data Science

    Cristian Scutaru
    Cristian Scutaru
    Instructor's Courses
    Certified Solutions Architect in AWS/Azure/Google Cloud (20 total exams). Former Snowflake “Data Superhero” and SnowPro Certification SME. Certified in many NoSQL stores: Cassandra/Redis/Couchbase/Neo4j/TigerGraph...Decades of practical experience in software design and implementation. Former Microsoft employee. Architect of the Data Xtractor Suite - with a visual SQL editor, data visualization charts, data modeling... Former assistant professor at the "Polytechnica" University of Bucharest.I live in beautiful Vancouver/Canada.
    Udemy
    Udemy
    View courses Udemy
    Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.
    • language english
    • Training sessions 58
    • duration 12:11:06
    • Release Date 2024/10/30

    Courses related to Data Science

    Manipulating Data in Tableau Desktop
    Pluralsight Adam Crahen
    Adam Crahen
    Manipulating Data in Tableau Desktop
    1:38:36
    10/05/2023
    Learn R For Datascience
    UdemyLearn R For Datascience
    4:14:01
    05/09/2024
    Meet the Expert Barr Moses on Eliminating Data Downtime
    O'ReillyMeet the Expert Barr Moses on Eliminating Data Downtime
    1:01:51
    10/31/2023