Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
ASK INFAPreview
Please log in to access Bolo.
ASK INFAPreview
Teradata Source Data Type | Synapse Analytics Target Data Type |
|---|---|
array | varbinary(max) |
bigint | bigint |
blob | varbinary(max) |
byte( precision ), 1 <= p <= 7501 | binary( size ), 1 <= s <= 7501 |
byte( precision ), 8001 <= p <= 64000 | varbinary(max) |
byteint | smallint |
char( size ), 128004 <= s <= 256000 | nvarchar(max) |
char( size ), 4 <= s <= 128000 | char( size ), 4 <= s <= 32000 |
clob | varchar(max) |
date | date |
decimal(p,s), 1 <= p <= 38, 1 <= s <= 37 | decimal(p,s), 1 <= p <= 38, 1 <= s <= 37 |
float | float |
integer | int |
interval day( precision ) to hour, 1 <= p <= 4 | varchar( size ), 5 <= s <= 8 |
interval day( precision ) to minute, 1 <= p <= 4 | varchar( size ), 8 <= s <= 11 |
interval day( precision ) to second (s), 1 <= p <= 4, 0 <= s <= 6 | varchar( size ), 12 <= s <= 21 |
interval day( precision ), 1 <= p <= 4 | varchar( size ), 2 <= s <= 5 |
interval hour( precision ) to minute, 1 <= p <= 4 | varchar( size ), 5 <= s <= 8 |
interval hour( precision ) to second (s), 1 <= p <= 4, 0 <= s <= 6 | varchar( size ), 9 <= s <= 18 |
interval hour( precision ), 1 <= p <= 4 | varchar( size ), 2 <= s <= 5 |
interval minute( precision ) to second (s), 1 <= p <= 4, 0 <= s <= 6 | varchar( size ), 9 <= s <= 18 |
interval minute( precision ), 1 <= p <= 4 | varchar( size ), 2 <= s <= 5 |
interval month( precision ), 1 <= p <= 4 | varchar( size ), 2 <= s <= 5 |
interval second(p,s), 1 <= p <= 4, 0 <= s <= 6 | varchar( size ), 3 <= s <= 12 |
interval year( precision ) to month, 1 <= p <= 4 | varchar( size ), 5 <= s <= 8 |
interval year( precision ), 1 <= p <= 4 | varchar( size ), 2 <= s <= 5 |
json | varchar(max) |
mbr | varbinary(256) |
number(*,s), 0 <= s <= 37 | varchar(255) |
number(p,s), 1 <= p <= 38, 1 <= s <= 37 | decimal(p,s), 1 <= p <= 38, 1 <= s <= 37 |
numeric(p,s), 1 <= p <= 38, 1 <= s <= 37 | decimal(p,s), 1 <= p <= 38, 1 <= s <= 37 |
period(date) | varchar(28) |
period(time( precision ) with time zone), 0 <= p <= 6 | varchar( size ), 36 <= s <= 50 |
period(time( precision ) ), 0 <= p <= 6 | varchar( size ), 24 <= s <= 38 |
period(timestamp( precision ) with time zone), 0 <= p <= 6 | varchar( size ), 58 <= s <= 72 |
period(timestamp( precision ) ), 0 <= p <= 6 | varchar( size ), 46 <= s <= 60 |
smallint | smallint |
time( precision ) with time zone, 0 <= p <= 6 | datetimeoffset( precision ), 0 <= p <= 6 |
time( precision ), 0 <= p <= 6 | time( precision ), 0 <= p <= 6 |
timestamp( precision ) with time zone, 0 <= p <= 6 | datetimeoffset( precision ), 0 <= p <= 6 |
timestamp( precision ), 0 <= p <= 6 | datetime2( precision ), 0 <= p <= 6 |
varbyte( precision ), 1 <= p <= 64000 | varbinary( size ), 1 <= s <= max |
varchar( size ), 128004 <= s <= 256000 | nvarchar(max) |
varchar( size ), 4 <= s <= 126004 | char( size ), 4 <= s <= 32000 |
varray | varbinary(max) |
xml | varchar(max) |
