Data Type Mapping Generic Connectors Source Data Type Destination Data Type Notes INTEGER BIGINT NUMBER DOUBLE PRECISION STRING VARCHAR DATETIME TIMESTAMP WITHOUT TIMEZONE BOOLEAN BOOLEAN ARRAY VARCHAR OBJECT VARCHAR *Others VARCHAR MySQL CDC Source Data Type Destination Data Type Notes BIGINT BIGINT BIGINT UNSIGNED NUMERIC SMALLINT SMALLINT SMALLINT UNSIGNED INTEGER TINYINT SMALLINT INT INTEGER MEDIUMINT INTEGER YEAR INTEGER INT UNSIGNED BIGINT MEDIUMINT UNSIGNED BIGINT CHARACTER VARCHAR VARCHAR VARCHAR DATE DATE DATETIME TIMESTAMP WITHOUT TIMEZONE TIMESTAMP TIMESTAMP WITHOUT TIMEZONE TIME TIME WITH TIMEZONE DOUBLE DOUBLE PRECISION DECIMAL NUMERIC FLOAT REAL TEXT VARCHAR MEDIUMTEXT VARCHAR TINYTEXT VARCHAR LONGTEXT VARCHAR ENUM VARCHAR SET VARCHAR BINARY VARCHAR VARBINARY VARCHAR BIT BIGINT GEOMETRY GEOMETRY GEOMETRYCOLLECTION GEOMETRY MULTIPOINT GEOMETRY LINESTRING GEOMETRY MULTIPOLYGON GEOMETRY POINT GEOMETRY POLYGON GEOMETRY MULTILINESTRING GEOMETRY BLOB VARCHAR TINYBLOB VARCHAR MEDIUMBLOB VARCHAR LONGBLOB VARCHAR *Others VARCHAR PostgreSQL CDC Source Data Type Destination Data Type Notes BIGINT BIGINT BIGSERIAL BIGINT BOOLEAN BOOLEAN CHARACTER CHARACTER VARCHAR VARCHAR TEXT VARCHAR MONEY VARCHAR USER DEFINED VARCHAR DATE DATE DOUBLE PRECISION DOUBLE PRECISION INTEGER INTEGER SERIAL INTEGER NUMERIC NUMERIC REAL REAL SMALLINT SMALLINT SMALLSERIAL SMALLINT TIME TIME WITHOUT TIMEZONE TIME WITHOUT TIMEZONE TIME WITHOUT TIMEZONE TIMESTAMP TIMESTAMP WITHOUT TIMEZONE TIMESTAMP WITH TIMEZONE TIMESTAMP WITH TIMEZONE TIMESTAMP WITHOUT TIMEZONE TIMESTAMP WITHOUT TIMEZONE JSON VARCHAR JSONB VARCHAR ARRAY VARCHAR BIT VARYING VARCHAR BIT BIGINT *Others VARCHAR SQL Server CDC Source Data Type Destination Data Type Notes BIGINT BIGINT BIT BOOLEAN CHAR CHARACTER VARCHAR VARCHAR DATE DATE FLOAT DOUBLE PRECISION INT INTEGER NUMERIC NUMERIC DECIMAL NUMERIC REAL REAL SMALLINT SMALLINT TIME TIME WITHOUT TIMEZONE *Others VARCHAR Salesforce CDC Source Data Type Destination Data Type Notes ID VARCHAR REFERENCE VARCHAR EMAIL VARCHAR PHONE VARCHAR PICKLIST VARCHAR STRING VARCHAR TEXTAREA VARCHAR ADDRESS VARCHAR URL VARCHAR COMBOBOX VARCHAR DATETIME TIMESTAMP WITH TIMEZONE DATE DATE DOUBLE DOUBLE PRECISION PERCENT NUMERIC CURRENCY NUMERIC *Others VARCHAR Salesforce V2 Source Data Type Destination Data Type Notes address VARCHAR / SUPER Only if JSON is selected as S3 File Format anyType VARCHAR / SUPER Only if JSON is selected as S3 File Format base64 VARCHAR boolean BOOLEAN byte VARCHAR calculated VARCHAR combobox VARCHAR currency NUMERIC datacategorygroupreference VARCHAR date DATE datetime TIMESTAMP_WITH_TIMEZONE double DOUBLE_PRECISION email VARCHAR encryptedstring VARCHAR id VARCHAR int INTEGER json VARCHAR / SUPER Only if JSON is selected as S3 File Format location VARCHAR / SUPER Only if JSON is selected as S3 File Format long BIGINT masterrecord VARCHAR multipicklist VARCHAR percent NUMERIC phone VARCHAR picklist VARCHAR reference VARCHAR string VARCHAR textarea VARCHAR time TIME_WITHOUT_TIMEZONE url VARCHAR File Storage Taps (S3 Source) Source Data Type Destination Data Type Notes STRING VARCHAR default value BOOLEAN BOOLEAN NUMBER DOUBLE_PRECISION INTEGER INTEGER ARRAY VARCHAR Inserted as truncated blob OBJECT VARCHAR Inserted as truncated blob BIGINT BIGINT DATE TIMESTAMP_WITHOUT_TIMEZONE DATETIME TIMESTAMP_WITH_TIMEZONE