News & Events
JSON in Snowflake Masterclass Hands-On
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!
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.
