US 11,983,198 B2
Multi-cluster warehouse
Thierry Cruanes, San Mateo, CA (US); Benoit Dageville, Foster City, CA (US); Florian Andreas Funke, San Francisco, CA (US); and Peter Povinec, Redwood City, CA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Apr. 26, 2023, as Appl. No. 18/139,809.
Application 18/139,809 is a continuation of application No. 18/102,681, filed on Jan. 27, 2023, granted, now 11,675,815.
Application 18/102,681 is a continuation of application No. 16/823,124, filed on Mar. 18, 2020, granted, now 11,593,403, issued on Feb. 28, 2023.
Application 16/823,124 is a continuation of application No. 15/582,071, filed on Apr. 28, 2017, granted, now 11,615,117, issued on Mar. 28, 2023.
Claims priority of provisional application 62/328,943, filed on Apr. 28, 2016.
Prior Publication US 2023/0259530 A1, Aug. 17, 2023
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/28 (2019.01); G06F 9/50 (2006.01); G06F 16/2455 (2019.01); H04L 41/0896 (2022.01); H04L 41/5025 (2022.01); H04L 43/0817 (2022.01); H04L 67/1008 (2022.01); H04L 67/1097 (2022.01)
CPC G06F 16/283 (2019.01) [G06F 9/5072 (2013.01); G06F 16/2455 (2019.01); H04L 41/0896 (2013.01); H04L 41/5025 (2013.01); H04L 67/1008 (2013.01); H04L 67/1097 (2013.01); H04L 43/0817 (2013.01)] 26 Claims
OG exemplary drawing
 
1. A method of implementing a fault-tolerant data warehouse using availability zones, comprising:
allocating a plurality of processing units to a data warehouse, the plurality of processing units located in different availability zones, an availability zone comprising one or more data centers;
routing, by a processing device, a query to a processing unit within the data warehouse, the query having a common session identifier with a query previously provided to the processing unit, the processing unit determined to be caching a data segment associated with a cloud storage resource, usable by the query, wherein the cloud storage resource is independent of the plurality of processing units;
as a result of monitoring a number of queries running at an input degree of parallelism, determining that a processing capacity of the plurality of processing units has reached a threshold; and
changing a total number of processing units associated with the data warehouse using the input degree of parallelism and the number of queries.