Openflow Connector for Oracle: Data mapping¶

Note

The connector is subject to the Snowflake Connector Terms.

This topic describes how Oracle data types are mapped to Snowflake data types when replicating data.

Oracle to Snowflake data type mapping¶

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

Oracle type	Snowflake type	Notes
NUMBER	NUMBER	If precision is undefined, mapped to NUMBER(38, 19). If precision or scale exceeds Snowflake limitations (precision > 38 or scale > 37), the value is stored as TEXT.
FLOAT	FLOAT
BINARY_FLOAT	FLOAT
BINARY_DOUBLE	FLOAT
CHAR	TEXT
VARCHAR2	TEXT
NCHAR	TEXT
NVARCHAR2	TEXT
CLOB	TEXT	Supported up to the maximum entry size in Snowflake (16 MB).
NCLOB	TEXT	Supported up to the maximum entry size in Snowflake (16 MB).
LONG	TEXT
DATE	TIMESTAMP_NTZ
TIMESTAMP	TIMESTAMP_NTZ
TIMESTAMP WITH TIME ZONE	TIMESTAMP_TZ
TIMESTAMP WITH LOCAL TIME ZONE	TIMESTAMP_LTZ
INTERVAL	TEXT
INTERVAL YEAR TO MONTH	TEXT
INTERVAL DAY TO SECOND	TEXT
RAW	BINARY
LONG RAW	BINARY
BLOB	BINARY	Supported up to the maximum entry size in Snowflake (16 MB).
BOOLEAN	BOOLEAN
JSON	VARIANT	Supported up to the maximum entry size in Snowflake (16 MB).
XMLTYPE	TEXT

Note

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