AnsweredAssumed Answered

Help replicating Canvas Data in our local data warehouse

Question asked by Nicky Rucker on Apr 10, 2018
Latest reply on Jan 1, 2019 by Stuart Smith

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,