describeDataset and createDataset errors with the new experience

Q&A
, ,
1

Hello,

I’ve been using the nodejs @aws-sdk/client-quicksight library for quite a while, to describe both datasets and dashboards in a development aws account, keep the resulting descriptions versioned in a source code repository, then deploy them in other aws accounts or with other names, with slight modifications (mostly their dataset/dashboard ids and datasource arns). It worked perfectly.

Here is the version of @aws-sdk/client-quicksight I’m using: 3.926.0. Running in ca-central-1.

Since the migration to the new experience, a lot of things changed.
At first, simply calling describeDataset on a dataset created with the new experience produced and exception. Looks like today it is working.

But now, trying to call the CreateDatasetCommand, with the previously described dataset content (with modified dataset id and datasource arns), throws a 500 error ‘Internal Server Error‘ with no more description. Also note, calling CreateDatasetCommand with the described datasets that where produced before the experience change work fine.

Is there something that we should know that has changed for these commands to produce the expected results?

Here is the input that I am passing to CreateDatasetCommand:

{
  AwsAccountId: "xxxxxxxxxxxx",
  DataSetId: "86a8915a-58d2-4f5f-b1d7-6c7dd4fe0f95",
  Name: "MyNewDataset",
  ImportMode: "SPICE",
  PhysicalTableMap: {
    "225a8732-bd52-4a03-ad51-d3acb454f93c": {
      CustomSql: {
        Columns: [
          {
            Id: "new_custo-id-c130e8",
            Name: "id",
            Type: "INTEGER",
          },
          {
            Id: "new_custo-txten-dfc711",
            Name: "txten",
            Type: "STRING",
          },
          {
            Id: "new_custo-txtfr-68da4f",
            Name: "txtfr",
            Type: "STRING",
          },
          {
            Id: "new_custo-context-a3bb01",
            Name: "context",
            Type: "STRING",
          },
          {
            Id: "new_custo-domain-c30bcf",
            Name: "domain",
            Type: "STRING",
          },
          {
            Id: "new_custo-sources-2544f9",
            Name: "sources",
            Type: "STRING",
          },
          {
            Id: "new_custo-updatedat-99592e",
            Name: "updatedat",
            Type: "DATETIME",
          },
          {
            Id: "new_custo-notes-0632dc",
            Name: "notes",
            Type: "STRING",
          },
        ],
        DataSourceArn: "arn:aws:quicksight:ca-central-1:xxxxxxxxxxxx:datasource/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
        Name: "New custom SQL",
        SqlQuery: `select id, txten, txtfr, context, domain, sources, updatedat, notes from mytable`,
      },
    },
  },
  Permissions: [
    {
      Actions: [
        "quicksight:DeleteDataSet",
        "quicksight:UpdateDataSetPermissions",
        "quicksight:PutDataSetRefreshProperties",
        "quicksight:CreateRefreshSchedule",
        "quicksight:CancelIngestion",
        "quicksight:ListRefreshSchedules",
        "quicksight:UpdateRefreshSchedule",
        "quicksight:PassDataSet",
        "quicksight:DeleteRefreshSchedule",
        "quicksight:DescribeDataSetRefreshProperties",
        "quicksight:DescribeDataSet",
        "quicksight:CreateIngestion",
        "quicksight:DescribeRefreshSchedule",
        "quicksight:ListIngestions",
        "quicksight:UpdateDataSet",
        "quicksight:DescribeDataSetPermissions",
        "quicksight:DeleteDataSetRefreshProperties",
        "quicksight:DescribeIngestion",
      ],
      Principal: "arn:aws:quicksight:ca-central-1:xxxxxxxxxxxx:group/default/admins",
    },
  ],
}

Regards