Schema Mapper Compatibility Table

Last updated on Dec 19, 2022

Source Data Type	Destination Data Type
array	array, varchar
bool	tiny int, bool, varchar
bytes	bytes, varchar
date	date, timestamp, varchar
decimal	decimal, varchar
float	float, decimal, varchar
geography	geometry, geography, json
geometry	geometry, geography, json
int	int, long, real, float, decimal, varchar
json	json, varchar
long	long, real, float, decimal, varchar
real	real, float, decimal, varchar
small int	small int, int, long, real, float, decimal, varchar
struct	struct, varchar
time	timestamp, varchar
timestamp	timestamp, varchar
timestamptz	timestamptz, timestamp, varchar
tiny int	int, small int, int, long, real, float, decimal, varchar
varchar	bytes, varchar

Note:

From Release 1.76 onwards, Hevo supports Auto Mapping of the timestamptz Source data type to the timestamptz Destination data type for new Pipelines created with PostgreSQL as the Source and Amazon Redshift as the Destination.
From Release 2.04 onwards, Hevo supports the ingestion and loading of the geography and geometry data types for new Pipelines created with MySQL or PostgreSQL as a Source and Snowflake, Google BigQuery, PostgreSQL, SQL Server or MySQL as the Destination. You cannot set fields with these data types as primary keys. You need to contact Hevo Support if you want to enable this feature for the PostgreSQL Destination.

Revision History

Refer to the following table for the list of key updates made to this page:

Date	Release	Description of Change
Dec-19-2022	2.04	Updated the table to include the geometry and geography data types.
Dec-20-2021	1.78	Added timestamptz to the compatible data types table.