Recommendation on handling string type date columns

I have a string type column in the following format which I want to use as a date column:


I want to be able to use this column in metabase to group by, filter, etc.

What woud be the best way of getting this to work?

Hi @moqca
You can use the column as-is, but only as a string. But if you want to use it as a timeseries, then you'll need to convert the column:

Thank you! that was helpful.
When doing that dashboards don't show anything, and looking at logs I get the following:

Driver :bigquery does not support :Coercion/ISO 8601->DateTime

Any ideas?

@moqca Well, it's not supported, so you would have to create a View on BigQuery, which does the conversion.