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. 07, 2022
Filed:
Dec. 23, 2021
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 systems and methods for selective scanning of external partitions. In an embodiment, a database platform receives a query directed at least in part to an external table stored on an external data storage platform. The external table is partitioned into partitions corresponding to storage locations in the external data storage platform. The database platform prunes, using external-table metadata that is stored by the database platform and that maps the partitions of the external table to the storage locations in the external data storage platform, those partitions that do not potentially contain data that satisfies the query. The database platform identifies data that satisfies the query by scanning any one or more of the partitions of the external table that were not pruned, and responds to the query at least in part with the identified data that satisfies the query.