TABLE_REDIRECTION_ERROR on Glue Catalog Delta Table


I have a Databricks pipeline set up to create Delta tables, using Glue Catalog as the Metastore. I was able to query the Delta table via Athena successfully. However, starting from 2024-02-06, I began encountering TABLE_REDIRECTION_ERROR.

SELECT * FROM "<database>"."<table>" limit 10;
TABLE_REDIRECTION_ERROR: Table 'awsdatacatalog.<database>.<table>' redirected to 'awsdatacatalog$delta-lake-aws.<database>.<table>', 
but the target table 'awsdatacatalog$delta-lake-aws.<database>.<table>' does not exist.!

Enter image description here

asked 4 months ago168 views
1 Answer


I would like to inform in Athena, for Delta Lake tables, CREATE TABLE statements should include only the LOCATION and table_type property. Hence, any additional table properties are not supported in Athena for delta table. I would suggest you to check the table DDL and verify if it contains any other property like CLUSTER BY then remove it from create table statement.


[1] [2]

answered 3 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions