Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.
Success
Manage your Success Plans and Engagements, gain key insights into your implementation journey, and collaborate with your CSMs
Customer Experience Accelerators
Accelerate your Purchase to Value by engaging with Informatica for Customer Success
My Engagements
All your Engagements at one place
 Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
 Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Experience Lounge
Self-guided, intuitive experience platform for outcome-focused product capabilities and use cases
 Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
SupportFlash
Monthly support newsletter
Product Availability Matrix
Product Availability Matrix statements of Informatica products
Product Lifecycle
End of Life statements of Informatica products
Pulse
Monitor the status of your Informatica services across regions
Events
Change Request Tracking
Marketplace
Trust Platform
English
  • Data Integration Connectors
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction to Open Table Connector
  3. Connections for Open Table
  4. Mappings and mapping tasks with Open Table Connector
  5. Data type reference

Open Table Connector

Open Table Connector

Back Next

Prerequisites

Prerequisites

Before you create an Open Table connection, complete the prerequisites.

Using AWS Glue Catalog and Amazon S3 Storage to interact with Apache Iceberg or Delta Lake tables

If you use an AWS Glue Catalog and Amazon S3 Storage to interact with Apache Iceberg or Delta Lake tables, you need to have access to the following AWS services that manage the tables on AWS:
  • AWS Glue Catalog: AWS Glue Catalog manages the metadata associated with the Apache Iceberg or Delta Lake tables.
  • Amazon S3 Storage: Amazon S3 stores the Apache Iceberg or Delta Lake tables containing actual records in columnar format, organized in partitioned directories.
  • Amazon Athena: Amazon Athena uses the AWS Glue Data Catalog to store metadata such as table and column names for your data stored in Amazon S3. Open Table Connector uses the Amazon Athena JDBC driver to connect to the AWS Glue Catalog to access Apache Iceberg or Delta Lake tables metadata.
You need to create separate policies to access these services.

Using Hive Metastore catalog and Microsoft Azure Data Lake Storage Gen2 to interact with Apache Iceberg tables

If you use a Hive Metastore catalog and Microsoft Azure Data Lake Storage Gen2 to interact with Apache Iceberg tables, you need to have access to the following services that manage the tables on Microsoft Azure Data Lake Storage Gen2:
  • Hive Metastore catalog: Hive Metastore catalog manages the metadata associated with the Apache Iceberg tables. The metastore must use Hive version 4.0.
  • Microsoft Azure Data Lake Storage Gen2: Microsoft Azure Data Lake Storage Gen2 stores the Apache Iceberg tables containing actual records in columnar format, organized in partitioned directories.
  • Hive JDBC driver: Hive JDBC driver connects to the Hive server to access the metadata of Apache Iceberg tables.

Using Hive Metastore catalog and Amazon S3 storage to interact with Apache Iceberg tables

If you use a Hive Metastore catalog and Amazon S3 storage to interact with Apache Iceberg tables, you need to have access to the following services that manage the tables on Amazon S3 storage:
  • Hive Metastore catalog: Hive Metastore catalog manages the metadata associated with the Apache Iceberg tables. The metastore must use Hive version 4.0.
  • Amazon S3 storage: Amazon S3 stores the Apache Iceberg tables containing actual records in columnar format, organized in partitioned directories.
  • Hive JDBC driver: Hive JDBC driver connects to the Hive server to access the metadata of Apache Iceberg tables.

Using REST catalog and Amazon S3 to interact with Apache Iceberg tables

If you use a REST catalog such as Polaris catalog and Amazon S3 storage to interact with Apache Iceberg tables, you need to have access to the following services that manage the tables on Amazon S3 storage:
  • REST catalog: REST catalog manages the metadata associated with the Apache Iceberg tables.
  • Amazon S3 storage: Amazon S3 stores the Apache Iceberg tables containing actual records in columnar format, organized in partitioned directories.
0 COMMENTS
We’d like to hear from you!
Alessio Giordani - November 06, 2025

Hello documentation team,

can you please emphasize that the only supported Hive Metastore Catalog version is Hive 4? it is mentioned between the lines in the JDBC Driver section for Amazon S3 section, but would be good to put in clear in the initial statement, i.e.:

  • Hive Metastore catalog: Hive Metastore catalog manages the metadata associated with the Apache Iceberg tables. An Hive 4 Metastore Catalog is required

Either in the "Using Hive Metastore catalog and Microsoft Azure Delta Lake Storage Gen2 to interact with Apache Iceberg table" and "Using Hive Metastore catalog and Amazon S3 storage to interact with Apache Iceberg tables" sections.

Thanks,

Alessio

    Informatica Documentation Team - November 07, 2025

    Hi Alessio,

    We're working to address your comments and will get back to you.

    Regards,

    Informatica Documentation Team

    Informatica Documentation Team - November 28, 2025

    Hi Alessio,

    We're glad to let you know that we addressed your comments on this page. The documentation now specifies that the metastore must use Hive version 4.0.

    Regards,

    Informatica Documentation Team