I am currently using RDS data source currently called dbdatasource-app, i want to switch to a different RDS data source called dbdatasource. the data sources both have the same table names and schemas. will I have to manually create each new data set, calculated field, parameter and filter? or am i able to switch data sources easily since same table name and schemas ?
Hi @izzycs,
If you are referring to seeing if it is possible in an analysis, you will not be able to switch the datasource itself since analyses are dependent on datasets. However, as long as you were able to add both datasources within Quick, then you can go to “Data” tab in the top left corner of your analysis, then “Datasets,” and finally replace dataset by hitting the ellipsis button and selecting the dataset from the other datasource.
Other than that, the only other method I can think of is adding everything from both datasources as datasets within the analysis so that you can freely use everything.
Please feel free to let me know if I misunderstood your use case at all with my explanation. Hope this helps!
you can use the quicksight cli command describe-data-set to export the dataset as a json file and edit the datasource to the new one. Once done use update-data-set to update the dataset using the modified JSON. You should be able to find documents to do this or ask Q or any other AI tool to help.