S3 Tables through Athena querying - Catalog not found

Q&A
,
1

Hi,

I am facing trouble when trying to access newly created S3 Tables data through Athena on Quicksight with following message: “Query execution failed: CATALOG_NOT_FOUND: line 2:34: Catalog ‘s3tablescatalog/xxx’ does not exist”

Please note that I am successfully running query on standard S3 stored data through Athena on Quicksight.

To setup my s3 tables I have:

  1. Created a namespace called gold
  2. Used athena through CTAS query with table name: iceberg_events

Current status :

  • Quicksight is using the service-role aws-quicksight-service-role with default permission + permission to access my buckets + permission on S3
  • On Quicksight: If I run following query : SELECT * FROM “s3tablescatalog/xxx”.“gold”.“iceberg_events” limit 10 => I have the error Query execution failed: CATALOG_NOT_FOUND: line 2:34: Catalog ‘s3tablescatalog/xxx’ does not exist
  • On Athena: If I run same query I have good results

From Visualizing table data with QuickSight - Amazon Simple Storage Service, I followed first step of adding the getCatalog:* permission to the service role.

For the second part, it is not clear to me what I should do on Lake Formation for my user permission. As the error is concerning catalog, I tried to grant my user lake formation permission on catalog but it fails saying that we can’t edit permission on federated catalog. (disclamer: I am really new from Lake Formation).

Do you have any clue on what could be the issue? Please note that I have found a post on AWS forum that was not resolved: Using the new S3 Metadata and S3 Tables features - catalog does not exist | AWS re:Post

Thanks for your time,

2

Hi @athollon,
Have you reviewed this documentation to see if something was missed in granting permissions:

3

Hi @Brett, thanks for your answer.

I have manage to allow access to my table following your documentation adding super permission to my user.

1 Like