US 11,914,595 B2
Virtual warehouse query monitoring and reporting
Praveen Kandukuri, Ashburn, VA (US); Syed Salim, North Potomac, MD (US); Karamchandradatt Hardatt, Glen Allen, VA (US); Nagender Gurram, Glen Allen, VA (US); Ganesh Bharathan, Henrico, VA (US); and Yudhish Batra, McLean, VA (US)
Assigned to Capital One Services, LLC, McLean, VA (US)
Filed by Capital One Services, LLC, McLean, VA (US)
Filed on Jul. 13, 2021, as Appl. No. 17/374,461.
Prior Publication US 2023/0014937 A1, Jan. 19, 2023
Int. Cl. G06F 16/245 (2019.01); G06F 16/25 (2019.01); G06F 16/2453 (2019.01)
CPC G06F 16/24545 (2019.01) [G06F 16/254 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A computing device comprising:
one or more processors; and
memory storing instructions that, when executed by the one or more processors, cause the computing device to:
receive, from a user device, a request to execute a query on at least one of a plurality of data warehouses;
determine information that identifies a user of the user device;
modify the received query by adding, to a metadata field of the received query, the information;
identify a plurality of virtual warehouses, wherein each of the plurality of virtual warehouses comprises a respective set of computing resources configured to:
execute one or more queries with respect to at least a portion of the plurality of data warehouses;
collect results from the one or more queries; and
provide, to the user device, access to the collected results;
cause a first virtual warehouse of the plurality of virtual warehouses to execute the query;
receive, based on execution of the query by the first virtual warehouse:
query results that comprise the metadata field that comprises the information that identifies the user of the user device; and
costs data that indicates one or more costs associated with execution of the query by the first virtual warehouse;
extract the information from the metadata field in the query results; and
generate, based on the costs data and the extracted information in the metadata field of the query results, a user interface comprising query cost information corresponding to the information.