Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to avoid unnecessary query invokations?

I have a query that fetches the full dataset and a bunch of queries that references this query and adds different filters.

When refreshing it will make the same fetch for all queries, both for the full data and all referenced queries.

 

Is it possible to make it so that it only makes the fetch for just the full data query and that this dataset is then used by the queries that references it, instead of making the same fetch for every single query?

 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
    You can right click on the table and refresh one table at a time.
    Appreciate your Kudos.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Let's say I have queries A and B. A has it's source an ODBC connection to Amazon Athena.
    B has as it's source a reference to A and then some additional filters.


    When refreshing, both A and B will each cause a fetch to AWS and get the same data set. I would rather only have A make the invokation and B would then "reuse" the dataset instead of making its own fetching of the data.

    Hope this makes it clearer.