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.
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 |