Dev to Prod migration

Question & Answer
, , ,
1

Hi team,
I am migrating from dev to prod in two different accounts using start_asset_bundle_import_job and start_asset_bundle_export_job APIs. The export worked for me with default settings, however, facing some issues with the import job. My connections in dev are set up using databricks sql endpoint connections with username & password. In the import job I have the following in Datasource:

                "DataSources": [
                    {
                        "DataSourceId": dev datasource name,
                        'Name': 'name',
                        'DataSourceParameters': {
                            'DatabricksParameters': {
                                'Host': 'same as dev',
                                'Port': same as dev,
                                'SqlEndpointPath': 'same as dev'
                            },
                        },
                        'Credentials': {
                            'CredentialPair': {
                                'Username': 'same as dev',
                                'Password': 'same as dev'
                            }
                        }
                    }
                ],
            }

However, I am get error: Feature is not supported for this data source type.

2

Hi @zoomjin ,

Are there any other datasource such a csv or this is the only datasource connection?

You can try describe-asset-bundle-import-job commands to fetch which asset is throwing the exception and further use describe commands to check the datasource/dataset id in question.

Thanks,
Prantika

1 Like
3

Hi @prantika_sinha, sorry for the delayed reply. I checked with describe-asset-bundle-import-job and in the response, it has
‘Errors’: [{‘Arn’: ‘arn:aws:quicksight:us-east-1:account:datasource/datasourceId’,
‘Type’: ‘com.amazonaws.services.quicksight.model.InvalidParameterValueException’,
‘Message’: ‘Feature is not supported for this data source type’}.

This is the databricks datasource giving issue.
Also tried to migrate the sample dashboard provided by quicksight and it worked without an issue, as soon as I have added this databricks datasource into the dashboard, it starts to give the same error message.

4

Issue resolved after removing from the code:

‘ResourceIdOverrideConfiguration’: {

            #     'PrefixForAllResources': 'prod'
            # }

Asset has successfully migrated for me.

1 Like