Partitioned Iceberg models are not created correctly using Athena

[sean-eyre]

I have a model I'm running on Athena using Iceberg with INCREMENTAL_BY_TIME_RANGE, however the CREATE TABLE statement executed on Athena uses a partitioned_by property, rather than the partitioning property used for Iceberg tables (docs).

This results in the model plan failing with Catalog 'awsdatacatalog$iceberg-aws' table property 'partitioned_by' does not exist.

Here's my model config:

MODEL (
    name model.name,
    kind INCREMENTAL_BY_TIME_RANGE (
      time_column business_date
   ),
    cron '@daily',
    table_format iceberg,
    start '2025-01-15'
);

And here's what is run in Athena:

CREATE TABLE IF NOT EXISTS ...
WITH (
    table_type='iceberg', 
    partitioned_by=ARRAY['business_date'], 
    location='...', 
    is_external=false
) 
AS ...

Thanks

[treysp]

Athena docs: https://docs.aws.amazon.com/athena/latest/ug/create-table-as.html#ctas-table-properties

[georgesittas]

Fixed by linked sqlglot PR.