How to use external data file (Excel File) in the spice redshift dataset under incremental loading?

Question & Answer
2

Create the redshift dataset with incremental loading, and then, create a dataset on top of this dataset: Creating a dataset using an existing dataset in Amazon QuickSight - Amazon QuickSight. In the child dataset, do the join to excel. Let the excel in right hand side while redshift on left hand side to be the driving.

1 Like