Quicksight: Changing data source for a dataset

This is not possible AFAIK in the Quicksight UI, sadly. In the Quicksight UI it is possible to create a new Data Source manually and then create Datasets from that Data Source and if the Dataset was a simple SQL query etc you could just copy the query across. But this will not copy across any filters, calculated fields etc and that is what I suspect you want to do.

We use the AWS Quicksight CLI version 2 to programmatically deploy new and updated Datasets and Data Sources to our Production environment from my BI development environment using Python scripts inside AWS Lambda functions. You can however simply do it all from your own terminal / coding environment as long as your user account has all the relevant AWS permissions for Quicksight.

The CLI has the commands you would need e.g. create-data-source and create-data-set. The CLI also support for a variety of languages in addition to Python.

Using the Quicksight UI I would set up my first Data Source, Dataset(s) and also create a base Analysis (with common Filters, Calculated Fields, Visualisations etc) and save that as a Dashboard. Once all that is done you can use the AWS Quicksight CLI to create-template:

A template is an entity in Amazon QuickSight that encapsulates the metadata required to create an analysis and that you can use to create s dashboard. A template adds a layer of abstraction by using placeholders to replace the dataset associated with the analysis. You can use templates to create dashboards by replacing dataset placeholders with datasets that follow the same schema that was used to create the source analysis and template.

Then, I would use the AWS CLI to get the metadata for the Dataset you created above (list-data-sets -> describe-data-set). Then using (Python) script with some dictionaries of all your customers Database details to create-data-source for each. Then use list-data-sources, to get all the DataSources -> Arn, and finally use a script to create-data-set for each customer, replacing the DataSourceArn each time (we use dictionaries which are 'easy' to update in a loop).

Hope this gives you a start, Cheers

I had to use the command line tool to update it
quicksight aws cli reference

Note: The <aws-account-id> below is typically a 12 digit number that identifies your aws account.

List data sources

aws quicksight list-data-sources --aws-account-id <aws-account-id>

You can use this to get a template of the parameters to update a data source:
(I used a json file to update the parameters)

aws quicksight update-data-source --generate-cli-skeleton input > update-data-source.json

Edit the file with the applicable data source info then update with:

aws quicksight update-data-source --cli-input-json file://update-data-source.json

1.Describe Dataset and Get PhysicalTableMap json from output

aws quicksight describe-data-set --aws-account-id <accountid> --data-set-id <datasetid> (DatasetId from url)

2.Create update_dataset.json and Copy PhysicalTableMap json from (1). Update DataSource Arn(new datasource) in this json

3.Update DataSet

aws quicksight update-data-set --aws-account-id <accountid> --data-set-id <datasetid> --name <DatasetName> --physical-table-map file://update_dataset.json --import-mode SPICE

You should first save your Analysis with a new name (Save As:)

Then you should open new analysis and replace existing dataset with a new one:

Choose replace:

If only you have the same structure of your dataset, your dashboard should be O.K. with new data.