Openflow Connector for Oracle: Data mapping

Note

This connector is subject to the Snowflake Connector Terms.

Note

The Openflow Connector for Oracle is also subject to additional terms of service beyond the standard connector terms of service. For more information, see the Openflow Connector for Oracle Addendum.

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 typeSnowflake typeNotes
NUMBERNUMBERIf 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.
FLOATFLOAT
BINARY_FLOATFLOAT
BINARY_DOUBLEFLOAT
CHARTEXT
VARCHAR2TEXT
NCHARTEXT
NVARCHAR2TEXT
CLOBTEXTSupported up to the maximum entry size in Snowflake (16 MB).
NCLOBTEXTSupported up to the maximum entry size in Snowflake (16 MB).
LONGTEXT
DATETIMESTAMP_NTZ
TIMESTAMPTIMESTAMP_NTZ
TIMESTAMP WITH TIME ZONETIMESTAMP_TZ
TIMESTAMP WITH LOCAL TIME ZONETIMESTAMP_LTZ
INTERVALTEXT
INTERVAL YEAR TO MONTHTEXT
INTERVAL DAY TO SECONDTEXT
RAWBINARY
LONG RAWBINARY
BLOBBINARYSupported up to the maximum entry size in Snowflake (16 MB).
BOOLEANBOOLEAN
JSONVARIANTSupported up to the maximum entry size in Snowflake (16 MB).
XMLTYPETEXT

Note

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

Next steps

Review Set up tasks for the Openflow Connector for Oracle to set up the connector.