-
公开(公告)号:US20230214405A1
公开(公告)日:2023-07-06
申请号:US18119775
申请日:2023-03-09
Applicant: Snowflake Inc.
Inventor: Subramanian Muralidhar , Polita Paulus , Sahaj Saini , Saurin Shah , Srinidhi Karthik Bisthavalli Srinivasa
IPC: G06F16/27 , G06F16/955 , G06F16/25
CPC classification number: G06F16/27 , G06F16/9566 , G06F16/254
Abstract: The embodiments described herein provide means for replicating external stages between deployments of e.g., a cloud data lake using a modified storage integration. The modified storage integration may be defined with a set of storage locations, wherein the storage integration comprises a base URL for each of the set of storage locations and wherein each storage location identifies a remote deployment where a cloud platform is hosted and a geographic region of the remote deployment. An external stage object may be bound to the storage integration, wherein the external stage object facilitates a data loading operation that is currently in progress on the first storage location. In response to detecting an outage at the first storage location, the data loading operation that was in progress on the first storage location may be continued at the second storage location using the storage integration.
-
公开(公告)号:US20230214383A1
公开(公告)日:2023-07-06
申请号:US18181423
申请日:2023-03-09
Applicant: Snowflake Inc.
Inventor: Raja Suresh Krishna Balakrishnan , Khalid Zaman Bijon , Subramanian Muralidhar , David Schultz , Jian Xu
IPC: G06F16/23
CPC classification number: G06F16/2365 , G06F16/2358
Abstract: Aspects of the present disclosure address systems, methods, and devices for tracking object dependencies in a cloud database system. An object dependency created between a referencing object and a referenced object is detected. Based on detecting the object dependency, a dependency record is generated. The dependency record includes dependency information describing the object dependency between the reference object and the referenced object. The dependency record is stored in a database of dependency records.
-
公开(公告)号:US11687531B2
公开(公告)日:2023-06-27
申请号:US18051185
申请日:2022-10-31
Applicant: Snowflake Inc.
Inventor: Sangyong Hwang , Sourav Sikdar , Li Yan
IPC: G06F16/245 , G06F16/2453 , G06F16/2455 , G06F11/34
CPC classification number: G06F16/24542 , G06F11/3419 , G06F16/24549 , G06F16/24565 , G06F2201/80 , G06F2201/81
Abstract: The subject technology tracks a plurality of queries corresponding to a plurality of query plans based on join operations contained in each of the plurality of queries and a previous time of executing each query. The subject technology selects a first query plan among the plurality of query plans. The subject technology determines a value indicating an estimated improvement in execution time of the first query plan in comparison to a previous execution time of a previous query plan. The subject technology attempts to execute a first query using the first query plan. The subject technology determines that a second query plan selected among the plurality of query plans has a second estimated execution time that is less than an estimated execution time of the first query plan. The subject technology executes the first query corresponding to the first query plan at a subsequent time using the second query plan.
-
124.
公开(公告)号:US20230195719A1
公开(公告)日:2023-06-22
申请号:US17555197
申请日:2021-12-17
Applicant: Snowflake Inc.
Inventor: Chen Luo , Alexander Miller , William Waddington , Mingze Xu
CPC classification number: G06F16/2379 , G06F16/27
Abstract: The subject technology receives a key-value pair. The subject technology determines a value size of the key-value pair is greater than a threshold size for an out of line blob (OLB) key space. The subject technology performs a write operation of a key-pointer pair into a regular space. The subject technology performs a plurality of write operations for multiple key-value parts of the key-value pair into the OLB key space. The subject technology performs conflict checking of the regular space for the key-value pair.
-
公开(公告)号:US20230186160A1
公开(公告)日:2023-06-15
申请号:US18055248
申请日:2022-11-14
Applicant: Snowflake Inc.
Inventor: Monica J. Holboke , Justin Langseth , Stuart Ozer , William L. Stratton, JR.
IPC: G06N20/00 , G06F21/62 , G06F16/25 , G06F16/28 , G06F18/214
CPC classification number: G06N20/00 , G06F21/6227 , G06F16/256 , G06F16/283 , G06F18/214
Abstract: Disclosed are systems, methods, and non-transitory computer-readable media for sharing, on a distributed database, a database application to a first user of the distributed database, the database application generated by a second user of the distributed database. The training dataset includes a first database training dataset from the first user of the distributed database and a second database training dataset from the second user of the distributed database, the first database training dataset and the second database training dataset including non-overlapping dataset features. The database application further identifies a query from the second user to train the machine learning model on the training dataset and generates a trained machine learning model by training the machine learning model on a joined dataset according to the query. The database application generates outputs from the trained machine learning model by applying the trained machine learning model on new data.
-
公开(公告)号:US11675815B1
公开(公告)日:2023-06-13
申请号:US18102681
申请日:2023-01-27
Applicant: Snowflake Inc.
Inventor: Thierry Cruanes , Benoit Dageville , Florian Andreas Funke , Peter Povinec
IPC: G06F16/2455 , H04L41/0896 , H04L67/1008 , G06F16/28 , H04L67/1097 , H04L41/5025 , G06F9/50 , H04L43/0817
CPC classification number: G06F16/283 , G06F9/5072 , G06F16/2455 , H04L41/0896 , H04L41/5025 , H04L67/1008 , H04L67/1097 , H04L43/0817
Abstract: A method for a multi-cluster warehouse includes allocating processing units as part of a data warehouse. The processing units access data within one or more databases in cloud storage resources. The method also includes providing one or more queries to each processing unit within the data warehouse. In response to the queries, each processing unit performs database operations on a particular portion of a database table. The method also includes monitoring a workload of the processing units to determine that a processing capacity of the processing units has reached a threshold processing capacity. The method also includes dynamically adding additional processing units to and removing processing units from the data warehouse as needed based on a workload of the processing units.
-
公开(公告)号:US20230177210A1
公开(公告)日:2023-06-08
申请号:US18162506
申请日:2023-01-31
Applicant: Snowflake Inc.
Inventor: Artin Avanes , Thierry Cruanes , Monica J. Holboke , Allison Waingold Lee , Subramanian Muralidhar , David Schultz
CPC classification number: G06F21/6245 , G06F21/53 , G06F2221/032
Abstract: A data platform creates an application in a data-provider account, where the application includes one or more application programming interfaces (APIs) corresponding to one or more underlying code blocks. The data platform shares homomorphically encrypted provider data with the application in the data-provider account. The data platform installs, in a data-consumer account, an application instance of the application. The data platform shares homomorphically encrypted consumer data with the application instance in the data-consumer account. The data platform invokes one or more of the APIs of the application instance to execute respective associated underlying code blocks, which are not visible to the data-consumer account, and which operate on the shared homomorphically encrypted provider data and the shared homomorphically encrypted consumer data. The data platform saves homomorphically encrypted output of the one or more respective associated underlying code blocks locally within the data-consumer account.
-
公开(公告)号:US20230176909A1
公开(公告)日:2023-06-08
申请号:US18161044
申请日:2023-01-28
Applicant: Snowflake Inc.
Inventor: Johan Harjono , Daniel Geoffrey Karp , Kunal Prafulla Nabar , Rares Radut , Arthur Kelvin Shi
CPC classification number: G06F9/5005 , G06F9/3555 , G06F9/505 , G06F9/5077 , G06F9/5083
Abstract: Techniques described herein can optimize usage of computing resources in a data system. Dynamic throttling can be performed locally on a computing resource in the foreground and autoscaling can be performed in a centralized fashion in the background. Dynamic throttling can lower the load without overshooting while minimizing oscillation and reducing the throttle quickly. Autoscaling may involve scaling in or out the number of computing resources in a cluster as well as scaling up or down the type of computing resources to handle different types of situations.
-
公开(公告)号:US11671459B2
公开(公告)日:2023-06-06
申请号:US17526958
申请日:2021-11-15
Applicant: SNOWFLAKE INC.
Inventor: James Calvin Armstrong , Jonathan Claybaugh
IPC: H04L9/40 , H04L43/026 , H04L41/22 , H04L47/10 , H04L43/00 , H04L43/062 , H04L41/0604 , H04L43/0811 , G06F21/57 , G06F21/56 , G06F21/62
CPC classification number: H04L63/20 , G06F21/566 , G06F21/57 , G06F21/6218 , H04L41/0604 , H04L41/22 , H04L43/00 , H04L43/026 , H04L43/062 , H04L43/0811 , H04L47/10 , H04L63/0263 , H04L63/102 , H04L63/104 , H04L63/1408 , H04L63/1416
Abstract: The disclosure relates generally to methods, systems, and apparatuses for managing network connections. A system for managing network connections includes a storage component, a decoding component, a rule manager component, and a notification component. The storage component is configured to store a list of expected connections for a plurality of networked machines, wherein each connection in the list of expected connections defines a start point and an end point for the connection. The decoding component is configured to decode messages from the plurality of networked machines indicating one or more connections for a corresponding machine. The rule manager component is configured to identify an unexpected presence or absence of a connection on at least one of the plurality of network machines based on the list of expected connections. The notification component is configured to provide a notification or indication of the unexpected presence or absence.
-
公开(公告)号:US20230169203A1
公开(公告)日:2023-06-01
申请号:US18162709
申请日:2023-01-31
Applicant: Snowflake Inc.
Inventor: Justin Langseth , Michael Earle Rainey , William L. Stratton, JR.
IPC: G06F21/62 , H04L9/40 , G06F16/9535 , G06F16/27
CPC classification number: G06F21/6227 , H04L63/0421 , G06F16/9535 , G06F16/27 , H04L9/0643
Abstract: Embodiments of the present disclosure may provide a data clean room allowing encryption based data analysis across multiple accounts, including different provider database user accounts that provide user data and a network service and a requesting user that generates one or more clean room requests. The data clean room may also restrict which data may be used in the analysis and may restrict the output.
-
-
-
-
-
-
-
-
-