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:
Jul. 26, 2022
Filed:
Nov. 19, 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 pruning external data. In an embodiment, a database platform receives a query directed at least in part to external data in an external table on an external data storage platform. The external table includes partitions that correspond to storage locations in a source directory of the external data storage platform. The storage locations contain files that contain the external data. The database platform identifies, from 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 source directory, a subset of the partitions as including data that potentially satisfies the query. The database platform identifies data that satisfies the query by scanning the identified subset of the partitions, and responds to the query at least in part with the identified data that satisfies the query.