•  Introduction to Open Table Connector
  •  Open Table Connector assets
•  Connections for Open Table
  •  Prerequisites
    •  Create minimal IAM policies
    •  Adding the Amazon Athena JDBC driver
  •  Connect to Open Table
    •  Before you begin
    •  Connection details
•  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-APACHE_ICEBERG-CATALOGTYPE

OPEN_TABLE_CONN-APACHE_ICEBERG-CATALOGTYPE-AWS_GLUE_CATALOG

OPEN_TABLE_CONN-APACHE_ICEBERG-AWS_GLUE_CATALOG-STORAGETYPE

OPEN_TABLE_CONN-APACHE_ICEBERG-AWS_GLUE_CATALOG-STORAGETYPE-SELECT_STORAGE_TYPE

OPEN_TABLE_CONN-APACHE_ICEBERG-AWS_GLUE_CATALOG-STORAGETYPE-AMAZON_S3

OPEN_TABLE_CONN-APACHE_ICEBERG-AWS_GLUE_CATALOG-ATHENAJDBCURL

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-APACHE_ICEBERG-AWS_GLUE_CATALOG-AMAZON_S3-PERMANENT_IAM_CREDENTIALS-ACCESSKEY

OPEN_TABLE_CONN-APACHE_ICEBERG-AWS_GLUE_CATALOG-AMAZON_S3-PERMANENT_IAM_CREDENTIALS-SECRETKEY