Some Postgres queries not working anymore (custom database source)
we're having issues with some of our queries not refreshing for a couple of days now. After some trial-error we found out that CAST datetime expression is not working anymore.
If we run the query as "SELECT CAST(created_at AS DATE) ...." then we get an unknown error and queries don't refresh.
But if we rewrite this to "SELECT created_at::DATE ..." it works ok.
We currently have a lot of queries written with "CAST" expression and it would be a lot of work to rewrite this. We also create queries with external tool which generates queries using CAST. Any idea why this is occuring now and if it can be fixed?