@aws-cdk/aws-redshift-alpha: Add encoding and comments for redshift tables column construct

[ksco92]

Describe the feature

Currently we have this construct:

https://docs.aws.amazon.com/cdk/api/v2/docs/@aws-cdk_aws-redshift-alpha.Table.html

Whose columns are defined as:

https://docs.aws.amazon.com/cdk/api/v2/docs/@aws-cdk_aws-redshift-alpha.Column.html

And this is great. However, in the world of big data, columns need encoding for faster performance and lower storage space:

https://docs.aws.amazon.com/redshift/latest/dg/c_Compression_encodings.html

Additionally, adding comments on columns allows us to be able document and version control our data definitions:

https://docs.aws.amazon.com/redshift/latest/dg/r_COMMENT.html

Use Case

The current table construct allows the programmatic creation and modification of columns, however, in real life, econdings for performance and storage and comments for documentation are critical in any big data use case.

This addition will bring CDK one step closer to being able to fully manage a Redshift's table table structure and documentation.

Proposed Solution

The idea, is that columns can be defined as:

{
  dataType: 'varchar(10)',
  name: 'my_col',
  distKey: false,
  sortKey: false,
  encoding: 'ZSTD',
  comment: 'some comment on column'
}

Other Information

No response

Acknowledgements

• I may be able to implement this feature request
• This feature might incur a breaking change

CDK version used

2.45

Environment details (OS name and version, etc.)

AmazonLinux2

[github-actions]

⚠️COMMENT VISIBILITY WARNING⚠️

Comments on closed issues are hard for our team to see.
If you need more assistance, please either tag a team member or open a new issue that references this one.
If you wish to keep having a conversation with other community members under this issue feel free to do so.