Error running query: No cached result available for query_456

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?

A post was merged into an existing topic: How to build 1 Query which contains query to 1DataSource and with result from first query need to be filtered second Query from 2 DataSoursc