![](https://uploads-us-west-2.insided.com/streamsets-en/attachment/9d08225a-c359-40ad-9108-fd562bd57c8b.png)
This pipeline is designed to capture inserts and updates (SCD Type II) being uploaded to a bucket on Amazon S3 for a slowly changing dimension table -- Customers. The pipeline creates new records with version set to 1 for new customers and with version set to (current version + 1) for existing customers. The customer records are then stored in Snowflake Data Cloud.