Data types across different database engines
On this page
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
Scroll horizontally to see the full table.
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 |