Explore the different asset types available for the datasource.
-
Base connectivity
The default asset types supported for Snowflake are:
Host, Database, Schema, Table, Table Column, View, View Column (Geography, Geometry)
-
Advanced connectivity bundle
The asset types supported for Snowflake using advanced connectivity bundle are:
DB Association, DB Attribute, DB Calculated Attribute, DB Calculated Measure, DB Calculation View, DB Check Constraint, DB Condition, DB Filter, DB Foreign Key, DB Function, DB Index, DB Index Member, DB Input Parameter, DB Operation, DB Output Column, DB Parameter, DB Partition Column, DB Primary Key, DB Result Attribute, DB Sequence, DB Stage, DB Stored Procedure, DB Stream, DB Task, DB Temporary Table, DB Trigger, DB Type, DB Unique Constraint
Mapping
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 |