Hi! We have access to Canvas Data in Redshift and we are looking to pull it down into in our local data warehouse. Has anyone effectively done this? We want to replicate all of the tables nightly but aren't sure where is the best place to start and how to handle the incremental changes (since some of the table are missing modified dates).
We are thinking we may unload the all of the Redshift data into a S3 bucket and then pull it locally. Please let me know if there are any other organizations that are doing this or if there is better way to do replicate our data locally.
Thank you for any help,