Search before asking

• I searched the issues and found no similar issues.

What Happened

The SQL lint for a create table with AThena and iceberg fails

According to the documentation a create table for iceberg is as following:

https://docs.aws.amazon.com/athena/latest/ug/querying-iceberg-creating-tables.html

CREATE TABLE iceberg_table (id bigint, data string, category string) PARTITIONED BY (category)) LOCATION 's3://DOC-EXAMPLE-BUCKET/your-folder/' TBLPROPERTIES ( 'table_type' = 'ICEBERG' )

When running lint this fails as the PARTIONED BY isn't recognized by the parser.

L: 3 | P: 1 | PRS | Line 26, Position 1: Found unparsable section: | "PARTITIONED BY (category)\nLOCATION 's..."

Expected Behaviour

Parsing it correctly

Observed Behaviour

`L: 3 | P: 1 | PRS | Line 26, Position 1: Found unparsable section:
| "PARTITIONED BY (category)\nLOCATION 's..."

How to reproduce

Use the example and run sqlfluff lint --dialect athena test.sql

Dialect

Athena

Version

sqlfluff, version 2.3.5

Configuration

[sqlfluff]
max_line_length = 100
templater = python

Are you willing to work on and submit a PR to address the issue?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct