Online
v0.9.0
Tables
dialect_data_types 367 records
| dialect | type_name | type_template | datada_type | is_default | supports_length | supports_precision | supports_scale | default_length | default_precision | default_scale | max_length | description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TERADATA | clob | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Character Large Object |
| TERADATA | byte | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Fixed-length binary data |
| TERADATA | varbyte | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Variable-length binary data |
| TERADATA | blob | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Binary Large Object |
| TERADATA | date | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| TERADATA | time | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| TERADATA | time with time zone | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Time with time zone |
| TERADATA | timestamp | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| TERADATA | timestamp with time zone | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Timestamp with time zone |
| TERADATA | interval year | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Interval year type |
| TERADATA | interval year to month | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Interval year to month |
| TERADATA | interval month | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| TERADATA | interval day | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| TERADATA | interval day to hour | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| TERADATA | interval day to minute | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| TERADATA | interval day to second | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| TERADATA | interval hour | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| TERADATA | interval hour to minute | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| TERADATA | interval hour to second | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| TERADATA | interval minute | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| TERADATA | interval minute to second | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| TERADATA | interval second | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| TERADATA | period(date) | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Temporal period of dates |
| TERADATA | period(time) | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Temporal period of times |
| TERADATA | period(timestamp) | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Temporal period of timestamps |
| TERADATA | json | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | JSON data type (Teradata 16.20+) |
| TERADATA | xml | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | XML data type |
| TERADATA | st_geometry | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Geospatial geometry type |
| TERADATA | array | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | ARRAY data type (Teradata 16.20+) |
| TERADATA | dataset storage format avro | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Avro format dataset |
| TERADATA | dataset storage format csv | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | CSV format dataset |
| SNOWFLAKE | number | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Fixed-point number |
| SNOWFLAKE | int | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| SNOWFLAKE | float | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| SNOWFLAKE | double | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| SNOWFLAKE | varchar | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| SNOWFLAKE | char | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| SNOWFLAKE | binary | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| SNOWFLAKE | boolean | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| SNOWFLAKE | date | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| SNOWFLAKE | time | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| SNOWFLAKE | datetime | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| SNOWFLAKE | timestamp_ltz | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Timestamp with local time zone |
| SNOWFLAKE | timestamp_ntz | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Timestamp without time zone |
| SNOWFLAKE | timestamp_tz | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Timestamp with time zone |
| SNOWFLAKE | variant | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Semi-structured data type |
| SNOWFLAKE | object | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Semi-structured object |
| SNOWFLAKE | array | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Semi-structured array |
| SNOWFLAKE | geography | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Geospatial data |
| SNOWFLAKE | geometry | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Geospatial data |