•  Introduction to Open Table Connector
  •  Open Table Connector assets
•  Connections for Open Table
  •  Prerequisites
    •  Create minimal IAM policies
    •  Install the JDBC driver
    •  Configure EC2 role to assume role
  •  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_FORMAT

OPEN_TABLE_CONN-OPENTABLETYPE-APACHE_ICEBERG

OPEN_TABLE_CONN-OPENTABLETYPE-DELTA LAKE

OPEN_TABLE_CONN-CATALOGTYPE

OPEN_TABLE_CONN-CATALOGTYPE-AWS_GLUE_CATALOG

OPEN_TABLE_CONN-AWS_GLUE_CATALOG-ATHENAJDBCURL

OPEN_TABLE_CONN-RESTCATALOGAUTHENTICATIONTYPE

OPEN_TABLE_CONN-RESTCATALOGAUTHENTICATIONTYPE-NONE

OPEN_TABLE_CONN-CATALOGTYPE-HIVE_METASTORE

OPEN_TABLE_CONN-HIVE_METASTORE-HIVEMETASTOREURI

OPEN_TABLE_CONN-HIVE_METASTORE-HIVEJDBCURL

OPEN_TABLE_CONN-HIVE_METASTORE-HIVEUSERNAME

OPEN_TABLE_CONN-HIVE_METASTORE-HIVEPASSWORD

OPEN_TABLE_CONN-CATALOGTYPE-REST_CATALOG

OPEN_TABLE_CONN-REST_CATALOG-RESTCATALOGTYPE

OPEN_TABLE_CONN-REST_CATALOG-RESTCATALOGENDPOINT

OPEN_TABLE_CONN-RESTCATALOGAUTHENTICATIONTYPE-CLIENTCREDENTIAL

OPEN_TABLE_CONN-CLIENTCREDENTIALS-ACCESSTOKENURL

OPEN_TABLE_CONN-CLIENTCREDENTIALS-CLIENTID

OPEN_TABLE_CONN-CLIENTCREDENTIALS-CLIENTSECRET

OPEN_TABLE_CONN-CLIENTCREDENTIALS-SCOPE

OPEN_TABLE_CONN-REST_CATALOG-CREDENTIALVENDING

OPEN_TABLE_CONN-REST_CATALOG-CREDENTIALVENDING-ENABLED

OPEN_TABLE_CONN-REST_CATALOG-CREDENTIALVENDING-DISABLED

OPEN_TABLE_CONN-STORAGETYPE

OPEN_TABLE_CONN-STORAGETYPE-AMAZON_S3

OPEN_TABLE_CONN-AUTHENTICATIONTYPE

OPEN_TABLE_CONN-AUTHENTICATIONTYPE-PERMANENT_IAM_CREDENTIALS

OPEN_TABLE_CONN-PERMANENT_IAM_CREDENTIALS-ACCESSKEY

OPEN_TABLE_CONN-PERMANENT_IAM_CREDENTIALS-SECRETKEY

OPEN_TABLE_CONN-AUTHENTICATIONTYPE-EC2_ROLE_TO_ASSUME_ROLE

OPEN_TABLE_CONN-EC2_ROLE_TO_ASSUME_ROLE-EC2ROLE

OPEN_TABLE_CONN-EC2_ROLE_TO_ASSUME_ROLE-EXTERNALID

OPEN_TABLE_CONN-STORAGETYPE-AZURE_ADLS_GEN2

OPEN_TABLE_CONN-AUTHENTICATIONTYPE-SERVICE_PRINCIPAL_AUTHENTICATION

OPEN_TABLE_CONN-SERVICE_PRINCIPAL_AUTHENTICATION-AZUREACCOUNTNAME

OPEN_TABLE_CONN-SERVICE_PRINCIPAL_AUTHENTICATION-AZURECLIENTID

OPEN_TABLE_CONN-SERVICE_PRINCIPAL_AUTHENTICATION-AZURECLIENTSECRET

OPEN_TABLE_CONN-SERVICE_PRINCIPAL_AUTHENTICATION-AZURETENENTID