Data types across different database engines¶
This guide 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.
Data types in Adverity and different database engines¶
Adverity |
Google BigQuery |
Microsoft SQL |
PostgreSQL |
Redshift |
Snowflake |
MySQL |
Looker Studio |
|---|---|---|---|---|---|---|---|
String (with defined length) |
STRING |
NVARCHAR({length}) |
VARCHAR({length}) |
VARCHAR({length}) |
VARCHAR({length}) |
VARCHAR({length}) |
Text |
String (with no defined length) |
STRING |
NVARCHAR(MAX) |
VARCHAR(200) |
VARCHAR(200) |
VARCHAR(200) |
TEXT |
Text |
Long |
INTEGER |
BIGINT() |
INT8(19) |
INT8(19) |
NUMBER(38,0) |
BIGINT(20) |
Number |
Float |
FLOAT |
NUMERIC(30,4) |
NUMERIC(20,4) |
NUMERIC(20,4) |
FLOAT() |
DECIMAL(20,4) |
Number |
Date |
DATE |
DATE() |
DATE() |
DATE(13) |
DATE() |
DATE() |
Date |
DateTime |
DATETIME |
DATETIME() |
TIMESTAMP(29,6) |
TIMESTAMP(29,6) |
TIMESTAMP_NTZ(9) |
DATETIME |
Date & Time |
Boolean |
BOOLEAN |
BIT() |
BOOL() |
BOOLEAN() |
BOOLEAN() |
TINYINT(1) |
Boolean |
Percentage |
FLOAT |
FLOAT() |
FLOAT8(17,17) |
FLOAT8(17,17) |
FLOAT() |
FLOAT() |
Number |
Currency |
FLOAT |
FLOAT() |
FLOAT8(17,17) |
FLOAT8(17,17) |
FLOAT() |
FLOAT() |
Number |
JSON |
STRING |
VARCHAR(-1) |
VARCHAR(200) |
VARCHAR(200) |
VARIANT |
TEXT |
Text |
Formula |
STRING |
VARCHAR() |
VARCHAR(255) |
VARCHAR(200) |
VARCHAR(200) |
VARCHAR() |
Text |
Duration |
STRING |
DATETIME() |
INTERVAL() |
TIMESTAMP(29,6) |
TIMESTAMP_NTZ |
DATETIME() |
Text |