We are using QuickSight with redshift spectrum as the data source. We are trying to migrate the data source to an another redshift cluster. We are aware this can be achieved through editing the data source to point to the new database instance Editing a data source - Amazon QuickSight
However, we are having a hard time understanding given that all existing tables and views also exist in the new redshift cluster and the schema remains identical, how would this switch affect our existing dataset and analyses. We have the following concerns:
- Will this break our exiting dataset and analysis?
- Does this switch triggers SPICE dataset refresh automatically? Will the refresh resullts in our existing SPICE dataset depending on the old data source being invalidated entirely and requires to be reimported into SPICE from the new data source after the switch?
- If any of the dataset or analysis broke as a result of this migration, is the path to recovery going to be simply switch back to the previous database instance?
Thanks in advance