Explore the datatype to catalog datatype mappings available for the datasource.
Advanced connectivity bundle mapping
The mapping from Azure Synapse analytics server datatype to catalog datatype makes data management simpler and more organized when advanced connector bundle is used. For configuration details, refer Advanced connector bundle.
| Datatype | Catalog datatype |
|---|---|
| bigint | integer |
| bigint identity | integer |
| binary | blob |
| bit | boolean |
| char | string |
| date | date |
| datetime | datetime |
| datetime2 | datetime |
| datetimeoffset | datetime |
| decimal | decimal |
| decimal() identity | decimal |
| float | decimal |
| image | blob |
| int | integer |
| int identity | integer |
| money | decimal |
| nchar | string |
| ntext | string |
| numeric | decimal |
| numeric() identity | decimal |
| nvarchar | string |
| nvarchar(max) | string |
| real | decimal |
| smalldatetime | datetime |
| smallint | integer |
| smallint identity | integer |
| smallmoney | decimal |
| sql_variant | string |
| sysname | string |
| text | string |
| time | time |
| timestamp | blob |
| tinyint | integer |
| tinyint identity | integer |
| uniqueidentifier | string |
| varbinary | blob |
| varbinary(max) | blob |
| varchar | string |
| varchar(max) | string |
| xml | string |
| geography | GEOGRAPHY |
| geometry | GEOMETRY |
| hierarcyid | string |
| character varying | string |
| char_varying | string |
| dec | decimal |
| rowversion | datetime |
| NATIONAL CHAR | string |
| NATIONAL CHAR VARYING | string |
| NATIONAL CHARACTER | string |
| NATIONAL CHARACTER VARYING | string |
| NATIONAL TEXT | string |
| double precision | decimal |