Openflow Connector for PostgreSQL: Data mapping

Note

This connector is subject to the Snowflake Connector Terms.

This topic describes how PostgreSQL data types are mapped to Snowflake data types.

PostgreSQL to Snowflake data type mapping

The following table shows how PostgreSQL data types are mapped to Snowflake data types when replicating data.

PostgreSQL typeSnowflake typeNotes
SMALLINT / INT2INT
INTEGER / INT / INT4INT
BIGINT / INT8INT
SMALLSERIAL / SERIAL2INT
SERIAL / SERIAL4INT
BIGSERIAL / SERIAL8INT
NUMERIC / DECIMALNUMBERScale and precision are preserved within Snowflake limitations. Negative scale is converted to scale 0 with adjusted precision.
REAL / FLOAT4FLOAT
DOUBLE PRECISION / FLOAT8FLOAT
MONEYFLOAT
BOOLEAN / BOOLBOOLEAN
CHARACTER / CHAR / BPCHARTEXT
CHARACTER VARYING / VARCHARTEXT
TEXTTEXT
BYTEABINARYSupported up to the maximum entry size in Snowflake (16 MB).
DATEDATE
TIME / TIME WITHOUT TIME ZONETIME
TIME WITH TIME ZONE / TIMETZTIMESTAMP_TZ
TIMESTAMP / TIMESTAMP WITHOUT TIME ZONETIMESTAMP_NTZ
TIMESTAMP WITH TIME ZONE / TIMESTAMPTZTIMESTAMP_LTZ
INTERVALTEXT
JSONVARIANTSupported up to the maximum entry size in Snowflake (16 MB).
JSONBVARIANTSupported up to the maximum entry size in Snowflake (16 MB).
UUIDTEXT
XMLTEXT
BITTEXT
BIT VARYING / VARBITTEXT
POINTTEXT
LINETEXT
LSEGTEXT
BOXTEXT
PATHTEXT
POLYGONTEXT
CIRCLETEXT
CIDRTEXT
INETTEXT
MACADDRTEXT
MACADDR8TEXT
TSVECTORTEXT
TSQUERYTEXT
PG_LSNTEXT

Note

Any PostgreSQL data types not listed in this table are mapped to TEXT by default.