Hello @hzh,

Thanks for your question!

UC Federation Connection Type and Metastore Type

When creating a connection for UC federation with a Hive metastore integrated with AWS Glue, the connection type should be Hive metastore.

Metastore Type

• If the Hive metastore is integrated with AWS Glue, the metastore type should be AWS Glue.

Read and Write Access

• UC federation supports both reading and writing to tables in the internal Hive Metastore (HMS).
• For tables in AWS Glue, UC federation supports read-only access.

Therefore, if you have a Hive metastore integrated with AWS Glue, you can do both read and write to tables in the internal HMS, but only read access to tables in AWS Glue.