External table with delta does not return any rows in Athena


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?

asked a year ago397 views
1 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,

answered a year 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