How do I drop native Delta tables from Athena catalog?

Question

Onboarded native Delta table using

```
CREATE EXTERNAL TABLE [table_name]
LOCATION '[s3_location]'
TBLPROPERTIES (
'table_type'='DELTA'
);
```

Works great when I query it. However, when I run

```
drop table [table_name]
```

I get the following error:

"Routed statement type 'DROP_TABLE' to DeltaLakeDDLEngine, expected to route to DATACATALOG_DDL_ENGINE"

Answer

Deleting from the Glue UI or using Glue API works

Answer

Is it possible to re-open the issue? The workaround using the glue ui to drop the table doesn't solve the issue. From the documentation create and drop table should work directly from athena (https://docs.aws.amazon.com/athena/latest/ug/delta-lake-tables.html):![Enter image description here](/media/postImages/original/IM4Wyu2hqUTzilmHyHAirJEw)

How do I drop native Delta tables from Athena catalog?

Contenuto pertinente