my Big Query use two queries first query_123 and second query_456 , i made something like this
select
a, b
from query_123
left join
query_456
where conditions.
Query 456 contains itself parameter which changes every time when we run Query 456. For example we need every time write previose date and current date.
i changed all on
select
a, b
from query_123
left join
cached_query_456
where conditions.
to save the last updated version of this query in cache to use it afterwards in Big Query
but have this error. Could you help me?