# US 12,182,168 B2 · Cost attribution using resource switching > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 12,182,168 B2 - Document ID: US12182168B2 - Status: Granted - Kind: B2 - Application number: 18/189,921 - Filed: 2023-03-24 - Published: 2024-09-26 - Granted: 2024-12-31 - Earliest claimed: 2023-03-24 - Assignees: Sigma Computing, Inc. - Applicants: Sigma Computing, Inc. - Inventors: Samuel Andre Abraham Soubeyran; Jack S. Qian; Prashant Soral; Samantha C. Watts; Zalak H. Trivedi; James A. Johnson - Web page: https://patentgrep.com/patent/US12182168B2 ## CPC - G06F 16/256: {in federated or virtual databases} - G06F 16/283: {Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP} - G06F 16/248: Presentation of query results - G06F 40/18: of spreadsheets (form-filling G06F40/174) - G06Q 10/0631: Resource planning, allocation, distributing or scheduling for enterprises or organisations - G06Q 10/10: Office automation; Time management - G06Q 30/0633: {Managing shopping lists, e.g. compiling or processing purchase lists (shipping orders G06Q10/083; order filling G06Q10/087)} - G06Q 50/12: Hotels or restaurants - G06Q 50/50: Business processes related to the communications industry (charging, metering or billing arrangements specially adapted for data communications H04L12/14; telephonic communication involving automatic or semi-automatic exchanges H04M3/00; arrangements for metering, time-control or time indication H04M15/00; prepayment telephone systems H04M17/00; accounting or billing for wireless communication networks H04W4/24) - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) - G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR ## Abstract Cost attribution using resource switching including receiving, by a workbook manager from a first client computing system, a first request for a workbook presenting a dataset from a cloud-based data warehouse, wherein the first request comprises a first user attribute; selecting, by the workbook manager, a first resource warehouse on the cloud-based data warehouse based on the first user attribute, wherein the first resource warehouse tracks resources used to service data requests on the cloud-based data warehouse; retrieving, by the workbook manager, the dataset from the cloud-based data warehouse using the first resource warehouse matched to the first user attribute; and presenting, on the first client computing system by the workbook manager, the workbook presenting the dataset. ## Claims ### Claim 1 A method for cost attribution using resource switching, the method comprising: receiving, by a workbook manager from a first client computing system, a first request for a workbook presenting a dataset from a cloud-based data warehouse, wherein the first request comprises a first user attribute; selecting, by the workbook manager, a first resource warehouse on the cloud-based data warehouse based on the first user attribute, wherein the first resource warehouse tracks resources used to service data requests on the cloud-based data warehouse; retrieving, by the workbook manager, the dataset from the cloud-based data warehouse using the first resource warehouse matched to the first user attribute; and presenting, on the first client computing system by the workbook manager, the workbook presenting the dataset. ### Claim 2 (depends on 1) The method of claim 1, further comprising: receiving, from a second client computing system, a second request for the workbook presenting the dataset from the cloud-based data warehouse, wherein the second request comprises a second user attribute; selecting a second resource warehouse on the cloud-based data warehouse based on the second user attribute; retrieving the dataset from the cloud-based data warehouse using the second resource warehouse matched to the second user attribute; and presenting, on the second client computing system, the workbook presenting the dataset. ### Claim 3 (depends on 1) The method of claim 1, wherein the first user attribute indicates an association between a user of the first client computing system and an organization, and wherein the first resource warehouse tracks resources used by the organization to service data requests on the cloud-based data warehouse. ### Claim 4 (depends on 1) The method of claim 1, wherein retrieving the dataset from the cloud-based data warehouse using the first resource warehouse comprises: generating a database statement composed to retrieve the dataset from the cloud-based data warehouse using the first resource warehouse matched to the first user attribute; sending the database statement to the cloud-based data warehouse, wherein the cloud-based data warehouses uses the first resource warehouse to generate query results for the database statement; and generating the dataset using the query results from the cloud-based data warehouse. ### Claim 5 (depends on 4) The method of claim 4, wherein the database statement comprises an identifier of the first resource warehouse. ### Claim 6 (depends on 4) The method of claim 4, wherein the database statement is a structured query language statement. ### Claim 7 (depends on 1) The method of claim 1, wherein selecting the first resource warehouse on the cloud-based data warehouse based on the first user attribute comprises using the first user attribute as a key into a data structure matching user attributes to resource warehouses. ### Claim 8 (depends on 1) The method of claim 1, wherein the first user attribute is set by an application on the first client computing system embedding the workbook. ### Claim 9 (depends on 1) The method of claim 1, wherein the first user attribute is used by a plurality of users on a plurality of client computing systems. ### Claim 10 (depends on 1) The method of claim 1, wherein the workbook manager is on an intermediary computing system between the first client computing system and the cloud-based data warehouse. ### Claim 11 An apparatus for cost attribution using resource switching, 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: receiving, from a first client computing system, a first request for a workbook presenting a dataset from a cloud-based data warehouse, wherein the first request comprises a first user attribute; selecting a first resource warehouse on the cloud-based data warehouse based on the first user attribute, wherein the first resource warehouse tracks resources used to service data requests on the cloud-based data warehouse; retrieving the dataset from the cloud-based data warehouse using the first resource warehouse matched to the first user attribute; and presenting, on the first client computing system, the workbook presenting the dataset. ### Claim 12 (depends on 11) The apparatus of claim 11, wherein the computer program instructions further cause the apparatus to carry out the step of: receiving, from a second client computing system, a second request for the workbook presenting the dataset from the cloud-based data warehouse, wherein the second request comprises a second user attribute; selecting a second resource warehouse on the cloud-based data warehouse based on the second user attribute; retrieving the dataset from the cloud-based data warehouse using the second resource warehouse matched to the second user attribute; and presenting, on the second client computing system, the workbook presenting the dataset. ### Claim 13 (depends on 11) The apparatus of claim 11, wherein the first user attribute indicates an association between a user of the first client computing system and an organization, and wherein the first resource warehouse tracks resources used by the organization to service data requests on the cloud-based data warehouse. ### Claim 14 (depends on 11) The apparatus of claim 11, wherein retrieving the dataset from the cloud-based data warehouse using the first resource warehouse comprises: generating a database statement composed to retrieve the dataset from the cloud-based data warehouse using the first resource warehouse matched to the first user attribute; sending the database statement to the cloud-based data warehouse, wherein the cloud-based data warehouses uses the first resource warehouse to generate query results for the database statement; and generating the dataset using the query results from the cloud-based data warehouse. ### Claim 15 (depends on 14) The apparatus of claim 14, wherein the database statement comprises an identifier of the first resource warehouse. ### Claim 16 (depends on 14) The apparatus of claim 14, wherein the database statement is a structured query language statement. ### Claim 17 (depends on 11) The apparatus of claim 11, wherein selecting the first resource warehouse on the cloud-based data warehouse based on the first user attribute comprises using the first user attribute as a key into a data structure matching user attributes to resource warehouses. ### Claim 18 (depends on 11) The apparatus of claim 11, wherein the first user attribute is set by an application on the first client computing system embedding the workbook. ### Claim 19 (depends on 11) The apparatus of claim 11, wherein the first user attribute is used by a plurality of users on a plurality of client computing systems. ### Claim 20 A computer program product for cost attribution using resource switching, the computer program product disposed upon a non-transitory computer readable medium, the computer program product comprising computer program instructions that, when executed, cause a computer to carry out the steps of: receiving, from a first client computing system, a first request for a workbook presenting a dataset from a cloud-based data warehouse, wherein the first request comprises a first user attribute; selecting a first resource warehouse on the cloud-based data warehouse based on the first user attribute, wherein the first resource warehouse tracks resources used to service data requests on the cloud-based data warehouse; retrieving the dataset from the cloud-based data warehouse using the first resource warehouse matched to the first user attribute; and presenting, on the first client computing system, the workbook presenting the dataset.