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.

Date of Patent:
Dec. 12, 2023

Filed:

Jul. 15, 2022
Applicant:

Snowflake Inc., Bozeman, MT (US);

Inventors:

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);

Assignee:

Snowflake Inc., Bozeman, MT (US);

Attorney:
Primary Examiner:
Int. Cl.
CPC ...
G06F 16/20 (2019.01); G06F 16/242 (2019.01); G06F 3/06 (2006.01); G06F 16/23 (2019.01); G06F 16/16 (2019.01); G06F 16/25 (2019.01); G06F 9/54 (2006.01); G06F 16/22 (2019.01); G06F 16/2455 (2019.01);
U.S. Cl.
CPC ...
G06F 16/2423 (2019.01); G06F 3/0605 (2013.01); G06F 3/067 (2013.01); G06F 3/0644 (2013.01); G06F 3/0653 (2013.01); G06F 9/542 (2013.01); G06F 16/164 (2019.01); G06F 16/2282 (2019.01); G06F 16/2358 (2019.01); G06F 16/2393 (2019.01); G06F 16/24557 (2019.01); G06F 16/256 (2019.01);
Abstract

In an embodiment, a database platform receives a query that is directed at least in part to external data in an external table stored on a data storage platform that is external to the database platform. The external table includes a plurality of partitions. The database platform identifies, from external-table metadata, a subset of the plurality of partitions of the external table as including data that potentially satisfies the query. The external-table metadata is stored by the database platform. 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.


Find Patent Forward Citations

Loading…