1 of 1 people found this helpful
Some datasource does not allow dateparse/makedate type of function.
If that's the case, only the way I know of is like this link. (Very trouble some though)
Just following up.
If you have further questions, please reply to this.
If you think problem is solved, please mark my answer as correct / helped to close the thread not from inbox but from originals post.
I ended up converting my BigQuery view to using the Standard SQL syntax and cast date as such:
CAST(CONCAT(SUBSTR(date,1,4),'-',SUBSTR(date,5,2),'-',SUBSTR(date,7,2)) AS DATE) AS Date,
This ended up being a more elegant solution for me but I can see your solution working for someone. I'll mark it as correct even though it was not the solution I ended up using.
Thank you for sharing!