Data Type Mappings - CaO_Data

Kodda automatically maps data types from source to target systems.

To manage all of the possible combinations, each Data Store data type is mapped to a Standard Data Type (see Table 1).
Standard Data Types are then mapped back to the target Data Store data types (see Table 2).

The tables below show all of the standard transformations and supported types.

Table 1 (Data Store → Standard Data Type)

Delimited File

Data Store Type	Standard Data Type
Datetime	DATETIME
Timestamp	TIMESTAMP WITHOUT TIMEZONE
Decimal	DECIMAL
Integer	INTEGER
Long	BIGINT
String	NATIONAL CHARACTER VARYING
Date/time types	DATE

Parquet File

Data Store Type	Standard Data Type
int8	SMALLINT
int16	SMALLINT
int32	INTEGER
int64	BIGINT
uint8	SMALLINT
uint16	INTEGER
uint32	BIGINT
uint64	NUMERIC
halffloat	REAL
float	REAL
double	DOUBLE PRECISION
decimal128	DECIMAL
decimal256	CHARACTER VARYING
bool	BOOLEAN
string	NATIONAL CHARACTER VARYING
large_string	NATIONAL CHARACTER VARYING
dictionary	NATIONAL CHARACTER VARYING
fixed_size_binary	BINARY
binary	BINARY VARYING
large_binary	BINARY LARGE OBJECT
date32	DATE
time32	TIME WITHOUT TIMEZONE
time64	TIME WITHOUT TIMEZONE
timestamp	TIMESTAMP WITHOUT TIMEZONE
duration	BIGINT
(no type / unknown)	NATIONAL CHARACTER VARYING
list	CHARACTER VARYING LARGE OBJECT
large_list	CHARACTER VARYING LARGE OBJECT
fixed_size_list	CHARACTER VARYING LARGE OBJECT
map	CHARACTER VARYING LARGE OBJECT
struct	CHARACTER VARYING LARGE OBJECT

Google Analytics 4

Data Store Type	Standard Data Type
STRING	NATIONAL CHARACTER VARYING
DATE	DATE
METRIC_TYPE_UNSPECIFIED	NATIONAL CHARACTER VARYING
TYPE_INTEGER	INTEGER
TYPE_FLOAT	FLOAT
TYPE_SECONDS	FLOAT
TYPE_MILLISECONDS	FLOAT
TYPE_MINUTES	FLOAT
TYPE_HOURS	FLOAT
TYPE_STANDARD	FLOAT
TYPE_CURRENCY	FLOAT
TYPE_FEET	FLOAT
TYPE_MILES	FLOAT
TYPE_METERS	FLOAT
TYPE_KILOMETERS	FLOAT

Informix

Data Store Type	Standard Data Type
CHAR	CHARACTER
NCHAR	NATIONAL CHARACTER
VARCHAR	CHARACTER VARYING
NVARCHAR	NATIONAL CHARACTER VARYING
LVARCHAR	CHARACTER VARYING
TEXT	CHARACTER VARYING LARGE OBJECT
CLOB	CHARACTER VARYING LARGE OBJECT
BIGINT	BIGINT
INT8	BIGINT
INT	INTEGER
INTEGER	INTEGER
SMALLINT	SMALLINT
SERIAL	INTEGER
BIGSERIAL	BIGINT
SERIAL8	BIGINT
DECIMAL	DECIMAL
NUMERIC	NUMERIC
FLOAT	FLOAT
REAL	REAL
SMALLFLOAT	FLOAT
DOUBLE PRECISION	DOUBLE PRECISION
DATE	DATE
DATETIME	DATETIME
INTERVAL	CHARACTER VARYING
BYTE	BINARY VARYING
BLOB	BINARY LARGE OBJECT
BOOLEAN	BOOLEAN
MONEY	NUMERIC

Mail Chimp

Data Store Type	Standard Data Type
timestamp	DATETIME
string	NATIONAL CHARACTER VARYING
array	NATIONAL CHARACTER VARYING
integer	INTEGER
number	NUMERIC
boolean	BOOLEAN

MySQL

Data Store Type	Standard Data Type
binary	BINARY
varbinary	BINARY VARYING
boolean	BOOLEAN
date	DATE
datetime	TIMESTAMP WITHOUT TIMEZONE
timestamp	TIMESTAMP WITHOUT TIMEZONE
time	TIME WITHOUT TIMEZONE
year	SMALLINT
geometry	BINARY LARGE OBJECT
point	CHARACTER VARYING
linestring	CHARACTER VARYING
polygon	CHARACTER VARYING
multipoint	CHARACTER VARYING
multilinestring	CHARACTER VARYING
multipolygon	CHARACTER VARYING
geometrycollection	CHARACTER VARYING
tinyblob	BINARY LARGE OBJECT
blob	BINARY LARGE OBJECT
mediumblob	BINARY LARGE OBJECT
longblob	BINARY LARGE OBJECT
longtext	NATIONAL CHARACTER VARYING LARGE OBJECT
bit	BINARY
tinyint	SMALLINT
smallint	SMALLINT
mediumint	INTEGER
int	INTEGER
integer	INTEGER
decimal	DECIMAL
numeric	NUMERIC
bigint	BIGINT
float	FLOAT
double	DOUBLE PRECISION
double precision	DOUBLE PRECISION
real	FLOAT
bool	BOOLEAN
char	CHARACTER
tinytext	NATIONAL CHARACTER VARYING
text	NATIONAL CHARACTER VARYING
mediumtext	NATIONAL CHARACTER VARYING LARGE OBJECT
varchar	NATIONAL CHARACTER VARYING
enum	NATIONAL CHARACTER VARYING LARGE OBJECT
set	NATIONAL CHARACTER VARYING LARGE OBJECT
json	NATIONAL CHARACTER VARYING LARGE OBJECT

Oracle

Data Store Type	Standard Data Type
ANYDATA	CHARACTER VARYING
ANYDATASET	CHARACTER VARYING
ANYTYPE	CHARACTER VARYING
LONG RAW	BINARY LARGE OBJECT
RAW	BINARY VARYING
DATE	DATETIME
INTERVAL DAY TO SECOND	CHARACTER VARYING
INTERVAL YEAR TO MONTH	CHARACTER VARYING
TIMESTAMP	TIMESTAMP WITHOUT TIMEZONE
TIMESTAMP WITH LOCAL TIME ZONE	TIMESTAMP WITHOUT TIMEZONE
TIMESTAMP WITH TIME ZONE	TIMESTAMP WITHOUT TIMEZONE
BFILE	BINARY LARGE OBJECT
BLOB	BINARY LARGE OBJECT
CLOB	CHARACTER VARYING LARGE OBJECT
NCLOB	NATIONAL CHARACTER VARYING LARGE OBJECT
BINARY_DOUBLE	DOUBLE PRECISION
BINARY_FLOAT	REAL
NUMBER	NUMERIC
FLOAT	FLOAT
CHAR	CHARACTER
LONG	CHARACTER VARYING LARGE OBJECT
NCHAR	NATIONAL CHARACTER
NVARCHAR2	NATIONAL CHARACTER VARYING
VARCHAR2	CHARACTER VARYING
ROWID	CHARACTER VARYING
UROWID	CHARACTER VARYING
HTTPURIType	CHARACTER VARYING
URIType	CHARACTER VARYING
XDBURIType	CHARACTER VARYING
XMLType	XML

PostgreSQL

Data Store Type	Standard Data Type
bigint	BIGINT
bigserial	BIGINT
bit	CHARACTER
bit varying	CHARACTER VARYING
boolean	BOOLEAN
box	CHARACTER VARYING
bytea	BINARY LARGE OBJECT
char	NATIONAL CHARACTER
character	NATIONAL CHARACTER
character varying	NATIONAL CHARACTER VARYING
cidr	CHARACTER VARYING
circle	CHARACTER VARYING
date	DATE
double precision	DOUBLE PRECISION
inet	CHARACTER VARYING
integer	INTEGER
interval	CHARACTER VARYING
interval day to hour	CHARACTER VARYING
interval day to minute	CHARACTER VARYING
interval day to second	CHARACTER VARYING
interval hour to minute	CHARACTER VARYING
interval hour to second	CHARACTER VARYING
interval minute to second	CHARACTER VARYING
interval year to month	CHARACTER VARYING
json	NATIONAL CHARACTER VARYING LARGE OBJECT
jsonb	NATIONAL CHARACTER VARYING LARGE OBJECT
line	CHARACTER VARYING
lseg	CHARACTER VARYING
macaddr	CHARACTER VARYING
money	CHARACTER VARYING
numeric	NUMERIC
path	CHARACTER VARYING
pg_lsn	CHARACTER VARYING
point	CHARACTER VARYING
polygon	CHARACTER VARYING
real	REAL
serial	INTEGER
smallint	SMALLINT
smallserial	SMALLINT
text	NATIONAL CHARACTER VARYING
time with time zone	TIME WITH TIMEZONE
time without time zone	TIME WITHOUT TIMEZONE
timestamp with time zone	TIMESTAMP WITH TIMEZONE
timestamp without time zone	TIMESTAMP WITHOUT TIMEZONE
tsquery	NATIONAL CHARACTER VARYING
tsvector	NATIONAL CHARACTER VARYING
txid_snapshot	NATIONAL CHARACTER VARYING
unknown	NATIONAL CHARACTER VARYING
uuid	CHARACTER
xml	XML

Redshift

Data Store Type	Standard Data Type
bigint	BIGINT
int8	BIGINT
boolean	BOOLEAN
char	NATIONAL CHARACTER
character	NATIONAL CHARACTER
character varying	NATIONAL CHARACTER VARYING
bpchar	NATIONAL CHARACTER
nvarchar	NATIONAL CHARACTER VARYING
varchar	NATIONAL CHARACTER VARYING
date	DATE
double precision	DOUBLE PRECISION
float8	DOUBLE PRECISION
float	DOUBLE PRECISION
integer	INTEGER
int4	INTEGER
decimal	NUMERIC
numeric	NUMERIC
float4	REAL
real	REAL
smallint	SMALLINT
int2	SMALLINT
text	NATIONAL CHARACTER VARYING
timestamp with time zone	TIMESTAMP WITH TIMEZONE
timestamp without time zone	TIMESTAMP WITHOUT TIMEZONE
unknown	NATIONAL CHARACTER VARYING

Salesforce

Data Store Type	Standard Data Type
dateTime	TIMESTAMP WITHOUT TIMEZONE
string	NATIONAL CHARACTER VARYING
boolean	BOOLEAN
double	DOUBLE PRECISION
int	INTEGER
date	DATE
anyType	NATIONAL CHARACTER VARYING LARGE OBJECT
base64Binary	NATIONAL CHARACTER VARYING
time	TIME WITHOUT TIMEZONE
RecordTypesSupported	NATIONAL CHARACTER VARYING LARGE OBJECT
ID	NATIONAL CHARACTER VARYING

Snowflake

Data Store Type	Standard Data Type
NUMBER	NUMERIC
DECIMAL	DECIMAL
NUMERIC	NUMERIC
INT	INTEGER
INTEGER	INTEGER
BIGINT	BIGINT
SMALLINT	SMALLINT
BYTEINT	INTEGER
TINYINT	INTEGER
FLOAT	DOUBLE PRECISION
FLOAT4	DOUBLE PRECISION
FLOAT8	DOUBLE PRECISION
DOUBLE	DOUBLE PRECISION
DOUBLE PRECISION	DOUBLE PRECISION
REAL	DOUBLE PRECISION
VARCHAR	NATIONAL CHARACTER VARYING
CHAR	NATIONAL CHARACTER
CHARACTER	NATIONAL CHARACTER
STRING	NATIONAL CHARACTER VARYING
TEXT	NATIONAL CHARACTER VARYING
BINARY	BINARY
VARBINARY	BINARY VARYING
BOOLEAN	BOOLEAN
DATE	DATE
DATETIME	TIMESTAMP WITHOUT TIMEZONE
TIME	TIME WITHOUT TIMEZONE
TIMESTAMP_LTZ	TIMESTAMP WITH TIMEZONE
TIMESTAMP_NTZ	TIMESTAMP WITHOUT TIMEZONE
TIMESTAMP_TZ	TIMESTAMP WITH TIMEZONE
OBJECT	CHARACTER VARYING LARGE OBJECT
ARRAY	CHARACTER VARYING LARGE OBJECT
VARIANT	CHARACTER VARYING LARGE OBJECT

SQL Server

Data Store Type	Standard Data Type
binary	BINARY
image	BINARY
timestamp	BINARY
varbinary	BINARY VARYING
date	DATE
datetime	TIMESTAMP WITHOUT TIMEZONE
datetime2	TIMESTAMP WITHOUT TIMEZONE
datetimeoffset	TIMESTAMP WITH TIMEZONE
smalldatetime	DATETIME
time	TIME WITHOUT TIMEZONE
bigint	BIGINT
bit	BOOLEAN
decimal	DECIMAL
float	FLOAT
int	INTEGER
money	DECIMAL
numeric	NUMERIC
real	FLOAT
smallint	SMALLINT
smallmoney	DECIMAL
tinyint	NUMERIC
char	CHARACTER
nchar	NATIONAL CHARACTER
ntext	NATIONAL CHARACTER VARYING LARGE OBJECT
nvarchar	NATIONAL CHARACTER VARYING
text	CHARACTER VARYING LARGE OBJECT
uniqueidentifier	CHARACTER
varchar	CHARACTER VARYING
xml	XML
sql_variant	CHARACTER VARYING

Table 2 (Standard Data Type → Data Store)

Delimited File

Standard Data Type	Data Store Type
INTEGER	String
SMALLINT	String
BIGINT	String
NUMERIC	String
DECIMAL	String
REAL	String
DOUBLE PRECISION	String
FLOAT	String
BINARY	String
BINARY VARYING	String
BINARY LARGE OBJECT	String
BOOLEAN	String
CHARACTER	String
CHARACTER VARYING	String
CHARACTER VARYING LARGE OBJECT	String
NATIONAL CHARACTER	String
NATIONAL CHARACTER VARYING	String
NATIONAL CHARACTER VARYING LARGE OBJECT	String
DATE	String
TIME WITHOUT TIMEZONE	String
TIMESTAMP WITHOUT TIMEZONE	String
TIME WITH TIMEZONE	String
TIMESTAMP WITH TIMEZONE	String
INTERVAL DAY	String
INTERVAL YEAR	String
ARRAY	String
MULTISET	String
ROW	String
XML	String
DATETIME	String

Parquet File

Standard Data Type	Data Store Type
REAL	float
DOUBLE PRECISION	double
FLOAT	float
BINARY	fixed_size_binary
BINARY VARYING	binary
BINARY LARGE OBJECT	large_binary
BOOLEAN	bool
CHARACTER	string
CHARACTER VARYING	string
CHARACTER VARYING LARGE OBJECT	large_string
NATIONAL CHARACTER	string
NATIONAL CHARACTER VARYING	string
NATIONAL CHARACTER VARYING LARGE OBJECT	large_string
ARRAY	list
MULTISET	list
DATE	date32
TIME WITHOUT TIMEZONE	time64
TIMESTAMP WITHOUT TIMEZONE	timestamp
TIME WITH TIMEZONE	string
TIMESTAMP WITH TIMEZONE	timestamp
DATETIME	timestamp
INTEGER	int32
SMALLINT	int16
BIGINT	int64
NUMERIC	decimal128
DECIMAL	decimal128
INTERVAL DAY	string
INTERVAL YEAR	string
ROW	struct
XML	string

Informix

Standard Data Type	Data Store Type
INTEGER	INTEGER
SMALLINT	SMALLINT
BIGINT	BIGINT
NUMERIC	NUMERIC
DECIMAL	DECIMAL
REAL	REAL
DOUBLE PRECISION	DOUBLE PRECISION
FLOAT	FLOAT
BOOLEAN	BOOLEAN
CHARACTER	CHAR
CHARACTER VARYING	LVARCHAR
CHARACTER VARYING LARGE OBJECT	CLOB
NATIONAL CHARACTER	NCHAR
NATIONAL CHARACTER VARYING	LVARCHAR
NATIONAL CHARACTER VARYING LARGE OBJECT	CLOB
DATE	DATE
TIME WITHOUT TIMEZONE	DATETIME
TIMESTAMP WITHOUT TIMEZONE	DATETIME
TIME WITH TIMEZONE	VARCHAR
TIMESTAMP WITH TIMEZONE	VARCHAR
INTERVAL DAY	VARCHAR
INTERVAL YEAR	VARCHAR
ARRAY	TEXT
MULTISET	TEXT
ROW	TEXT
XML	TEXT
DATETIME	DATETIME

MySQL

Standard Data Type	Data Store Type
INTEGER	integer
SMALLINT	smallint
BIGINT	bigint
NUMERIC	numeric
DECIMAL	decimal
REAL	real
DOUBLE PRECISION	double precision
FLOAT	float
BINARY	binary
BINARY VARYING	varbinary
BINARY LARGE OBJECT	blob
BOOLEAN	boolean
CHARACTER	char
CHARACTER VARYING	varchar
CHARACTER VARYING LARGE OBJECT	text
NATIONAL CHARACTER	char
NATIONAL CHARACTER VARYING	varchar
NATIONAL CHARACTER VARYING LARGE OBJECT	text
DATE	date
TIME WITHOUT TIMEZONE	time
TIMESTAMP WITHOUT TIMEZONE	datetime
TIME WITH TIMEZONE	time
TIMESTAMP WITH TIMEZONE	datetime
INTERVAL DAY	varchar
INTERVAL YEAR	varchar
ARRAY	text
MULTISET	text
ROW	text
XML	text
DATETIME	datetime

Oracle

Standard Data Type	Data Store Type
INTEGER	NUMBER
SMALLINT	NUMBER
BIGINT	NUMBER
NUMERIC	NUMBER
DECIMAL	NUMBER
REAL	BINARY_DOUBLE
DOUBLE PRECISION	BINARY_DOUBLE
FLOAT	BINARY_DOUBLE
BINARY	BLOB
BINARY VARYING	BLOB
BINARY LARGE OBJECT	BLOB
BOOLEAN	NUMBER
CHARACTER	CHAR
CHARACTER VARYING	VARCHAR2
CHARACTER VARYING LARGE OBJECT	CLOB
NATIONAL CHARACTER	NCHAR
NATIONAL CHARACTER VARYING	NVARCHAR2
NATIONAL CHARACTER VARYING LARGE OBJECT	NCLOB
DATE	DATE
TIME WITHOUT TIMEZONE	VARCHAR2
TIMESTAMP WITHOUT TIMEZONE	TIMESTAMP
TIME WITH TIMEZONE	VARCHAR2
TIMESTAMP WITH TIMEZONE	TIMESTAMP WITH TIME ZONE
INTERVAL DAY	VARCHAR2
INTERVAL YEAR	VARCHAR2
ARRAY	VARCHAR2
MULTISET	VARCHAR2
ROW	VARCHAR2
XML	XMLType
DATETIME	DATE

PostgreSQL

Standard Data Type	Data Store Type
INTEGER	integer
SMALLINT	smallint
BIGINT	bigint
NUMERIC	numeric
DECIMAL	numeric
REAL	real
DOUBLE PRECISION	double precision
FLOAT	real
BINARY	bytea
BINARY VARYING	bytea
BINARY LARGE OBJECT	bytea
BOOLEAN	boolean
CHARACTER	character
CHARACTER VARYING	character varying
CHARACTER VARYING LARGE OBJECT	text
NATIONAL CHARACTER	character
NATIONAL CHARACTER VARYING	character varying
NATIONAL CHARACTER VARYING LARGE OBJECT	text
DATE	date
TIME WITHOUT TIMEZONE	time without time zone
TIMESTAMP WITHOUT TIMEZONE	timestamp without time zone
TIME WITH TIMEZONE	time with time zone
TIMESTAMP WITH TIMEZONE	timestamp with time zone
INTERVAL DAY	character varying
INTERVAL YEAR	character varying
ARRAY	text
MULTISET	text
ROW	text
XML	xml
DATETIME	timestamp without time zone

Redshift

Standard Data Type	Data Store Type
INTEGER	integer
SMALLINT	smallint
BIGINT	bigint
NUMERIC	decimal
DECIMAL	decimal
REAL	real
DOUBLE PRECISION	double precision
FLOAT	real
BINARY	varchar
BINARY VARYING	varchar
BINARY LARGE OBJECT	varchar
BOOLEAN	boolean
CHARACTER	char
CHARACTER VARYING	varchar
CHARACTER VARYING LARGE OBJECT	varchar
NATIONAL CHARACTER	varchar
NATIONAL CHARACTER VARYING	varchar
NATIONAL CHARACTER VARYING LARGE OBJECT	varchar
DATE	date
TIME WITHOUT TIMEZONE	varchar
TIMESTAMP WITHOUT TIMEZONE	timestamp without time zone
TIME WITH TIMEZONE	varchar
TIMESTAMP WITH TIMEZONE	timestamp with time zone
INTERVAL DAY	varchar
INTERVAL YEAR	varchar
ARRAY	text
MULTISET	text
ROW	text
XML	varchar
DATETIME	timestamp without time zone

Snowflake

Standard Data Type	Data Store Type
INTEGER	INT
SMALLINT	SMALLINT
BIGINT	BIGINT
NUMERIC	NUMERIC
DECIMAL	DECIMAL
REAL	DOUBLE
DOUBLE PRECISION	DOUBLE
FLOAT	DOUBLE
BINARY	VARCHAR
BINARY VARYING	VARCHAR
BINARY LARGE OBJECT	VARCHAR
BOOLEAN	BOOLEAN
CHARACTER	CHAR
CHARACTER VARYING	VARCHAR
CHARACTER VARYING LARGE OBJECT	VARCHAR
NATIONAL CHARACTER	CHAR
NATIONAL CHARACTER VARYING	VARCHAR
NATIONAL CHARACTER VARYING LARGE OBJECT	VARCHAR
DATE	DATE
TIME WITHOUT TIMEZONE	TIME
TIMESTAMP WITHOUT TIMEZONE	TIMESTAMP_NTZ
TIME WITH TIMEZONE	VARCHAR
TIMESTAMP WITH TIMEZONE	TIMESTAMP_TZ
INTERVAL DAY	VARCHAR
INTERVAL YEAR	VARCHAR
ARRAY	VARCHAR
MULTISET	VARCHAR
ROW	VARCHAR
XML	VARCHAR
DATETIME	TIMESTAMP_NTZ

SQL Server

Standard Data Type	Data Store Type
INTEGER	int
SMALLINT	smallint
BIGINT	bigint
NUMERIC	numeric
DECIMAL	decimal
REAL	real
DOUBLE PRECISION	float
FLOAT	real
BINARY	binary
BINARY VARYING	varbinary
BINARY LARGE OBJECT	varbinary
BOOLEAN	varchar
CHARACTER	char
CHARACTER VARYING	varchar
CHARACTER VARYING LARGE OBJECT	varchar
NATIONAL CHARACTER	nchar
NATIONAL CHARACTER VARYING	nvarchar
NATIONAL CHARACTER VARYING LARGE OBJECT	nvarchar
DATE	date
TIME WITHOUT TIMEZONE	time
TIMESTAMP WITHOUT TIMEZONE	datetime2
TIME WITH TIMEZONE	varchar
TIMESTAMP WITH TIMEZONE	datetimeoffset
INTERVAL DAY	varchar
INTERVAL YEAR	varchar
ARRAY	varchar
MULTISET	varchar
ROW	varchar
XML	xml
DATETIME	datetime2

​Table 1 (Data Store → Standard Data Type)

​Delimited File

​Parquet File

​Google Analytics 4

​Informix

​Mail Chimp

​MySQL

​Oracle

​PostgreSQL

​Redshift

​Salesforce

​Snowflake

​SQL Server

​Table 2 (Standard Data Type → Data Store)

​Delimited File

​Parquet File

​Informix

​MySQL

​Oracle

​PostgreSQL

​Redshift

​Snowflake

​SQL Server

Table 1 (Data Store → Standard Data Type)

Delimited File

Parquet File

Google Analytics 4

Informix

Mail Chimp

MySQL

Oracle

PostgreSQL

Redshift

Salesforce

Snowflake

SQL Server

Table 2 (Standard Data Type → Data Store)

Delimited File

Parquet File

Informix

MySQL

Oracle

PostgreSQL

Redshift

Snowflake

SQL Server