Understand supported data types - Amazon Data Firehose
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Understand supported data types

Note

Firehose supports database as a source in all Amazon Web Services Regions except China Regions, Amazon GovCloud (US) Regions, and Asia Pacific (Malaysia). This feature is in preview and is subject to change. Do not use it for your production workloads.

Firehose supports all the primitive and complex data types that Apache Iceberg supports. For more information, see Schemas and Data Types.

MySQL to Iceberg data type mapping

MySQL type Iceberg data Type
BOOLEAN, BOOL boolean
BIT(1) boolean
BIT(>1) binary
TINYINT integer
SMALLINT[(M)] integer
MEDIUMINT[(M)] integer
INT, INTEGER[(M)] integer
BIGINT[(M)] integer
REAL[(M,D)] float
FLOAT[(P)] float
DOUBLE[(M,D)] float
CHAR(M)] string
VARCHAR(M)] string
BINARY(M)] binary or string
VARBINARY(M)] binary or string
TINYBLOB binary or string
TINYTEXT string
BLOB binary or string
TEXT string
MEDIUMBLOB binary or string
MEDIUMTEXT string
LONGBLOB binary or string
LONGTEXT string
JSON string
ENUM string
SET string
YEAR[(2|4)] integer
TIMESTAMP[(M)] string
DATE integer
TIME[(M)] integer
DATETIME, DATETIME(0), DATETIME(1), DATETIME(2), DATETIME(3) integer
DATETIME(4), DATETIME(5), DATETIME(6) integer
GEOMETRY Struct
LINESTRING Struct
POLYGON Struct
MULTIPOINT Struct
MULTILINESTRING Struct
MULTIPOLYGON Struct
GEOMETRYCOLLECTION Struct

PostgreSQL to Iceberg data type mapping

MySQL type Iceberg data type
BOOLEAN boolean
BIT(1) boolean
BIT( > 1) binary
BIT VARYING[(M)] binary
SMALLINT, SMALLSERIAL integer
INTEGER, SERIAL integer
BIGINT, BIGSERIAL, OID integer
REAL float
DOUBLE PRECISION float
CHAR[(M)] string
VARCHAR[(M)] string
CHARACTER[(M)] string
CHARACTER VARYING[(M)] string
TIMESTAMPTZ, TIMESTAMP WITH TIME ZONE string
TIMETZ, TIME WITH TIME ZONE string
INTERVAL [P] integer
INTERVAL [P] string
BYTEA binary or string
JSON, JSONB string
XML string
UUID string
POINT string
LTREE string
CITEXT string
INET string
INT4RANGE string
INT8RANGE string
NUMRANGE string
TSRANGE string
TSTZRANGE string
DATERANGE string
ENUM string
DATE integer
TIME(1), TIME(2), TIME(3) integer
TIME(4), TIME(5), TIME(6) integer
TIMESTAMP(1), TIMESTAMP(2), TIMESTAMP(3) integer
TIMESTAMP(4), TIMESTAMP(5), TIMESTAMP(6), TIMESTAMP integer
NUMERIC[(M[,D])] binary
DECIMAL[(M[,D])] binary
MONEY[(M[,D])] binary
INET string
CIDR string
MACADDR string
MACADDR8 string
GEOMETRY (planar) strut
GEOGRAPHY (spherical) strut