Menu
AWS Database Migration Service
User Guide (Version API Version 2016-01-01)

Source Data Types for Amazon S3

Data migration that uses Amazon S3 as a source for AWS DMS will need to map data from S3 to AWS DMS data types. For more information, see Defining External Tables for S3 as a Source for AWS DMS.

For information on how to view the data type that is mapped in the target, see the section for the target endpoint you are using.

For additional information about AWS DMS data types, see Data Types for AWS Database Migration Service.

AWS DMS Data Types—Amazon S3 as Source

BYTE

Requires ColumnLength. For more information, see Defining External Tables for S3 as a Source for AWS DMS.

DATE

TIME

DATETIME

TIMESTAMP

INT1

INT2

INT4

INT8

NUMERIC

Requires ColumnPrecision and ColumnScale. For more information, see Defining External Tables for S3 as a Source for AWS DMS.

REAL4

REAL8

STRING

Requires ColumnLength. For more information, see Defining External Tables for S3 as a Source for AWS DMS.

UINT1

UINT2

UINT4

UINT8

BLOB

CLOB

BOOLEAN