dbt-athena partitioned_by property

[ShaunHide17]

As part of the table properties, you can specify a list of columns by which the output table can be partitioned by.

The documentation reads as below:

partitioned_by (default=none)
An array list of columns by which the table will be partitioned
Limited to creation of 100 partitions (currently)

Is this partition cap still in force, and if so, why 100?

[HommerChiu]

The 100 partition limit is a hard limit imposed by the AWS Glue Catalog. If you use Iceberg tables, dbt-athena can automatically paginate partition insertions to work around this limitation.