Why can't I set compression_level with athena CREATE TABLE AS?

Question

According to the docs https://docs.aws.amazon.com/athena/latest/ug/compression-support-zstd-levels.html Athena v3 should allow me to set compression level when using `ZSTD`, but Athena throws a syntax error:

```sql
CREATE TABLE some_db."amazingstuff"
    WITH (
        write_compression = 'ZSTD',
        format = 'PARQUET',
        compression_level = '10',
        table_type = 'ICEBERG',
        is_external = false,
        location = 's3://foo/table'
    ) AS
SELECT "id" FROM "schema"."table";
```

In the AWS console I get:

> Unsupported property compression_level.

I'm on Athena v3 because feature changes since v2 like `SELECT CONCAT('athena_v3_requires_two_args');` fails. I also can't do ALTER TABLE or any some such. Why is that?

Answer

Does it work if you specify the compression level as an integer instead of a string ?
compression_level = 10

Why can't I set compression_level with athena CREATE TABLE AS?

Relevant content