Capital One Services, LLC

Yudhish Batra

Nagender Gurram

Syed Shamaz Salim

Praveen Kandukuri

Ganesh Bharathan

Karamchandradatt Hardatt

Naga Venkata Sriram Vadakattu

Sridhar Maramreddy

Hiren Shah

Naveen Kumar Kilaru

David Ellis

Kishore Kolanu

Felix Li

Fnu Syed Siraj Mehmood

Nicole Ann Luo

Syed Mehmood

Hari Hara Sudhan Gnanaprakasam

Nicole Markley

Syed Salim

Methods, systems, devices, and computer-readable media used by a cloud data management system for collecting data from accounts hosted by a cloud-based data warehousing system on different cloud platforms or in different cloud regions of a cloud platform. Collection of data in the multi-cloud platform and/or multi-cloud region environments may be facilitated by the on-demand creation of one or more data collection accounts. Based on the collected data, one or more data warehouse resources not managed by the cloud data management system may be discovered, configured, and onboarded to the cloud data management system.

Methods and system for detecting unmanaged resources in cloud-based data warehousing system

Methods, systems, and apparatuses for managing and selecting virtual warehouses for execution of queries on one or more data warehouses are described herein. A request to execute a query may be received. An execution plan, for the query, may be identified. A processing complexity for the query may be predicted based on the query and the execution plan. A plurality of virtual warehouses may be identified. An operating status and processing capabilities of the plurality of virtual warehouses may be determined. A subset of the plurality of virtual warehouses may be selected based on the processing complexity, the operating status of the plurality of virtual warehouses, and the processing capabilities of the plurality of virtual warehouses. The query may be executed on one of the subset of the plurality of virtual warehouses.

Dynamic query allocation to virtual warehouses

Methods, systems, and apparatuses for providing access to records of a database stored on a database server in a cloud database platform are described herein. A data sharing platform may determine a shared view definition for access to the database. The data sharing platform may determine rules that specify criteria that limit access to the records stored by the database. The one or more first rules may be received via a user interface. The data sharing platform may perform, based on the rules, a data access certification process on the records stored by the database to generate a table of certification results. The data sharing platform may generate, based on the table of certification results, and without modifying the records stored by the database, a limited consumer view definition. Based on updates to the records, a new limited consumer view definition may be generated.

Data certification process for cloud database platform

Data certification process for updates to data in cloud database platform

Methods, systems, and apparatuses for generating notifications corresponding to queries submitted for execution by virtual warehouses are described herein. A request to execute a query may be received. An execution plan, for the query, may be identified. A processing complexity for the query may be predicted based on the query and the execution plan. A notification may be generated based on the processing complexity meeting an alert threshold. A user device may display the notification. A response to the notification comprising a selection of a first virtual warehouse, of a plurality of virtual warehouses, to execute the query may be received.

Query alerts generation for virtual warehouse

Systems as described herein may implement a data management ecosystem for databases. A computing device may receive, from a first user device, a request to migrate one or more data objects from a sandbox to a production environment. The production environment may include a plurality of data warehouses that may be provided as a service in a cloud computing environment, and computing resources are dynamically allocated to the plurality of data warehouses. The computing device may determine lineage information and update a database catalog of the data warehouses with the lineage information. The computing device may identify sensitive data contained within the one or more data objects and generate tokenization for the sensitive data. Based on the lineage information in the database catalog and the tokenization, the computing device may generate a migration plan and cause the at least one of the plurality of data warehouses to execute the migration plan.

Data management ecosystem for databases

Methods, systems, devices, and computer-readable media used by a cloud data management system for collecting data from accounts hosted by a cloud-based data warehousing system on different cloud platforms or in different cloud regions of a cloud platform. Collection of data in the multi-cloud platform and/or multi-cloud region environments may be facilitated by the on-demand creation of one or more data collection accounts. Based on the collected data, one or more recommendations, notifications, or alerts associated with usage of the data warehousing system may be generated.

Methods and systems for generating recommendations in cloud-based data warehousing system

Methods, systems, and apparatuses for tracking and generating analysis of queries submitted to virtual warehouses are described herein. A request to execute a query may be received. An organization may be determined, and the query may be modified to add an indication of the organization. A plurality of virtual warehouses may be identified. One of the plurality of virtual warehouses may be caused to execute the query. Query results and costs data may be received based on execution of the query by the first virtual warehouse. The costs data may indicate one or more costs associated with the execution of the query by the first virtual warehouse. The indication of the organization may be extracted from the query results. A user interface comprising query cost information corresponding to the organization may be generated.

Virtual warehouse query monitoring and reporting

Growing community of inventors

Glen Allen, VA, United States of America

Yudhish Batra