How To Create Snowflake External Table With JSON Data | Ch-04 | Snowflake & JSON Tutorial

A Snowflake external table is a table that references data stored (be it JSON or CSV) outside of Snowflake in a external location, such as an S3 bucket or Azure Blob storage. These tables allow for easy access to external data (JSON) without the need to load it into Snowflake storage. External tables can be queried and joined with other Snowflake tables, just like a regular table. They also have the added benefits of being cost effective and allowing for dynamic data access without the need for manual data loads.

This "How To Create Snowflake External Table With JSON Data" tutorial Chapter-04 covers stage creation to file formate creation to external table DDL statements besides many important facts about JSON data handling in snowflake using external tables.

Once you finish this chapter-04, you will be able to answer the following questions:

1. How to use external stages to onboard JSON data using external tables?
2. How external table DDL looks like for JSON data?
3. How query performance works with JSON data and external table?
4. What is needed to keep external table fresh when new JSON data arrives?
5. Does external table need notification services to get the fresh data?
6. How to query external stage which has JSON data stored?
7. Can external table be created on the top of internal stage?

🚀 🚀 Chapter-04 Sections 🚀 🚀
-----------------------------------------------------
➥ 00:00 Introduction
➥ 00:23 Chapter-04 Objective
➥ 01:22 Welcome To Data Engineering Simplified
➥ 01:52 JSON Data, External Table & External Stage
➥ 04:39 External Table on JSON Data
➥ 08:03 CSV vs JSON Data External Tables
➥ 13:56 External Table Auto Refresh
➥ 15:20 External Table on Internal Table
➥ 18:49 Ch-04 Summary
➥ 19:14 Thank you & Disclaimer

🚀 🚀 Important Resources 🚀 🚀
-----------------------------------------------------
➥ SQL Scripts & JSON Files - Coming Soon...

🚀 🚀 Other Playlist By Data Engineering Simplified 🚀 🚀
----------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------------------------------------------------
➥ Ch-09: Coming Soon (Release Happens Every Week)

#snowflakecomputing #json #snowflakes #json_processing

Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.

[rqn]

Amazingly good, high quality tutorials. Great work! Thank you very much.

[rk_learner]

Are there global variables in Snowflake?

[shristiprakash]

Hi, how can i get these json sales data which you have used in this video?

[MickJalbert]

Hi, what tool do you use to visualize your JSON file? Thank you for your video!

[ramyap]

Nice explanation. is it possible to create external table with json file > 16MB?