Bigquery Native Query Date Syntax Incorrect

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.


  1. save as new question.

  2. Explore.

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

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


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

Hi @chad
It looks like you are seeing this issue: - upvote by clicking :+1: on the first post