Schema Evolution Table Properties In Snowflake | Make it work for JSON & CSV Files

This short & hands-on tutorial will discuss and demonstrate the schema evolution table properties for CSV data file and semi-structure JSON data file.

This video will cover everything you need to know about schema evolutions table property and changes needed for your file format as well as for your copy command.

🚀🚀 How To Connect

🚀🚀 Video Chapters Time Stamp
➥ 00:00 Introduction
➥ 00:58 Tree Map
➥ 01:50 Welcome Note
➥ 02:41 Part-01 Data Loading & Stage Creation
➥ 07:12 Part-02 CSV Files & Schema Evolution
➥ 12:17 Part-03 JSON Files & Schema Evolution
➥ 15:54 Quick summary
➥ 16:19 Thank You Note

#snowflaketutorial
#snowflakecomputing
#snowflakedatawrehouse
#snowflake
#dataengineeringsimplifed
#DESimplified
#toppertips
#dataengineering
#clouddatawarehouse

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.

[joaliveira]

In .csv schema Evolution, what happen if delete a column? It will handle it?

[srinivasaraodasara]

how do we connect snowflake to google analytics and extract data. i know that this possible in snowflake, but not sure how to do that.

[swarajmehta]

Hi, can we use this schema evolution with snowpipe also?

[aakarshsingh]

It is an great demo to show the usage of property schema evolution in snowflake, I have one case in my mind lets say column spelling got changes in files than with this flow we will add it as new column. Is there any way to handle such things?
for ex: file have col (fname, lname, addr) we loaded this and next time file come like this (fname, lname, Address).

Although this video is sharing incredible knowledge!
Thankyou in advance

[keerthikaappusamy]

Hi Sir, if the file is not having headers ..is there any way evlove the schema?

[vedantshirodkar]

Sir, can you make a video on Snowflake DBT ? This is getting market attention recently.

[snowflakescott]

Hold Cmd + return with the cursor at the end of the sql statement on Mac to run queries without having to highlight and click the "run" button.