Recommendation on handling string type date columns

Get Help
1

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

2021-02-24T17:54:29.394000+00:00

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?

2

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:
https://www.metabase.com/docs/latest/administration-guide/03-metadata-editing.html#casting-to-a-specific-data-type

3

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?

4

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