This page describes the Snowflake data types and the Anaplan Data Orchestrator data types they map to when you create a connection. The data type mapping is fixed.

Snowflake data typesData Orchestrator data types
DECIMAL,NUMERICstring
INT,INTEGER,BIGINT,SMALLINT,TINYINT,BYTEINTstring
BOOLEANboolean
FLOAT,FLOAT4,FLOAT8string
DOUBLE,DOUBLE PRECISION,REALstring
VARCHARstring
CHAR,CHARACTERstring
STRING,TEXTstring
BINARYstring
VARBINARYstring

DATE,DATETIME,TIMESTAMP,TIMESTAMP_LTZ,

TIMESTAMP_NTZ,TIMESTAMP_TZ

string
VARIANT,string
OBJECTstring
MAPstring
GEOGRAPHYstring
GEOMETRYstring
VECTORstring
TIME

Not supported

(If the Snowflake source contains a TIME data type, the connection is created successfully, but the data extract fails.)