Copying Quicksight analysis with same data but different datasets

Hi. Here are some steps you can follow to copy the analysis from one region to another:

1. Export the analysis from the source region: Use the "get-dashboard" command to export the analysis JSON file from the source region:

aws quicksight describe-analysis --aws-account-id <source_account_id> --analysis-id <source_analysis_id> --region <source_region> --output json > analysis.json

2. Open the analysis.json file and replace all occurrences of the source dataset name and column names with the target dataset name and column names. Import the modified analysis to the target region.

3. Use the create-analysis command to import the modified analysis to the target region:

aws quicksight create-analysis --aws-account-id <target_account_id> --analysis-id <target_analysis_id> --name "New Analysis" --source-entity=file://analysis.json --region <target_region>

Hopefully, It should work!

Hi, To import an analysis from a JSON file, you can try the "update-analysis command" instead. Here is an example command:

aws quicksight update-analysis --aws-account-id <your-account-id> --analysis-id <analysis-id> --source-entity=file://path/to/modified_analysis.json --force-embed-dataset --region <region>

Make sure to replace the placeholders in the command with the actual values for your account, analysis ID, JSON file path, and region.Note the use of "file://" to specify the path to the JSON file. Also note the use of "--force-embed-dataset" to embed the dataset in the analysis. This is necessary because the dataset in the new region may have a different name than the dataset in the original region. With this command, you should be able to import the analysis from the JSON file in the new region.

Let me know if it works!