Changing Data Source for a Dataset

Question & Answer
, , ,
1

I’m trying to create Template Datasets. All of our clients have the same database to start. When we implement their Dashboards in our previous tool, I could simply duplicate a data model/set, change the data source (mainly the connection credentials) and it would update the dataset with that specific client’s data.

I’ve seen how I’m able to duplicate datasets and dashboards, however I can’t figure out how to adjust data source settings once that’s done. I would really love it if I didn’t have to rebuild each dataset for each of my clients.

Is this possible? If so, how?

2

Hi @dan.kainz -

It sounds like you could be looking for 1 of 2 things.

  1. If you need to update the DataSource connection properties you can follow the steps outlined here Editing a database data source.

  2. Updating the DataSource used by a DataSet. This is not currently possible in the UI.

As a workaround, you can update the DataSet using the QuickSight API.

The rough process;

  1. DescribeDataset
    a. Update the property DataSourceArn to your new DataSource Arn
  2. UpdateDataset
3 Likes