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 ?

1 Answer
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
answered 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions