Forum Discussion

emmet's avatar
emmet
Frequent Visitor
8 years ago
Solved

Changing Data Source from .csv to AWS Redshift Table

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!

Need Help
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    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.

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    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.