Azure Synapse Pathway 从源系统（例如 IBM Netezza、Microsoft SQL Server 和 Snowflake）将 SQL 代码转译为与 Azure Synapse SQL 兼容的 T-SQL 代码。 Synapse Pathway 利用抽象语法树 (AST) 模型将源数据类型映射到支持的类型。
下面的链接集显示了每个受支持的源系统的源和目标数据类型映射。
| IBM Netezza 数据类型 | Azure Synapse SQL 数据类型 |
|---|---|
| array | 不支持 |
| bigint | bigint |
| 二进制大型对象 [ ( n [ K | M | G ] ) ] | nvarchar [ ( n | max ) ] |
| blob [ ( n [ K | M | G ] ) ] | nvarchar [ ( n | max ) ] |
| byte [ ( n ) ] | binary [ ( n ) ] | varbinary(max) |
| byteint | smallint |
| char varying [ ( n ) ] | varchar [ ( n | max) ] |
| character varying [ ( n ) ] | varchar [ ( n | max) ] |
| char [ ( n ) ] | char [ ( n ) ] | varchar(max) |
| 字符 [ ( n ) ] | char [ ( n ) ] | varchar(max) |
| character large object [ ( n [ K | M | G ] ) ] | varchar [ ( n | max ) |
| clob [ ( n [ K | M | G ] ) ] | varchar [ ( n | max ) |
| dataset | 不支持 |
| date | date |
| dec [ ( p [ , s] ) ] | decimal [ ( p [, s] ) ] |
| decimal [ ( p [ , s] ) ] | decimal [ ( p [, s] ) ] |
| double precision | float(53) |
| float [ ( n ) ] | float [ ( n ) ] |
| graphic [ ( n ) ] | nchar [ ( n ) ] | varchar(max) |
| interval | 不支持 |
| json [ ( n ) ] | nvarchar [ ( n | max) ] |
| long varchar | nvarchar(max) |
| long vargraphic | nvarchar(max) |
| mbb | 不支持 |
| mbr | 不支持 |
| number [ ( ( p | *) [ , s ] ) ] | numeric [ ( p [, s] ) ] |
| numeric [ ( p [, s] ) ] | numeric [ ( p [, s] ) ] |
| period | 不支持 |
| real | real |
| smallint | smallint |
| st_geometry | 不支持 |
| time | time |
| time with time zone | datetimeoffset |
| timestamp | datetime2 |
| timestamp with time zone | datetimeoffset |
| varbyte | varbinary [ ( n | max ) ] |
| varchar [ ( n ) ] | varchar [ ( n ) ] |
| vargraphic [ ( n ) ] | nvarchar [ ( n | max ) ] |
| varray | 不支持 |
| xml | 不支持 |
| xmltype | 不支持 |