📑Dialect Conversion Charts

Snowflake to Looker

Snowflake DialectLooker 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

Date

DATETIME

Datetime

TIMESTAMP

TIMESTAMP_TZ

TIMESTAMP_NTZ

TIMESTAMP_LTZ

Timestamp

Databricks to Looker

Databricks DialectLooker Dialect

TINYINT

SMALLINT

INT

BIGINT

DECIMAL

FLOAT

DOUBLE

DECIMAL

Number

STRING

MAP

ARRAY

STRUCT

String

BOOLEAN

Yesno

DATE

Datetime

TIMESTAMP

TIMESTAMP_NTZ

Timestamp

Spark to Looker

Spark DialectLooker Dialect

BYTE SHORT INTEGER LONG FLOAT DOUBLE DECIMAL

Number

STRING VARCHAR CHAR

String

BOOLEAN

Yesno

TIMESTAMP

timestamp

Date

Datetime

Presto to Looker

Presto DialectLooker Dialect

TINYINT SMALLINT INTEGER BIGINT REAL DOUBLE DECIMAL

Number

VARCHAR CHART VARBINARY JSON MAP ARRAY ROW UUID

String

BOOLEAN

Yesno

DATE

Datetime

TIME TIMESTAMP

Timestamp

Last updated