Snowflake Data engineering: SQL advancements "UNION BY NAME"

Описание: In this video, I have explained the power of "Union By Name" in SQL — a powerful Snowflake feature that allows you to perform unions based on column names, not their order. This is again a recently launched in Snowflake Summit. Going through it would give insights about:

1. How "UNION ALL" works and how "UNION BY NAME" is different.
2. This command Auto-fills missing columns with NULLs.
3. It works even if the column ordering are not same in both set of the queries.
4. It is Perfect for dynamic ETL pipelines
5. It Supports schema changes without breaking your queries.