Overriding the default Athena schema with AWS Quicksight start-asset-bundle-import-job API via CLI
I have two aws accounts with an AWS QuickSight dashboard in my source environment and am trying to copy that dashboard to my target environment on the other account. I have identical Athena databases/tables in both environments with the exception of the schema name. I can’t figure out how to issue or format the --override-parameters
argument in the CLI to supply the appropriate schema name (or otherwise), so when I execute the start-asset-bundle-import-job
. However, if I run start-asset-bundle-export-job
on my source environment and download the output .qs bundle, and edit the schema name in the datasets .json file, and then simply run start-asset-bundle-import-job
, everything works. If I attempt to update the dataset via the CLI using the --physical-table-map
, the dashboards are unable to connect to the data. I’ve also tried running the --override-parameters
option with no luck. Does anyone know how to issue change the schema of the Athena database upon import with the API?