External table with delta does not return any rows in Athena

Question

Hi there,

I followed this blog post,

https://aws.amazon.com/about-aws/whats-new/2022/12/athena-enhances-read-support-delta-lake-table-format/#:~:text=You%20can%20now%20query%20Delta,commonly%20built%20on%20Amazon%20S3.
https://aws.amazon.com/blogs/big-data/crawl-delta-lake-tables-using-aws-glue-crawlers/

I created a delta table with emr spark, then I created a external table with Athenas and I also tried creating it with Native and Simlink Crawler, but I cant get any rows when I do a Select query in Athenas, but it works ok in EMR,

I need to query with Athenas for sharing this tables with my users,

Do you know what could it be?

marcel · Answer

I switched to Athena version 3 as the documentation recommends,  but now It shows another error, "NOT_SUPPORTED: Lake Formation tables are not supported for Delta Lake"
 And the docs says:
"AWS Glue crawler integration with Delta Lake also supports AWS Lake Formation access control. You can grant Lake Formation permissions on the Delta tables created by the crawler to AWS principals that then query through Athena and Redshift Spectrum to access data in Delta tables."

But I with Athena version 2 does not returns data and with version 3 returns the not supported error,

External table with delta does not return any rows in Athena

Relevant content