Skip to main content

Syncing to Glue Data Catalog

This document walks through the steps to register an Apache XTable™ (Incubating) synced table in Glue Data Catalog on AWS.


  1. Source table(s) (Hudi/Delta/Iceberg) already written to Amazon S3. If you don't have the source table written in S3 already, you can follow the steps in this tutorial to set it up
  2. Setup access to interact with AWS APIs from the command line. If you haven’t installed AWSCLIv2, you do so by following the steps outlined in AWS docs and also set up access credentials by following the steps here
  3. Clone the Apache XTable™ (Incubating) repository and create the xtable-utilities-0.1.0-SNAPSHOT-bundled.jar by following the steps on the Installation page


Running sync

Create my_config.yaml in the cloned Apache XTable™ (Incubating) directory.

sourceFormat: DELTA|ICEBERG # choose only one
tableBasePath: s3://path/to/source/data
tableName: table_name

Replace with appropriate values for sourceFormat, tableBasePath and tableName fields.

From your terminal under the cloned xtable directory, run the sync process using the below command.

java -jar xtable-utilities/target/xtable-utilities-0.1.0-SNAPSHOT-bundled.jar --datasetConfig my_config.yaml

At this point, if you check your bucket path, you will be able to see the .hoodie or _delta_log or metadata directory with metadata files which contains the information that helps query engines interpret the data as the target table.

Register the target table in Glue Data Catalog

From your terminal, create a glue database.

aws glue create-database --database-input "{\"Name\":\"xtable_synced_db\"}"

From your terminal, create a glue crawler. Modify the <yourAccountId>, <yourRoleName> and <path/to/your/data>, with appropriate values.

export accountId=<yourAccountId>
export roleName=<yourRoleName>
export s3DataPath=s3://<path/to/source/data>
aws glue create-crawler --name xtable_crawler --role arn:aws:iam::${accountId}:role/service-role/${roleName} --database xtable_synced_db --targets "{\"HudiTargets\":[{\"Paths\":[\"${s3DataPath}\"]}]}"

From your terminal, run the glue crawler.

 aws glue start-crawler --name xtable_crawler

Once the crawler succeeds, you’ll be able to query this Iceberg table from Athena, EMR and/or Redshift query engines.

LIMITATION for Hudi target format:

To validate the Hudi targetFormat table results, you need to ensure that the query engine that you're using supports Hudi version 0.14.0 as mentioned here


In this guide we saw how to,

  1. sync a source table to create metadata for the desired target table formats using Apache XTable™ (Incubating)
  2. catalog the data in the target table format in Glue Data Catalog
  3. query the target table using Amazon Athena