Uploaded October 2023 | Updated September 2026, 2 hours ago

---

This quick and practical tutorial will show the importance of ORDER & NOORDER values for identity/auto-increment column when added in your table and the impact of copy command and its side effect on identity column and it is worth considering NOORDER value for the auto-increment column.

This video will cover everything you need to know about change tracking properties vs stream object on a table and how it behaves in different situation.

🚀🚀 How To Connect
✏ Instagram: instagram.com/learn_dataengineering
✏ Medium Blog: medium.com/@data-engineering-simplified
✏ Exclusive Snowflake Facebook Group: facebook.com/groups/627874916138090

🚀🚀 Video Chapters Time Stamp
➥ 00:00 Introduction
➥ 00:50 Tree Map
➥ 01:28 Welcome Note
➥ 02:25 Part-01 Load employee data to stage
➥ 06:20 Part-02 Create Employee Tables With Order/Noorder
➥ 09:00 Part-03 Run Copy Command & Performance Validation
➥ 12:47 Quick summary
➥ 13:28 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.