Dialect Conversion Charts

Below is a list of warehouse data types and how Euno syncs these specific types to Looker. As certain warehouses have unique data types that do not have an equivalent Looker data type, Euno syncs these columns as strings, which can then be overridden in Looker.

Snowflake to Looker

Snowflake Dialect	Looker Dialect
NUMBER DECIMAL NUMERIC INT INTEGER BIGINT SMALLINT FLOAT FLOAT4 FLOAT8 DOUBLE DOUBLE PRECISION REAL	Number
VARCHAR CHAR CHARACTER STRING TEXT BINARY VARBINARY TIME VARIANT OBJECT ARRAY GEOGRAPHY	String
BOOLEAN	Yesno
DATE DATETIME TIMESTAMP TIMESTAMP_TZ TIMESTAMP_NTZ TIMESTAMP_LTZ	Time type Dimension Group

Databricks to Looker

Databricks Dialect	Looker Dialect
TINYINT SMALLINT INT BIGINT DECIMAL FLOAT DOUBLE DECIMAL	Number
STRING MAP ARRAY STRUCT	String
BOOLEAN	Yesno
DATE TIMESTAMP TIMESTAMP_NTZ	Time type Dimension Group

Spark to Looker

Spark Dialect	Looker Dialect
BYTE SHORT INTEGER LONG FLOAT DOUBLE DECIMAL	Number
STRING VARCHAR CHAR	String
BOOLEAN	Yesno
DATE TIMESTAMP	Time type Dimension Group

Presto to Looker

Presto Dialect	Looker Dialect
TINYINT SMALLINT INTEGER BIGINT REAL DOUBLE DECIMAL	Number
VARCHAR CHART VARBINARY JSON MAP ARRAY ROW UUID	String
BOOLEAN	Yesno
DATE TIME TIMESTAMP	Time type Dimension Group

Bigquery to Looker

Bigquery Dialect	Looker Dialect
INT64 INTEGER FLOAT FLOAT64 NUMERIC BIGNUMERIC	Number
STRING TIME ARRAY GEOGRAPHY BYTES	String
BOOLEAN	Yesno
TIMESTAMP DATETIME DATE	Time type Dimension Group