Using lakeFS with Amazon Athena

Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL.

Amazon Athena works directly above S3 and can’t access lakeFS.

In order to support querying data from lakeFS with Amazon Athena, we will use create-symlink, one of the metastore commands in lakectl.

create-symlink receives a table in glue pointing to lakeFS and creates a copy of the table in glue pointing to the underlying S3 bucket. We can then query the new created table with Athena