Date Not Coming In As Date For One BQ Table ( even though its identical format to other tables )
I have a BQ table with a DATE field, it shows as a date field in the BigQuery table viewer. It is a legacy table.
When I import it into DataStudio, I have to force it to be a date ( it tries to be an int).
Then when I try to use it to create a timeseries it does not load ( I get garbage dates ).
I have the same date format column in another BG table, and it loads as date just fine. What gives?
If I have a BigQuery table telling me its a date column, shouldn't DataStudio load it as a date?
PS: I tried using standard sql views but DataStudio complained it was trying to use legacy sql to load a standard sql view, so that doesn't work.