US 12,235,835 B2
Systems and methods for efficiently querying external tables
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); and Istvan Cseri, Seattle, WA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Dec. 1, 2023, as Appl. No. 18/526,666.
Application 18/526,666 is a continuation of application No. 17/812,878, filed on Jul. 15, 2022, granted, now 11,841,849.
Application 17/812,878 is a continuation of application No. 17/455,798, filed on Nov. 19, 2021, granted, now 11,397,729.
Application 17/455,798 is a continuation of application No. 16/385,837, filed on Apr. 16, 2019, granted, now 11,194,795.
Prior Publication US 2024/0111762 A1, Apr. 4, 2024
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/20 (2019.01); G06F 3/06 (2006.01); G06F 9/54 (2006.01); G06F 16/16 (2019.01); G06F 16/22 (2019.01); G06F 16/23 (2019.01); G06F 16/242 (2019.01); G06F 16/2455 (2019.01); G06F 16/25 (2019.01)
CPC G06F 16/2423 (2019.01) [G06F 3/0605 (2013.01); G06F 3/0644 (2013.01); G06F 3/0653 (2013.01); G06F 3/067 (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)] 20 Claims
OG exemplary drawing
 
1. A method comprising:
generating a source directory by identifying a plurality of partitions, each partition including external data in an external table stored on a data storage platform, the generating of the source directory including:
identifying the plurality of partitions in the data storage platform;
identifying folders and folder locations for individual partitions; and
generating the source directory using the identified folders and folder locations;
receiving a query for execution on the external data in the external table stored on the data storage platform external to a database platform, the external data distributed among the plurality of partitions, the plurality of partitions being organized in the external table based on information located in the source directory, the source directory defining the folders and the folder locations, the folders storing files corresponding to particular partitions;
identifying at least a subset of the plurality of partitions for execution of the query;
identifying data that satisfies the query by assessing data stored within the identified subset of the plurality of partitions at least partially based on application of the query to the source directory; and
responding to the query at least in part with the identified data that satisfies the query.