Dashboard loading from a cloud-based data warehouse cache
Dashboard loading from a cloud-based data warehouse cache, including determining that a result for a first query is stored in a cache of a cloud-based data warehouse; sending, in response to the result being stored in the cache, to the cloud-based data warehouse, a request for the result from the cache; and providing, based on the result for the first query, one or more dashboard visualizations.
1. A method of dashboard loading from a cloud-based data warehouse cache, the method comprising:
determining that a result for a first query is stored in a cache included within a cloud-based data warehouse;
based on an age associated with the result, sending, to the cloud-based data warehouse, a request to retrieve the result from the cache; and
providing, based on the result for the first query, one or more dashboard visualizations.
2. The method of claim 1 , further comprising updating the one or more dashboard visualizations based on the age associated with the result, and wherein determining that the result for the first query is stored in the cache of the cloud-based data warehouse comprises:
generating a digest for the first query, including applying a hash function to the query to generate, as the digest, a hash value; and
identifying, based on the digest, an entry in a data structure tracking a state of the cache of the cloud-based data warehouse.
3. The method of claim 2 , further comprising determining, based on the entry, a location in the cache of the result.
4. The method of claim 1 , further comprising:
based on an age associated with the result, querying the cloud-based data warehouse with the first query;
receiving, in response to the first query, another result for the first query; and
updating the one or more dashboard visualizations based on the other result for the first query.
5. The method of claim 1 , further comprising:
determining that a result for a second query is not stored in the cache of the cloud-based data warehouse;
querying the cloud-based data warehouse with the second query; and
receiving, in response to the second query, the result for the second query.
6. The method of claim 5 , further comprising storing an indication that the result for the second query is stored in the cache of the cloud-based data warehouse.
7. The method of claim 1 , further comprising:
determining that a result for a second query is stored in the cache of the cloud-based data warehouse and associated with an age exceeding a threshold;
querying the cloud-based data warehouse with the second query; and
receiving, in response to the second query, another result for the second query.
8. An apparatus for dashboard loading from a cloud-based data warehouse cache, the apparatus comprising a computer processor, a computer memory operatively coupled to the computer processor, the computer memory having disposed within it computer program instructions that, when executed by the computer processor, cause the apparatus to carry out the steps of:
determining that a result for a first query is stored in a cache included within a cloud-based data warehouse;
based on an age associated with the result, sending, to the cloud-based data warehouse, a request to retrieve the result from the cache; and
providing, based on the result for the first query, one or more dashboard visualizations.
9. The apparatus of claim 8 , wherein determining that the result for the first query is stored in the cache of the cloud-based data warehouse comprises:
generating a digest for the first query; and
identifying, based on the digest, an entry in a data structure tracking a state of the cache of the cloud-based data warehouse.
10. The apparatus of claim 9 , wherein the steps further comprise determining, based on the entry, a location in the cache of the result.
11. The apparatus of claim 8 , wherein the steps further comprise:
based on an age associated with the result, querying the cloud-based data warehouse with the first query;
receiving, in response to the first query, another result for the first query; and
updating the one or more dashboard visualizations based on the other result for the first query.
12. The apparatus of claim 8 , wherein the steps further comprise:
determining that a result for a second query is not stored in the cache of the cloud-based data warehouse;
querying the cloud-based data warehouse with the second query; and
receiving, in response to the second query, the result for the second query.
13. The apparatus of claim 12 , wherein the steps further comprise storing an indication that the result for the second query is stored in the cache of the cloud-based data warehouse.
14. The apparatus of claim 8 , wherein the steps further comprise:
determining that a result for a second query is stored in the cache of the cloud-based data warehouse and associated with an age exceeding a threshold;
querying the cloud-based data warehouse with the second query; and
receiving, in response to the second query, another result for the second query.
15. A computer program product for dashboard loading from a cloud-based data warehouse cache, the computer program product disposed upon a computer readable medium, the computer program product comprising computer program instructions that, when executed, cause a computer to carry out the steps of:
determining that a result for a first query is stored in a cache included within a cloud-based data warehouse;
based on an age associated with the result, sending, to the cloud-based data warehouse, a request to retrieve the result from the cache; and
providing, based on the result for the first query, one or more dashboard visualizations.
16. The computer program product of claim 15 , wherein determining that the result for the first query is stored in the cache of the cloud-based data warehouse comprises:
generating a digest for the first query; and
identifying, based on the digest, an entry in a data structure tracking a state of the cache of the cloud-based data warehouse.
17. The computer program product of claim 16 , wherein the steps further comprise determining, based on the entry, a location in the cache of the result.
18. The computer program product of claim 15 , wherein the steps further comprise:
based on an age associated with the result, querying the cloud-based data warehouse with the first query;
receiving, in response to the first query, another result for the first query; and
updating the one or more dashboard visualizations based on the other result for the first query.
19. The computer program product of claim 15 , wherein the steps further comprise:
determining that a result for a second query is not stored in the cache of the cloud-based data warehouse;
querying the cloud-based data warehouse with the second query; and
receiving, in response to the second query, the result for the second query.
20. The computer program product of claim 19 , wherein the steps further comprise storing an indication that the result for the second query is stored in the cache of the cloud-based data warehouse.