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