Mapping Between MySQL and LakeFormation Field Types

String

CHAR(M)

STRING

-

VARCHAR(M)

STRING

-

Numeric

BOOLEAN

BOOLEAN

-

TINYINT

INT

By default, TINYINT(1) is converted to BOOLEAN. If you want to keep it as TINYINT(1), add the following attribute to the MySQL data connection in Management Center: tinyInt1isBit = false

TINYINT UNSIGNED

INT

-

SMALLINT

INT

-

SMALLINT UNSIGNED

INT

-

MEDIUMINT

INT

-

MEDIUMINT UNSIGNED

LONG

-

INT

INT

-

INT UNSIGNED

LONG

-

BIGINT

LONG

-

BIGINT UNSIGNED

DECIMAL(38,0)

-

REAL

DOUBLE

-

DECIMAL(M,D)

DECIMAL(M,D)

-

NUMERIC

DECIMAL(M,D)

-

FLOAT

FLOAT

-

DOUBLE

DOUBLE

-

DOUBLE PRECISION

DOUBLE

-

Bit

BIT(M)

BOOLEAN

-

Date and time

DATE

DATE

-

TIME

STRING

-

DATETIME

TIMESTAMP

-

TIMESTAMP

STRING

MySQL timstamps contain time zone information. LakeFormation does not support types with time zones.

YEAR(M)

STRING

-

Multimedia (binary)

BINARY(M)

BINARY

-

VARBINARY(M)

BINARY

-

TEXT

STING

-

TINYTEXT

STING

-

MEDIUMTEXT

STING

-

LONGTEXT

STING

-

BLOB

BINARY

-

TINYBLOB

BINARY

-

MEDIUMBLOB

BINARY

-

LONGBLOB

BINARY

A maximum of 4 GB data can be stored, which is not supported currently.

Special types

SET

STRING

-

JSON

STRING

-

ENUM

STRING

-