Quicksight: Facing "DataSourceCredentials field is incorrectly set" error on asset bundle override to override snowflake credentials

Question & Answer
,
1

Hey I am facing weird issue for overriding snowflake credentials on asset bundle import. I don’t know but there is no clear instructions I found in AWS official documents as well. This is literally frustrating.

Here is my override JSON

"DataSources": [
                  {
                      "DataSourceId": $id,
                      "Name": $name,
                      "Credentials": {
                          "CredentialPair": {
                              "Username": $username,
                              "Password": $password
                          }
                      }
                  }
              ]

I also tried variations too make sure i don’t make any mistakes.

"DataSources": [
                    {
                        "DataSourceId": $id,
                        "Name": $name,
                        "DataSourceParameters": {
                            "SnowflakeParameters": {
                                "Host": "MyHost",
                                "Database": "MyDB",
                                "Warehouse": "MyWH"
                            }
                        },
                        "Credentials": {
                            "CredentialPair": {
                                "Username": $username,
                                "Password": $password
                            }
                        },
                        "SslProperties": {
                            "DisableSsl": false
                        }
                    }
                ]

But I get the following error everytime.

Job failed with status: {
    "Status": 200,
    "JobStatus": "FAILED",
    "Errors": [
        {
            "Arn": "myArn",
            "Type": "com.amazonaws.services.quicksight.model.InvalidParameterValueException",
            "Message": "DataSourceCredentials field is incorrectly set"
        }
......

Let me know what I am missing here.

2

Hello Kaushal,

I am not sure if this will fix the issue but could try using SnowflakeCredentials instead of ‘CredentialPair’ and see if it helps ?

{
“DataSources”: [
{
“DataSourceId”: “$id”,
“Name”: “$name”,
“DataSourceParameters”: {
“SnowflakeParameters”: {
“Host”: “MyHost”,
“Database”: “MyDB”,
“Warehouse”: “MyWH”
}
},
“Credentials”: {
“SnowflakeCredentials”: {
“Username”: “$username”,
“Password”: “[PASSWORD]”
}
},
“SslProperties”: {
“DisableSsl”: false
}
}
]
}

Thank you.

Cheers,
Deep

3

Hey @Deep

I already tried this and it’s not working. I would love to read official document reference, if it really exist. But i already reached to AWS support and yet they were not able to resolve this case.

I hope they will figure out the case and provide me a proper direction to address.