Working with JSON in Snowflake

preview_player
Показать описание

-----

One of the biggest benefits of Snowflake is its built-in capabilities to work with JSON objects. In this video, we will walk through some of the primary ways you can work with JSON in Snowflake including functions such as PARSE_JSON, GET_PATH and FLATTEN.

Timestamps:
0:00 - Intro
0:13 Query JSON Directly
1:39 Flatten Table Function
3:48 Flatten Multiple Tables
5:01 Parse_JSON Function
6:43 Get_Path Function
7:49 Closing

Title & Tags:
Working with JSON in Snowflake | Snowflake Tutorial
#snowflake #dataengineering #kahandatasolutions
  1. Kahan Data Solutions
  2. analytics
  3. data warehousing
  4. big data
  5. business intelligence
  6. education
Рекомендации по теме
Working with JSON 0:08:14

Working with JSON in Snowflake

Snowflake Tutorial // 0:14:11

Snowflake Tutorial // Working With JSON In Snowflake Variant Datatype - Complete Guide | Demohub.dev

Processing & Working 0:42:49

Processing & Working With JSON Data In Snowflake | #01

Snowflake :- Load 0:08:10

Snowflake :- Load Json File

Create custom JSON 0:08:03

Create custom JSON w/ Snowflake

How to Use 0:10:21

How to Use Flatten to Query JSON Tabular Array Data in Snowflake

Querying JSON data 0:18:54

Querying JSON data in Snowflake with Chris Marland

Working with JSON 0:25:13

Working with JSON in Snowflake | Schema on Read

Load API Data 0:07:48

Load API Data into Snowflake with Python and Scheduled Tasks

Working with geospatial 0:17:32

Working with geospatial data in Snowflake | Hands on tutorial using JSON and parquet data

How to Query 0:10:00

How to Query JSON data in Snowflake Data Warehouse.

Snowflake - Loading 0:28:48

Snowflake - Loading Semi Structured Data - JSON

Flatten Function & 1:09:10

Flatten Function & JSON Data Processing In Snowflake

8 PARSE JSON 0:16:18

8 PARSE JSON Semi structured Data Function| JSON and XML Parsing| SNOWFLAKE SQL Function Reference

Snowflake Tutorials: Flatten 0:09:26

Snowflake Tutorials: Flatten JSON in Snowflake

Flattening JSON data 0:22:13

Flattening JSON data into snowflake tables | Full Flattening in snowflake #snowflake

JSON SQL Functions 0:22:14

JSON SQL Functions - Parse_JSON, Try_Parse_JSON & Check_JSON | Ch-09 | Snowflake JSON Tutorial

HOW TO LOAD 0:05:13

HOW TO LOAD JSON DATA TO SNOWFLAKE AND HOW TO QUERY DATA

Data Engineering Project 0:11:04

Data Engineering Project Part 2 - Inserting And Parsing JSON Into Snowflake

Snowflake Infer Schema 0:26:57

Snowflake Infer Schema For JSON Data | Automatically Load JSON Data Into Snowflake

Querying Semi-Structured JSON 0:23:34

Querying Semi-Structured JSON in Snowflake

#05 | Query 0:40:03

#05 | Query Complex & Dynamic JSON Data In Snowflake

Load JSON file 0:20:49

Load JSON file into Snowflake table using Snowpipe

Read Json Data 0:14:30

Read Json Data from External Stage , Flatten it & write in Snowflake Table using Snowflake Snowp...

Комментарии
Автор

exactly what I was looking for, quick and clear. thanks, man

archen
Автор

This video is super helpful, thank you for sharing!

simba
Автор

Very nice, I like the crisp and clear video 👏

adityagupta-mfdt
Автор

Would like to see some content on recursive parsing of JSON.

YEM_
Автор

Hi, thanks for this video...I have a doubt... need your help
when I do


table(flatten(DATA, 'context')) AS CONTEXT,
table(flatten(CONTEXT.VALUE, 'objects')) AS OBJECTS,

It skips the whole of CONTEXT array when the OBJECTS array is empty, what is the solution for this?
I want empty arrays as NULL where ever it is empty.

VaibhavSingh-llpd
Автор

Hi How I can query Json in snowflake if path contains hyphen(-) example

payaljindal
Автор

Hey, love your videos and I have been learning a ton from you.

What would I do if I have a public API in JSON format? I want to use Snowflake to create some schema and run dbt in Snowflake to model against these.

lorenmurphy
Автор

How flatten after from table is working to reference value in select 😵‍💫, I’m drunk enough now loosing my marbles over this

rwish