Oracleソースデータ型 | Snowflakeターゲットデータ型 |
|---|---|
binary_double | double |
binary_float | double |
blob | binary |
char(s byte), 1 <= size <= 2000 | varchar(4) |
char(s char), 1 <= size <= 2000 | varchar(4) |
clob | varchar |
date | timestamp_ntz(0) |
float(precision), 1 <= p <= 126 | varchar（255） |
integer | varchar（255） |
long raw | binary |
long（2147483648バイト） | varchar（65535） |
nchar(s char), 1 <= size <= 2000 | varchar(4) |
nclob | varchar |
number | char(255) |
number(p,s), 1<=p<=38, 0<=s<=37 | number |
number(p,s), 1<=p<=38, -37<=s<=-1 | number（合計長が38以下の場合） varchar（合計長が38を超える場合） |
nvarchar2(s char), 1 <= size <= 4000 | varchar(4) |
raw(size), 1 <= size <= 2000 | binary(size), 1 <= size <= 2000 |
rowid | varchar(18) |
timestamp(precision) with local time zone, 0 <= p <= 9 | timestampltz (precision), 0 <= p <= 9 |
timestamp(precision) with time zone, 0 <= p <= 9 | timestamp_tz(precision), 0 <= p <= 9 |
timestamp(precision), 1 <= p <= 9 | timestamp_ntz(precision), 1 <= p <= 9 |
varchar2(s byte), 1 <= size <= 4000 | varchar(size), 4 <= size <= 4000 |
varchar2(s char), 1 <= size <= 4000 | varchar(size), 4 <= size <= 16000 |
xml | varchar |