Athena Iceberg in CDK

Question

Usually I have no problems creating Athena tables in CDK v2 using ``new glue.Table``
However now I'm stuck trying to create Iceberg table using the same approach. Documentation was not really helpful, of far. 
I do not really want to create it using `CREATE TABLE` SQL statement for a various reasons.

It there any approach?

Answer

I haven't tried with glue.Table, but with glue.CfnTable it worked for me setting `tableType='ICEBERG` and `parameters={
                    "classification": "glueparquet",
                    "lakeformation.aso.status": "true"
                }`

The lakeformation.aso.status parameter enables automated compaction.

Answer

Hello.

CfnTable has an optional parameter `openTableFormatInput`. There is a small bit of reference here: https://docs.aws.amazon.com/cdk/api/v2/docs/aws-cdk-lib.aws_glue.CfnTable.html#opentableformatinput.

Here is a shortened version of CDK code I used as example, maybe it helps you.
```
this.table = new glue.CfnTable(this, "Table", {
        databaseName: this.databaseName,
        catalogId: this.account,
        tableInput: {
            name: tableName.toLowerCase(),
            description: description,
            storageDescriptor: {
                columns: columns,
                location: `s3://${this.bucketName}/${tableName.toLowerCase()}`,
                schemaReference: this.schemaReference,
                sortColumns: this.sortColumns,
                storedAsSubDirectories: false,
            },
            tableType: 'EXTERNAL_TABLE'
        },
        openTableFormatInput: {
            icebergInput: {
                metadataOperation: "CREATE",
                version: "2",
            }
        }
});
```

Athena Iceberg in CDK

Relevant content