The date coming from Bigquery is not filterable at all

Get Help
1

Metabase updated to latest version. In BQ the date has the following format: 20210721, when using data model in Metabase I specifically set the type as date, and choose the format like Screenshot_42
and it successfully changes in the event_date column.
However when I'm trying to filter by date it's absolutely unresponsive, eg. when choosing previous N days, it doesn't output anything, same with the date range. Should I change something with the date in BigQuery maybe?

2

Hi @An_gr
Post "Diagnostic Info" from Admin > Troubleshooting.
As far as I know, no databases uses that date format unless it's a string or number column type. Which column format is it?
Metabase has the option to cast some columns as dates, which is done in Admin > Data Model > (db) > (table) > (column) :gear: > Casting

3

Yes tried the casting and it didn't work. Looks like the date format is string initially, have to fix it there.