(@aws-cdk/aws-glue-alpha): Add partition_filtering.enabled support

[atsaki]

Describe the feature

Table construct support partition indexes. However, the feature to set partition_filtering.enabled: true to enable partition filtering is missing.

https://docs.aws.amazon.com/athena/latest/ug/glue-best-practices.html#glue-best-practices-partition-index

It would be nice if Table construct provide the way to set partition_filtering.enabled property.

Use Case

I always manually add partition_filtering.enabled: true after creating the table.
It would helpful if I can add the property with Table construct.

Proposed Solution

How about adding a partitionFilteringEnable prop to TableProps and setting parameters like classification and has_encrypted_data?

        parameters: {
          classification: props.dataFormat.classificationString?.value,
          has_encrypted_data: this.encryption !== TableEncryption.UNENCRYPTED,
          'partition_filtering.enabled': props.partitionFilteringEnabled,
        },

aws-cdk/packages/@aws-cdk/aws-glue/lib/table.ts

Lines 304 to 307 in 74318c7

	parameters: {
	classification: props.dataFormat.classificationString?.value,
	has_encrypted_data: this.encryption !== TableEncryption.UNENCRYPTED,
	},

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.28.1

Environment details (OS name and version, etc.)

Windows

[kaizencc]

The proposed solution is good. I would be happy to take a contribution on this. I'd call the prop enablePartitionFiltering. @atsaki do you want to work on this?

[atsaki]

@kaizencc Yes, I would like to try it!

[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.