BUG: Invalid syntax for dimension_group when creating view from table

This has been happening for at least a few months, but when creating a view from a table, the dimension_group for a date field will have SQL syntax in the form:

${TABLE}.CAST(${TABLE}.”DATE_FIELD” AS TIMESTAMP_NTZ)

It results in a syntax error because it’s prepending the table name to the CAST function.

We’re on the 22.14 version of Looker (cloud hosted) and we use Snowflake as our database.

0 0 72
0 REPLIES 0
Top Labels in this Space
Top Solution Authors