Data types across different database engines
This article explains which data types in Adverity correspond to which data types in various database engines.
Introduction
The table below shows how various data types in Adverity correspond to data types in a range of database engines. Each row shows a data type in Adverity in the first column, and the various data types it corresponds to in the additional columns.
Data types in Adverity and different database engines
|
Adverity |
Google BigQuery |
Microsoft SQL | PostgreSQL | Redshift | Snowflake | MySQL |
|---|---|---|---|---|---|---|
|
String (with defined length) |
STRING |
NVARCHAR({length}) | VARCHAR({length}) | VARCHAR({length}) | VARCHAR({length}) | VARCHAR({length}) |
|
String (with no defined length) |
STRING |
NVARCHAR(MAX) | VARCHAR(200) | VARCHAR(200) | VARCHAR(200) | TEXT() |
| Long | INTEGER | BIGINT() | INT8(19) | INT8(19) | NUMBER(38,0) | BIGINT(20) |
| Float | FLOAT | NUMERIC(30,4) | NUMERIC(20,4) | NUMERIC(20,4) | FLOAT() | DECIMAL(20,4) |
| Date | DATE | DATE() | DATE() | DATE(13) | DATE() | DATE() |
| DateTime | DATETIME | DATETIME() | TIMESTAMP(29,6) | TIMESTAMP(29,6) | TIMESTAMP_NTZ(9) | DATETIME |
| Boolean | BOOLEAN | BIT() | BOOL() | BOOLEAN() | BOOLEAN() | TINYINT(1) |
| Percentage | FLOAT | FLOAT() | FLOAT8(17,17) | FLOAT8(17,17) | FLOAT() | FLOAT() |
| Currency | FLOAT | FLOAT() | FLOAT8(17,17) | FLOAT8(17,17) | FLOAT() | FLOAT() |
| JSON | STRING | VARCHAR(-1) | VARCHAR(200) | VARCHAR(200) | VARCHAR(200) | VARCHAR() |
| Formula | STRING | VARCHAR() | VARCHAR(255) | VARCHAR(200) | VARCHAR(200) | VARCHAR() |
| Duration | STRING | DATETIME() | INTERVAL() | TIMESTAMP(29,6) | TIMESTAMP_NTZ | DATETIME() |