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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BIGQUERY | int64 | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 64-bit integer |
| BIGQUERY | numeric | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Exact numeric with 38 digits of precision and 9 decimal digits |
| BIGQUERY | bignumeric | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Exact numeric with 76 digits of precision and 38 decimal digits |
| BIGQUERY | float64 | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 64-bit floating point |
| BIGQUERY | bool | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Boolean value |
| BIGQUERY | string | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Variable-length character string |
| BIGQUERY | bytes | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Variable-length binary data |
| BIGQUERY | date | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Calendar date (year, month, day) |
| BIGQUERY | datetime | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Date and time without time zone |
| BIGQUERY | time | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Time of day |
| BIGQUERY | timestamp | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Absolute point in time with microsecond precision |
| BIGQUERY | geography | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Geographic data (points, lines, polygons) |
| BIGQUERY | json | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | JSON data type |
| BIGQUERY | array | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Ordered list of zero or more elements |
| BIGQUERY | struct | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Container of ordered fields |
| BIGQUERY | interval | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Duration or amount of time |
| SQLITE | integer | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Signed integer value |
| SQLITE | real | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Floating point value |
| SQLITE | text | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Text string |
| SQLITE | blob | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Binary large object |
| SQLITE | numeric | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| DELTALAKE | tinyint | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 8-bit signed integer (-128 to 127) |
| DELTALAKE | smallint | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 16-bit signed integer |
| DELTALAKE | int | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 32-bit signed integer |
| DELTALAKE | bigint | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 64-bit signed integer |
| DELTALAKE | float | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 32-bit floating-point |
| DELTALAKE | double | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 64-bit floating-point |
| DELTALAKE | decimal | null | STRING | 0 | 0 | 1 | 1 | null | 10 | 0 | null | Arbitrary precision decimal |
| DELTALAKE | string | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Variable-length string |
| DELTALAKE | char | null | STRING | 0 | 1 | 0 | 0 | null | null | null | null | Fixed-length string |
| DELTALAKE | varchar | null | STRING | 0 | 1 | 0 | 0 | null | null | null | null | Variable-length string with max length |
| DELTALAKE | binary | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Binary data |
| DELTALAKE | boolean | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Boolean value |
| DELTALAKE | date | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Date without time |
| DELTALAKE | timestamp | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Timestamp with microsecond precision |
| DELTALAKE | timestamp_ntz | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Timestamp without timezone |
| DELTALAKE | array | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Array of elements |
| DELTALAKE | map | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Map of key-value pairs |
| DELTALAKE | struct | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Structured record |
| DELTALAKE | void | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Void/null type |
| DELTALAKE | interval | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Time interval |
| MYSQL | tinyint | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 1-byte integer |
| MYSQL | smallint | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 2-byte integer |
| MYSQL | mediumint | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 3-byte integer |
| MYSQL | int | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 4-byte integer |
| MYSQL | bigint | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 8-byte integer |
| MYSQL | decimal | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| MYSQL | float | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Single-precision floating point |
| MYSQL | double | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| MYSQL | varchar | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |