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?
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
@moqca Well, it's not supported, so you would have to create a View on BigQuery, which does the conversion.