![](https://uploads-us-west-2.insided.com/streamsets-en/attachment/4e7b1855-1221-488d-bcfc-4b1695b90ef1.png)
This pipeline is populating and updating a Slowly Changing Dimension for the NYC Citibike stations using Transformer for Snowflake. The pipeline is using StreamSets’ Slowly Changing Dimension stage that handles all of the logic for Type 1 and Type 2 dimensions. The SCD stage then produces the correct output along with the metadata that the Snowflake Destination uses to perform the merge.