アプリケーション取り込みとレプリケーション

前へ次へ

SalesforceソースとSnowflakeターゲット

次の表は、SalesforceソースとSnowflakeターゲットを使用した

設定のデフォルトデータ型マッピングを示しています。

Salesforceソースデータ型	Snowflakeターゲットデータ型
anytype(`precision`), 1 <= p <= 255	char(`size`), 4 <= size <= 1020
base64 精度は、選択したbase64ボディサイズによって異なります。	char(`size`), 4 <= size <= 1020
boolean	boolean
combobox(`precision`), 1 <= p <= 255	char(`size`), 4 <= size <= 1020
currency(p,0), 1 <= p <= 18	integer
currency(p,s), 1 <= p <= 18, 1 <= s <= 17	number(p,s), 1 <= p <= 18, 1 <= s <= 17
date	date
datetime	datetime(3)
double(p,0), 1 <= p <= 18	integer
double(p,s), 1 <= p <= 18, 1 <= s <= 17	number(p,s), 1 <= p <= 18, 1 <= s <= 17
email(`precision`), 1 <= p <= 80	char(`size`), 4 <= size <= 320
encryptedstring(`precision`), 1 <= p <= 175	char(`size`), 4 <= size <= 700
id(`precision`), 1 <= p <= 18	char(`size`), 4 <= size <= 72
int	number(10)
long	number(19)
multipicklist(`precision`), 1 <= p <= 4099	char(`size`), 4 <= size <= 16396
percent(p,0), 1 <= p <= 18	integer
percent(p,s), 1 <= p <= 18, 1 <= s <= 17	number(p,s), 1 <= p <= 18, 1 <= s <= 17
phone(`precision`), 1 <= p <= 40	char(`size`), 4 <= size <= 160
picklist(`precision`), 1 <= p <= 255	char(`size`), 4 <= size <= 1020
reference(`precision`), 1 <= p <= 18	char(`size`), 4 <= size <= 72
string(`precision`), 1 <= p <= 100	char(`size`), 4 <= size <= 400
textarea(`precision`), 1 <= p <= 131072	char(`size`), 4 <= size <= 131072
time	time(3)
url(`precision`), 1 <= p <= 255	char(`size`), 4 <= size <= 1020