Supported Data Types by Data Warehouse Connection Type
Overview
When constructing your audience queries it's important to keep in mind which data types are supported by your data warehouse. Sticking to the data types listed below by data warehouse provider will ensure your audiences are created and data is successfully ingesting into Lytics.
Google BigQuery
Date & Time
DATE
DATETIME
TIME
TIMESTAMP
Logical
BOOL
Numeric
INT64
INT
SMALLINT
INTEGER
BIGINT
TINYINT
BYTEINT
FLOAT64
String & Binary
STRING
Amazon RedShift
Date & Time
DATE
TIMESTAMP
TIMESTAMPTZ
TIME
TIMETZ
Logical
BOOLEAN
BOOL
Numeric
SMALLINT
INT2
INTEGER
INT
INT4
BIGINT
INT8
REAL
FLOAT
FLOAT4
FLOAT8
DOUBLE PRECISION
String & Binary
CHAR
CHARACTER
NCHAR
BPCHAR
VARCHAR
NVARCHAR
TEXT
Snowflake
String & Binary
VARCHAR
CHAR
CHARACTER
STRING
TEXT
Logical
BOOLEAN
Date & Time
DATE
DATETIME
TIME
TIMESTAMP
TIMESTAMP_LTZ
TIMESTAMP_NTZ
TIMESTAMP_TZ
Numeric
INT
INTEGER
BIGINT
SMALLINT
TINYINT
BYTEINT
FLOAT
FLOAT4
FLOAT8
DOUBLE
DOUBLE PRECISION
REAL
Microsoft Azure
Date & Time
DATE
DATETIME
DATETIME2
DATETIMEOFFSET
SMALLDATETIME
TIME
Numeric
BIGINT
SMALLINT
INT
TINYINT
String & Binary
VARCHAR
CHAR
TEXT
NVARCHAR
NCHAR
NTEXT
BINARY
VARBINARY