Changing Data Source from .csv to AWS Redshift Table

[emmet]

Hello,

I currently have a workbook referencing multiple local csv files. What is the best way to update these data sources to reference the tables we have on our data warehouse (AWS Redshift)? Can this be done without rebuilding the entire report?

Any advice you have on best method(s) to make this change would be greatly appreciated. Thank you!

[Greg_Deckler · Accepted solution]

So, add a query to your AWS location. Go to Advanced Editor in Query Editor and copy the Source line. Go to your CSV query and go to Advanced Editor and replace your Source line. That's the basic technique.