The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Jun. 13, 2023
Filed:
Feb. 09, 2022
Snowflake Inc., Bozeman, MT (US);
Subramanian Muralidhar, Mercer Island, WA (US);
Benoit Dageville, San Mateo, CA (US);
Thierry Cruanes, San Mateo, CA (US);
Nileema Shingte, San Mateo, CA (US);
Saurin Shah, Kirkland, WA (US);
Torsten Grabs, San Mateo, CA (US);
Istvan Cseri, Seattle, WA (US);
Snowflake Inc., Bozeman, MT (US);
Abstract
Disclosed herein are embodiments of systems and methods for partition-based scanning of external tables for query processing. In an example embodiment, a database platform receives a query that includes one or more predicates, where the query is directed at least to data in an external table that is stored in an external storage platform that is external to the database platform. The database platform identifies, based on metadata that summarizes the data in the external table, one or more partitions of the external table that potentially include data that satisfies the one or more predicates. The database platform also identifies, from the one or more identified partitions, data that satisfies the one or more predicates. The database platform sends a response to the query to the client, the response comprising the data satisfying the one or more predicates.