tbdori
January 31, 2024, 1:56pm
1
start-asset-bundle-export-job fails when I run against Snowflake dataset.
“Type”: “com.amazonaws.services.quicksight.model.InvalidParameterValueException”,
“Message”: “The data set type is not supported through API yet”
Is this not supported at the moment?
Ashok
February 21, 2024, 12:03am
4
Hi @tbdori
API actions are not supported for datasets created using File datasets. Do you have your source asset with file data set ?
1 Like
tbdori
February 21, 2024, 4:03pm
5
Yes. I have a dataset that is joining snowflake dataset with dataset from CSV file.
Then, what do you recommend for asset migration in this case?
Ashok
February 21, 2024, 4:18pm
6
HI @tbdori
Create the file dataset and snowflake dataset in the target account/region first and in the asset bundle import job, add those dataset IDs as part of override parameter.
Or you can export just the Json of analysis using describe analysis definition and update the dataset fields in the Json with Datasets created in the target account/region.
Here is the blog post for asset as code: New Amazon QuickSight API Capabilities to Accelerate Your BI Transformation | AWS News Blog
1 Like
tbdori
July 20, 2024, 1:11am
7
Hello, @Ashok
Could you confirm if this is still an issue?
I see I can export Snowflake datasource but can’t import it. It doesn’t work even when I only have snowflake datasource.
I am not sure if that’s because I haven’t overwrite parameter.
@DylanM
I have snowflake datasource. Export worked without any issue. But, I get the following error when I try to import.
res_import=targetQuickSight.start_asset_bundle_import_job(
AwsAccountId=TargetAccountID,
AssetBundleImportJobId=AssetBundleImportJobId_,
AssetBundleImportSource={"S3Uri":"s3://"+tgt_bucket_name+"/"+local_filename},
FailureAction='ROLLBACK'
)
Then, I get this error.
‘JobStatus’: ‘FAILED_ROLLBACK_COMPLETED’,
‘Errors’: [{‘Arn’: ‘arn…