|
Informix Source Datatype |
Snowflake Target Datatype |
|---|---|
|
char varying(p) |
Varchar(p) |
|
char(p) |
Varchar(p) |
|
character |
Varchar(1) |
|
date |
Date |
|
DATETIME DAY TO SECOND |
Timestamp_ntz(9) |
|
DATETIME HOUR TO SECOND |
Timestamp_ntz(8) |
|
DATETIME MONTH TO DAY |
Timestamp_ntz(5) |
|
DATETIME MONTH TO SECOND |
Timestamp_ntz(9) |
|
DATETIME YEAR TO DAY |
Timestamp_ntz(9) |
|
DATETIME YEAR TO FRACTION |
Timestamp_ntz(9) |
|
DATETIME YEAR TO FRACTION (3) |
Timestamp_ntz(9) |
|
DATETIME YEAR TO FRACTION (5) |
Timestamp_ntz(9) |
|
DATETIME YEAR TO MINUTE |
Timestamp_ntz(9) |
|
DATETIME YEAR TO MONTH |
Timestamp_ntz(7) |
|
DATETIME YEAR TO SECOND |
Timestamp_ntz(9) |
|
decimal |
Number(16,0) |
|
decimal(p,s) |
Number(p,s) |
|
double precision |
Float |
|
float |
Float |
|
float (p) |
Float |
|
integer |
Number(38,0) |
|
INTERVAL DAY TO DAY |
varchar(2) |
|
INTERVAL DAY(9) TO FRACTION(5) |
Varchar(24) |
|
INTERVAL HOUR TO SECOND |
Time(9) |
|
INTERVAL YEAR(3) TO MONTH |
varchar(6) |
|
INTERVAL YEAR(9) TO MONTH |
varchar(12) |
|
money |
Number(16,2) |
|
money(p,s) |
Number(p,s) |
|
nchar |
Varchar(1) |
|
nchar(p) |
Varchar(p) |
|
numeric |
Number(16,0) |
|
numeric(p,s) |
Number(p,s) |
|
nvarchar |
Varchar(1) |
|
nvarchar(2) |
Varchar(2) |
|
real |
Float |
|
serial |
Number(38,0) |
|
smallfloat |
Float |
|
smallint |
Number(38,0) |
|
varchar |
Varchar(1) |
|
varchar(p) |
Varchar(p) |
The following table shows the Informix source datatypes that are available to map to a varchar target column in a table you create manually on the Snowflake target. If you create the varchar with no precision, by default the size will be 16777216. If you create a fixed-length varchar datatype, ensure this target definition is large enough to accommodate the data sent from the source column.
|
Informix Source Datatype |
Snowflake Target Varchar |
|---|---|
|
Date |
varchar |
|
Datetime |
varchar |
|
Decimal |
varchar |
|
Double |
varchar |
|
Float |
varchar |
|
Integer |
varchar |
|
Numeric |
varchar |
|
Real |
varchar |
|
SmallFloat |
varchar |
|
Smallint |
varchar |