Schema Mapper Compatibility Table

On This Page

Refer to the following table to know the compatible data types for a given Source field in Hevo.

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
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.


Revision History

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

Date Release Description of Change
Dec-20-2021 1.78 Added timestamptz to the compatible data types table.
Last updated on 22 Mar 2022