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 by default up to 16 MB.
NCLOBTEXTSupported by default up to 16 MB.
LONGTEXTSupported by default up to 16 MB.
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 RAWBINARYSupported by default up to 8 MB.
BLOBBINARYSupported by default up to 8 MB.
BOOLEANBOOLEAN
JSONVARIANTSupported by default up to 16 MB.
XMLTYPETEXTSupported by default up to 16 MB.

Note

For types with default size limits (8 MB / 16 MB) in this table, it is possible to raise these limits. For details, see Oversized values.

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.