My organization is looking to change BI tools and I'm working on duplicating the currently implemented data models and dashboards over in Quicksight.
In our case, the data is modeled exactly the same across clients. Each client has their own separate database (data source) which is the exact same structure. In our current tool, I'm able to copy a 'Dataset' and then update the duplicate Dataset's data source with the correct database information for that specific client. Once the new dataset is created from the template, we go in and update the new data set to adjust for client specific customizations.
I've figured out how to duplicate Datasets and Dashboards, however I'm unable to figure out how, or if it's even possible, to change the data source for any of the duplicated datasets.
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