By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

DataBrew - Iceberg Tables Support

0

Hello, I would like to know if there is a way to query Iceberg tables (backed with S3 parquet files) cataloged within the AWS Glue Catalog using AWS Databrew. (maybe through Athena?).

Also, is it possible to update an Iceberg table as output of a DataBrew job?. Regards

Topics
Analytics
Tags
Amazon AthenaAWS Glue DataBrewAWS Glue
Language
English
Miguel Garcia
asked 3 months ago540 views
2 Answers
1
Accepted Answer

You can use a Glue Studio visual job, that uses Iceberg as the source and then a DataBrew recipe node to process the data.
In the same way you can get the output of the recipe node and store it using an Iceberg target node.

profile pictureAWS
EXPERT
Gonzalo Herreros
answered 3 months ago
0

Thank you for your quick answer. Regarding the solution my concern is how to build the Databrew recipe. If Databrew is unable to directly connect to Iceberg tables, I assume you are force to use mock data or previously download the data from Iceberg. Am I correct or there is another better way to do that? Thanks

Miguel Garcia
answered 3 months ago
  • Gonzalo Herreros EXPERT
    3 months ago

    I believe the Glue Studio data preview should work as well on recipes. Otherwise you could export sample data as you say and use the DataBrew editor if you prefer, and then use the recipe in Studio

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

Relevant content