Explore the different datatype to catalog datatype mappings available for the datasource.
The tables lists the mapping from datatype to catalog datatype using advance connectivity bundle, making data management simpler and more organized. For configuration details, refer Advanced connectivity bundle.
| Datatype | Catalog datatype |
|---|---|
| DB Type | Catalog Type |
| array | string |
| bigint | integer |
| binary | blob |
| boolean | boolean |
| byteint | integer |
| char | string |
| character | string |
| date | date |
| datetime | datetime |
| decimal | decimal |
| double | double |
| double precision | double |
| float | double |
| float4 | double |
| float8 | double |
| geography | GEOGRAPHY |
| int | integer |
| integer | integer |
| number | decimal |
| numeric | decimal |
| object | string |
| real | decimal |
| smallint | integer |
| string | string |
| text | string |
| time | time |
| timestamp | datetime |
| timestamp_ltz | datetime |
| timestamp_ntz | datetime |
| timestamp_tz | datetime |
| tinyint | integer |
| varbinary | blob |
| varchar | string |
| variant | string |