I have created several dashboards created in an account and the dataset has dev db as the data source. The account is currently set up with a folder called dev with all dashboards, analysis and dataset created in subfolders. I now want to move the changes to production and to do so, we have planned to create a folder called prod and migrate all files and subfolders inside dev to prod and while doing so, i want to update the dataset to use prod db connection as datasource. How should I do this? I saw asset bundle export and import job documentations. Is that the way to go? Or are there any other ways to achieve this?
Hi @Abishek_B
Welcome to the community!
Easiest way and its manual, is if they are in same account and fields are same from DEV to PROD then create a dataset from PROD database and save a copy of dev analysis and name it PROD analysis and replace the PROD dataset in copied PROD analysis and you can publish dashboard from PROD analysis.
If you automate the process, the newer APIs offer a more straightforward and streamlined approach to migrating assets between environments, as they allow you to bundle assets together without the need to manually find dependent object IDs.
The following blog provides an in-depth explanation on how to configure the CloudFormation template using the CLOUDFORMATION_JSON option. For details on using the QUICKSIGHT_JSON option.
Please refer the below QuickSight documentations this might be helpful for you.
1 Like
Hi, Thanks for the reply. With the manual approach, how do we change the data source from dev to prod after creating a copy of the dataset? I’m unable to find the edit option.
Hi @Abishek_B
Create the datasource using the PROD database credentials, then create a dataset using the PROD datasource. After the dataset is created, ensure that the field names and data types match those in DEV exactly. Next, step is to replace the dataset in the analysis, save a copy of the DEV analysis, rename it to PROD analysis, and replace the dataset with the PROD dataset in the renamed PROD analysis.
1 Like
Hi @Abishek_B,
It’s been awhile since we last heard from you; did you have any additional questions regarding your initial topic or were you able to find a work around?
If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.
Thank you!
Hi @Abishek_B,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for any relevant information that may be needed.
Thank you!