Athena: Delta Table DDL failed with an unexpected error.

Question

I am trying to create the table using that following command that worked fine yesterday:
```
CREATE EXTERNAL TABLE IF NOT EXISTS `delta_gold`.`properties`
LOCATION 's3://org-delta/gold/properties/'
TBLPROPERTIES ('table_type' = 'DELTA');
```
, but today It creates the broken table without schema and important properties and error message as a result:

```
Delta Table DDL failed with an unexpected error.
This query ran against the ‘delta_gold’ database, unless qualified by the query. Please post the error message on our forum  or contact customer support  with Query ID: 47ea72b9-2b59-4ae0-8b82-dd0520715c1a
```

Accepted Answer

I haven't heard back yet, but this morning my team is not having this issue with Delta Tables on Athena anymore.

Answer

I'm experiencing exactly the same issue now.

Answer

Me too -- trying to execute the query from a lambda fails with "unknown error". The athena, s3, and glue clients are all instantiated with an access token belonging to a root admin.

Retrying the query from AWS console simply works...

Athena: Delta Table DDL failed with an unexpected error.

Relevant content