US 12,130,783 B1
Providing access to usage reports on a cloud-based data warehouse
Robert C. Woollen, San Rafael, CA (US); and Joseph Bates, San Francisco, CA (US)
Assigned to SIGMA COMPUTING, INC., San Francisco, CA (US)
Filed by SIGMA COMPUTING, INC., San Francisco, CA (US)
Filed on Dec. 9, 2022, as Appl. No. 18/078,496.
Application 18/078,496 is a continuation of application No. 16/925,067, filed on Jul. 9, 2020, granted, now 11,580,079.
Claims priority of provisional application 62/931,457, filed on Nov. 6, 2019.
Int. Cl. G06F 16/21 (2019.01); G06F 16/22 (2019.01); G06F 16/2457 (2019.01); G06F 16/28 (2019.01); G06F 21/62 (2013.01)
CPC G06F 16/21 (2019.01) [G06F 16/2282 (2019.01); G06F 16/2457 (2019.01); G06F 16/283 (2019.01); G06F 21/6209 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A method of providing access to usage reports on a cloud-based data warehouse, the method comprising:
maintaining, by a management module, a metadata table on the cloud-based data warehouse, wherein the metadata table comprises usage reports for a plurality of organizations, and wherein;
maintaining the metadata table comprises monitoring interactions between the management module and user accounts associated with each of the plurality of organizations; and
the management module comprises a system separate from the cloud-based data warehouse and operates as an intermediary between user accounts and the cloud-based data warehouse to receive requests from a user, generate one or more queries based on the request, transmit the queries to the cloud-based data warehouse, and present, to the user, responses to the queries from the data warehouse;
receiving, by the management module from an administrator account for a first organization of the plurality of organizations, a request for the metadata table comprising the usage reports for the plurality of organizations;
granting, by the management module, the administrator account permission to access a filtered portion of the requested metadata table, wherein the filtered portion of the requested metadata table is generated by filtering the requested metadata table by an organization identifier of the first organization; and
providing, by the management module, the filtered portion of the requested metadata table to the administrator account.