Bigquery Native Query Date Syntax Incorrect

Bug reports
1

I am using metabase cloud on Chrome.

Steps to reproduce:

  1. Create a saved question on a Bigquery Database (At least one date/time field)

  2. Create a native query that references the saved question above using {{#id}} and select columns including at least one date field.

image

  1. save as new question.

  2. Explore.

  3. Try to group on the date field for Date, Week, Month, Quarter, or Year.

image
image1462×529 43.2 KB

  1. It gives an error. When I go to inspect the SQL It shows a peculiar cast.

image

The summary.source.createddate2 appears to be incorrect syntax for referencing dataset.column.

2

Hi @chad
It looks like you are seeing this issue:
https://github.com/metabase/metabase/issues/16389 - upvote by clicking :+1: on the first post