Redshift CDK - Grant table privilege

0

I want to add a Redshift table to an existing Redshift database (containing one table) and I want to grant INSERT (to this table) privilege to a Redshift user.

I use CDK and its module @aws-cdk/aws-redshift-alpha. The deployment fails. One of the custom resources automatically deployed by the construct try to grant the privilige. The execution failed. When I read the log of the customer resource, it's seems that the table name provided is the Physical Resource Id and not the table I set up (red rectangle). The name of the existing table is correct (blue rectangle).

Enter image description here

The CDK c

    const iotEventTable = new Table(this, "IotEventTable", {
      tableName,
      tableColumns: [
        { name: "event", dataType: "varchar(max)" },
        { name: "timestamp", dataType: "varchar(30)" },
        { name: "topic", dataType: "char(100)" }
      ],
      cluster,
      databaseName: dbName
    });

    iotEventTable.grant(user, TableAction.INSERT);
    return iotEventTable;

Any idea ?

gefragt vor 3 Monaten102 Aufrufe
1 Antwort
0

Hello there,

To best troubleshoot this issue, we require information that is non-public information. Please open a support case with AWS Support using the following link

AWS
beantwortet vor 2 Monaten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen