Migrating data to AWS Redshift and Snowflake from an on-premise database
In this video we look at the best way to migrate data to AWS cloud data warehouses - specifically Redshift and Snowflake - from on-premise databases.
We cover some best practices for loading data, and why an ELT approach is often preferred.
And we show a step-by-step walkthrough of how to build a pipeline that handles the whole data migration in CloverDX, in a repeatable, configurable way.
00:12 - Best practice for migrating data to Redshift and Snowflake
00:59 - ELT vs ETL
01:56 - The data migration pipeline in CloverDX
02:29 - Reading data from the source
03:33 - Migrating the data
04:09 - Writing to Redshift
This clip is taken from the longer video Migrating Your Data to AWS, which you can watch here: https://www.cloverdx.com/ty/webinar/m...
More on the CloverDX data integration platform: https://www.cloverdx.com/product
Request a demo: https://www.cloverdx.com/demo