Redirecting QuickSight Datasets to a Consolidated RDS Instance Without Rebuilding Columns or Calculations

Suppose an organization has QuickSight datasets pulling data from two separate RDS instances. They are planning to consolidate these RDS instances into one. Is it possible to simply redirect their existing QuickSight datasets to point to the new consolidated RDS host? The goal would be to maintain all current dataset configurations, including columns and calculations, without having to rebuild anything. Ideally, the only change needed would be updating the source connection to point to the new RDS host. How feasible is this approach, and what potential challenges might arise?

Hello @Erika_Houde-Pearce

Can you try the steps outlined in this topic’s solution:

Let me know if this doesn’t work for you.

Hi @duncan this response is from 2022, is it still valid?

Hello @Erika_Houde-Pearce

The primary documentation links in the post are still accurate as well as the API calls.