Snowflake SP - 15 - SCD Type - 2 Implementation

[@Praveen-b5p]

Superb tutorial

[@vg.venkataramana]

Hi Sir, Nice explanation. I have small doubt. In this scenario you are updating( INSERT or UPDATE) the Stage table manually. So, the stream capturing the DML operations performed on the stage. Suppose if I load data into stage using COPY INTO, then how to do scd type-2 using streams. Please clarify.

[@vg.venkataramana]

Hi Sir, waiting for your reply.

[@mrjana520]

Hi, however you load the data to stage table (snowpipe or copy command or manual load), the stream can capture the changes.

[@vg.venkataramana]

Thank you Sir for your response.

[@Ashu23200]

Hello Sir! Is this video added in udemy course as well. I have purchased it. I didn't found there and it was last updated Oct 2024

[@mrjana520]

It is available in Snowflake Scripting - Stored Procedures Udemy course

[@nagarajuapex]

Hi. Please let me know if you are dealing with full course on snowflake

[@mrjana520]

Not now

[@walkwithsunni3901]

Hello Sir! I am unable to find your complete SQL course on Udemy. I am using my organization's credentials for Udemy.

[@mrjana520]

It is not available in Udemy business accounts

[@walkwithsunni3901]

Sir where can i get the data to practice for SQL?

[@tarigopulaayyappa]

​​@@mrjana520 May i know how is calls/market on snow flake now? Can we get 20 lacs package for 7 years exp(5 years exp on ETL datastsge and 2 years exp on snowflake)?

[@mrjana520]

yes, you can