How to set "compressionType" property in Glue Table via CDK

Question

I'm using a Table resource to create a Glue Table like so:

```
    this.glueTable = new Table(scope, `${props.glueTableName}`, {
      database: this.glueDatabase,
      tableName: props.glueTableName,
      bucket: props.bucket,
      partitionKeys: props.partitionKeys,
      dataFormat: props.dataFormat,
      columns: props.columns
    });
```
I need to explicitly set the `compressionType` of this table to `"none"`. I see there is a way to do it via the console, where we go to `Edit Table`, and then fill in the compressionType under `Table properties`.

Can anyone point me to the prop to use if I want to do it using cdk?

pmh · Answer

You'll need to use the CFN escape hatch:
```
const table = new Table(...);
const cfnTable = table.node.defaultChild as CfnTable;
cfnTable.addPropertyOverride('TableInput.Parameters.compressionType', 'none');
```

Mengxin Zhu · Answer

Latest Glue module(v2.12.0) supports `compressed` option when [creating table](https://docs.aws.amazon.com/cdk/api/v2/docs/@aws-cdk_aws-glue-alpha.Table.html#compressedspan-classapi-icon-api-icon-experimental-titlethis-api-element-is-experimental-it-may-change-without-noticespan).

How to set "compressionType" property in Glue Table via CDK

Relevant content