Data Types

This section describes the implementation and limitations for different source column data types in the target technologies supported by Yotilla.

Exasol data types

Exasol data type Aliases Yotilla generic data type
boolean bool BOOLEAN
char character, nchar FIXED_CHARACTER
date   DATE
decimal bigint, dec, int, integer, number, numeric, shortint, smallint, tinyint NUMERIC
double precision double, float, number, real FLOAT
geometry   GEOMETRY
hashtype   HASHTYPE
interval day to second   INTERVAL
interval year to month   INTERVAL
timestamp   DATETIME
timestamp with local time zone   DATETIME
varchar character large object, character varying, clob, long varchar, nvarchar, nvarchar2, varchar2 CHARACTER

Snowflake data types

Snowflake data type Aliases Yotilla generic data type
number

numeric, decimal,dec

The following data types are synonymous with number, except that precision and scale cannot be specified:

int, integer, bigint, smallint, tinyint, byteint

 numeric
float double, double precision, real float
float4   float
float8   float
varchar

string, text, nvarchar, nvarchar2, char varying, nchar varying

The following data types are synonymous with varchar, except that default length is varchar(1):

char, character, nchar

 character
binary varbinary BINARY
boolean   BOOLEAN
date   date
time   time
timestamp_ltz timestampltz, timestamp with local time zone datetime
timestamp_ntz datetime, timestamp, timestampntz, timestamp without time zone datetime
timestamp_tz timestamptz, timestamp with time zone datetime
variant   variant
object   object
array   array
geography   geography
geometry   geometry

Redshift data types

Redshift data type Aliases Yotilla generic data type

boolean

bool

BOOLEAN

char

character, nchar, bpchar

FIXED_CHARACTER

date

 

DATE

decimal

numeric

NUMERIC

geometry

 

GEOMETRY

smallint

int2

NUMERIC

time

time without time zone

TIME

timetz

time with time zone

TIME

timestamp

timestamp without time zone

DATETIME

timestamptz

timestamp with time zone

DATETIME

varbyte

varbinary, binary varying

BINARY

varchar

character varying, nvarchar, text

CHARACTER