•  Introduction to Open Table Connector
  •  Open Table Connector assets
•  Connections for Open Table
  •  Prerequisites
    •  Create minimal IAM policies
    •  Install the JDBC driver
  •  Connect to Open Table
    •  Before you begin
    •  Open Table formats with associated catalog and storage types
    •  Connection details
    •  Catalog types
    •  Storage types
•  Mappings and mapping tasks with Open Table Connector
  •  Open Table sources in mappings
  •  Open Table targets in mappings
    •  Create a target table at runtime
  •  Open Table lookups in mappings
  •  Using time travel queries
  •  Dynamic schema handling
    •  Rules and guidelines for dynamic schema handling
  •  Rules and Guidelines for Open Table tasks
•  Data type reference
  •  Open Table and transformation data types

Introduction to Open Table Connector

Open Table and transformation data types

OPEN_TABLE_CONN

OPEN_TABLE_CONN-CONN_NAME

OPEN_TABLE_CONN-CONN_DESC

OPEN_TABLE_CONN-CONN_TYPE

OPEN_TABLE_CONN-AGENTGROUPID

OPEN_TABLE_CONN-OPENTABLETYPE

OPEN_TABLE_CONN-OPENTABLETYPE-SELECT_OPEN_TABLE_TYPE

OPEN_TABLE_CONN-OPENTABLETYPE-APACHE_ICEBERG

OPEN_TABLE_CONN-OPENTABLETYPE-DELTA LAKE

OPEN_TABLE_CONN-APACHE_ICEBERG-CATALOGTYPE

OPEN_TABLE_CONN-DELTA_LAKE-CATALOGTYPE

OPEN_TABLE_CONN-APACHE_ICEBERG-CATALOGTYPE-AWS_GLUE_CATALOG

OPEN_TABLE_CONN-DELTA_LAKE-CATALOGTYPE-AWS_GLUE_CATALOG

OPEN_TABLE_CONN-APACHE_ICEBERG-AWS_GLUE_CATALOG-ATHENAJDBCURL

OPEN_TABLE_CONN-DELTA_LAKE-AWS_GLUE_CATALOG-ATHENAJDBCURL

OPEN_TABLE_CONN-APACHE_ICEBERG-CATALOGTYPE-HIVE_METASTORE

OPEN_TABLE_CONN-APACHE_ICEBERG-HIVE_METASTORE-HIVEMETASTOREURI

OPEN_TABLE_CONN-HIVEMETASTOREURI

OPEN_TABLE_CONN-APACHE_ICEBERG-HIVE_METASTORE-HIVEJDBCURL

OPEN_TABLE_CONN-HIVEJDBCURL

OPEN_TABLE_CONN-APACHE_ICEBERG-HIVE_METASTORE-HIVEUSERNAME

OPEN_TABLE_CONN-HIVEUSERNAME

OPEN_TABLE_CONN-APACHE_ICEBERG-HIVE_METASTORE-HIVEPASSWORD

OPEN_TABLE_CONN-HIVEPASSWORD

OPEN_TABLE_CONN-APACHE_ICEBERG-AWS_GLUE_CATALOG-STORAGETYPE

OPEN_TABLE_CONN-APACHE_ICEBERG-AWS_GLUE_CATALOG-STORAGETYPE-SELECT_STORAGE_TYPE

OPEN_TABLE_CONN-DELTA_LAKE-AWS_GLUE_CATALOG-STORAGETYPE

OPEN_TABLE_CONN-APACHE_ICEBERG-AWS_GLUE_CATALOG-STORAGETYPE-AMAZON_S3

OPEN_TABLE_CONN-DELTA_LAKE-AWS_GLUE_CATALOG-STORAGETYPE-AMAZON_S3

OPEN_TABLE_CONN-APACHE_ICEBERG-AWS_GLUE_CATALOG-AMAZON_S3-AUTHENTICATIONTYPE

OPEN_TABLE_CONN-APACHE_ICEBERG-AWS_GLUE_CATALOG-AMAZON_S3-AUTHENTICATIONTYPE-SELECT_AUTHENTICATION_TYPE

OPEN_TABLE_CONN-APACHE_ICEBERG-AWS_GLUE_CATALOG-AMAZON_S3-AUTHENTICATIONTYPE-PERMANENT_IAM_CREDENTIALS

OPEN_TABLE_CONN-DELTA_LAKE-AWS_GLUE_CATALOG-AMAZON_S3-AUTHENTICATIONTYPE

OPEN_TABLE_CONN-DELTA_LAKE-AWS_GLUE_CATALOG-AMAZON_S3-AUTHENTICATIONTYPE-PERMANENT_IAM_CREDENTIALS

OPEN_TABLE_CONN-APACHE_ICEBERG-AWS_GLUE_CATALOG-AMAZON_S3-PERMANENT_IAM_CREDENTIALS-ACCESSKEY

OPEN_TABLE_CONN-DELTA_LAKE-AWS_GLUE_CATALOG-AMAZON_S3-PERMANENT_IAM_CREDENTIALS-ACCESSKEY

OPEN_TABLE_CONN-APACHE_ICEBERG-AWS_GLUE_CATALOG-AMAZON_S3-PERMANENT_IAM_CREDENTIALS-SECRETKEY

OPEN_TABLE_CONN-DELTA_LAKE-AWS_GLUE_CATALOG-AMAZON_S3-PERMANENT_IAM_CREDENTIALS-SECRETKEY

OPEN_TABLE_CONN-APACHE_ICEBERG-HIVE_METASTORE-STORAGETYPE-AZURE_ADLS_GEN2

OPEN_TABLE_CONN-APACHE_ICEBERG-HIVE_METASTORE-AZURE_ADLS_GEN2-AUTHENTICATIONTYPE

OPEN_TABLE_CONN-APACHE_ICEBERG-HIVE_METASTORE-AZURE_ADLS_GEN2-AUTHENTICATIONTYPE-SERVICE_PRINCIPAL_AUTHENTICATION

OPEN_TABLE_CONN-APACHE_ICEBERG-HIVE_METASTORE-AZURE_ADLS_GEN2-SERVICE_PRINCIPAL_AUTHENTICATION-AZUREACCOUNTNAME

OPEN_TABLE_CONN-APACHE_ICEBERG-HIVE_METASTORE-AZURE_ADLS_GEN2-SERVICE_PRINCIPAL_AUTHENTICATION-AZURECLIENTSECRET

OPEN_TABLE_CONN-APACHE_ICEBERG-HIVE_METASTORE-AZURE_ADLS_GEN2-SERVICE_PRINCIPAL_AUTHENTICATION-AZURECLIENTID

OPEN_TABLE_CONN-APACHE_ICEBERG-HIVE_METASTORE-AZURE_ADLS_GEN2-SERVICE_PRINCIPAL_AUTHENTICATION-AZURETENENTID