Dashboard loading using a filtering query from a cloud-based data warehouse cache
Dashboard loading using a filtering query from a cloud-based data warehouse cache, including determining that a filtered result for a first filtering query is stored in a cache of a cloud-based data warehouse; sending, in response to the filtered result being stored in the cache, to the cloud-based data warehouse, a request for the filtered result from the cache; and providing, based on the filtered result for the first filtering query, one or more dashboard visualizations.
1 . A method of dashboard loading using a filtering query from a cloud-based data warehouse cache, the method comprising:
determining, by a dashboard module within a data access computing system separate from a cloud-based data warehouse, that a filtered result for a filtering query is stored in a cache of the cloud-based data warehouse, including:
generating a digest for the filtering query based on a digest function applied to the filtering query; and
identifying, based on the digest, an entry in a data structure stored in the data access computing system, wherein the data structure tracks a state of the cache of the cloud-based data warehouse;
sending, in response to the filtered result being stored in the cache, to the cloud-based data warehouse, a request for the filtered result from the cache; and
providing, based on the filtered result for the filtering query, one or more dashboard visualizations.
2 . The method of claim 1 , wherein the entry in the data structure includes a timestamp, generated by the dashboard module at a time the entry was created, for the filtered result for the filtering query indicative of when the filtered result was produced and stored in the cache.
3 . The method of claim 2 , further comprising determining, based on the entry, a location in the cache of the filtered result.
4 . The method of claim 1 , further comprising:
determining that an age associated with the filtered result exceeds a threshold;
querying the cloud-based data warehouse with the filtering query;
receiving, in response to the filtering query, a next filtered result for the filtering query; and
updating the one or more dashboard visualizations based on the next filtered result for the filtering query.
5 . The method of claim 1 , further comprising:
determining that a next filtered result for a next filtering query is not stored in the cache of the cloud-based data warehouse;
querying the cloud-based data warehouse with the next filtering query; and
receiving, in response to the next filtering query, the next filtered result for the next filtering query.
6 . The method of claim 5 , further comprising storing an indication that the next filtered result for the next filtering query is stored in the cache of the cloud-based data warehouse.
7 . The method of claim 1 , further comprising:
determining that a next filtered result for a next filtering 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 next filtering query; and
receiving, in response to the next filtering query, the next filtered result for the next filtering query.
8 . The method of claim 1 , wherein the filtering query comprises a request for rows matching a criterion, and wherein the one or more dashboard visualizations comprises a dashboard visualization of the rows matching the criterion.
9 . The method of claim 1 , wherein the filtering query comprises a request for a frequency distribution, and wherein the one or more dashboard visualizations comprise a histogram distribution of values.
10 . An apparatus for dashboard loading using a filtering query 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:
determine, by a dashboard module within a data access computing system separate from a cloud-based data warehouse, that a filtered result for a filtering query is stored in a cache of the cloud-based data warehouse, including:
generating a digest for the filtering query based on a digest function applied to the filtering query; and
identifying, based on the digest, an entry in a data structure stored in the data access computing system, wherein the data structure tracks a state of the cache of the cloud-based data warehouse;
send, in response to the filtered result being stored in the cache, to the cloud-based data warehouse, a request for the filtered result from the cache; and
provide, based on the filtered result for the filtering query, one or more dashboard visualizations.
11 . The apparatus of claim 10 , wherein the entry in the data structure includes a timestamp, generated by the dashboard module at a time the entry was created, for the filtered result for the filtering query indicative of when the filtered result was produced and stored in the cache.
12 . The apparatus of claim 11 , further comprising: determining,
based on the entry, a location in the cache of the filtered result.
13 . The apparatus of claim 10 , further comprising:
determining that an age associated with the filtered result exceeds a threshold;
querying the cloud-based data warehouse with the filtering query;
receiving, in response to the filtering query, a next filtered result for the filtering query; and
updating the one or more dashboard visualizations based on the next filtered result for the filtering query.
14 . The apparatus of claim 10 , further comprising:
determining that a next filtered result for a next filtering query is not stored in the cache of the cloud-based data warehouse;
querying the cloud-based data warehouse with the next filtering query;
receiving, in response to the next filtering query, the next filtered result for the next filtering query; and
storing an indication that the next filtered result for the next filtering query is stored in the cache of the cloud-based data warehouse.
15 . The apparatus of claim 10 , further comprising:
determining that a next filtered result for a next filtering 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 next filtering query; and
receiving, in response to the next filtering query, the next filtered result for the next filtering query.
16 . The apparatus of claim 10 , wherein the filtering query comprises a request for rows matching a criterion, and wherein the one or more dashboard visualizations comprises a dashboard visualization of the rows matching the criterion.
17 . The apparatus of claim 10 , wherein the filtering query comprises a request for a frequency distribution, and wherein the one or more dashboard visualizations comprise a histogram distribution of values.
18 . A computer program product for dashboard loading using a filtering query 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:
determine, by a dashboard module within a data access computing system separate from a cloud-based data warehouse, that a filtered result for a filtering query is stored in a cache of the cloud-based data warehouse, including:
generating a digest for the filtering query based on a digest function applied to the filtering query; and
identifying, based on the digest, an entry in a data structure stored in the data access computing system, wherein the data structure tracks a state of the cache of the cloud-based data warehouse;
send, in response to the filtered result being stored in the cache, to the cloud-based data warehouse, a request for the filtered result from the cache; and
provide, based on the filtered result for the filtering query, one or more dashboard visualizations.
19 . The computer program product of claim 18 , wherein the entry in the data structure includes a timestamp, generated by the dashboard module at a time the entry was created, for the filtered result for the filtering query indicative of when the filtered result was produced and stored in the cache.
20 . The computer program product of claim 19 , further comprising: determining, based on the entry, a location in the cache of the filtered result.