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:
Mar. 08, 2022
Filed:
Oct. 11, 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 processing queries over external tables. In an embodiment, a database platform receives a query directed at least to data in an external table stored in a storage platform that is external to the database platform. The database platform uses metadata that summarizes the data in the external table to identify one or more partitions of the external table as potentially including data satisfying the query, and generates a query plan that includes a plurality of discrete subtasks that collectively include instructions to scan the identified one or more partitions of the external table for data satisfying the query. The database platform assigns, based on the metadata, the plurality of discrete subtasks to one or more nodes in an execution platform, and refreshes the metadata in response to a threshold number of modifications being made to the external table.