-
公开(公告)号:US20240143548A1
公开(公告)日:2024-05-02
申请号:US18050122
申请日:2022-10-27
Applicant: Snowflake Inc.
Inventor: Tyler Arthur Akidau , Thierry Cruanes , Benoit Dageville , Ganeshan Ramachandran Iyer , Subramanian Muralidhar
CPC classification number: G06F16/148 , G06F9/5022 , G06F16/116
Abstract: Techniques for continuous ingestion of files using custom file formats are described. A custom file format may include formats not natively supported by a data system. Unstructured files (e.g., images) may also be considered custom file formats. A custom file format may be set using a user defined table function and scanner options.
-
公开(公告)号:US20240129360A1
公开(公告)日:2024-04-18
申请号:US18493606
申请日:2023-10-24
Applicant: Snowflake Inc.
Inventor: Pui Kei Johnston Chu , Benoit Dageville , Matthew Glickman , Christian Kleinerman , Prasanna Krishnan , Justin Langseth
CPC classification number: H04L67/10 , G06F16/2379 , G06F21/6272 , H04L41/5096 , H04L63/0272 , H04L63/10 , H04L63/101 , H04L67/1097 , H04L67/51 , H04L67/53
Abstract: Sharing data in a data exchange across multiple cloud computing platforms and/or cloud computing platform regions is described. An example computer-implemented method can include creating a listing in a data exchange, the listing including a data set hosted by a first cloud computing entity. The data set can be shared with a second cloud computing entity. The method further includes receiving a request associated with a customer account of the second cloud computing entity to access the data set of the listing hosted by the first cloud computing entity and replicating at least a subset of the data set of the listing from the first cloud computing entity to a provider account at the second cloud computing entity to be accessible by the customer account at the second cloud computing entity.
-
公开(公告)号:US20240126765A1
公开(公告)日:2024-04-18
申请号:US18392327
申请日:2023-12-21
Applicant: Snowflake Inc.
Inventor: Tyler Arthur Akidau , Istvan Cseri , Tyler Jones , Daniel E. Sotolongo , Zhuo Zhang
IPC: G06F16/2455 , G06F16/22 , G06F16/2453 , G06F16/25
CPC classification number: G06F16/24568 , G06F16/2219 , G06F16/24544 , G06F16/2456 , G06F16/258
Abstract: A streaming ingest platform can improve latency and expense issues related to uploading data into a cloud data system. The streaming ingest platform can organize the data to be ingested into per-table chunks and per-account blobs. This data may be committed and may be made available for query processing before it is ingested into the target source tables. This significantly improves latency issues. The streaming ingest platform can also accommodate uploading data from various sources with different processing and communication capabilities, such as Internet of Things (IOT) devices.
-
公开(公告)号:US11954224B1
公开(公告)日:2024-04-09
申请号:US18239527
申请日:2023-08-29
Applicant: SNOWFLAKE INC.
Inventor: Yimeng Li , Carl Yates Perry , Raghavendran Ramakrishnan , Frantisek Rolinek , Yunqiao Zhang
CPC classification number: G06F21/6227 , G06F16/285 , G06F21/6254
Abstract: Embodiments of the present disclosure describe systems, methods, and computer program products for redacting sensitive data within a database. An example method can include receiving a masking policy for a column of a database, the masking policy identifying a category of sensitive data, examining a column of a database to identify a category of sensitive data in a first location of the column, and, in response to a data query accessing the column, the first location of the column exceeding a threshold probability of comprising sensitive data, executing a redaction operation to redact the category of sensitive data from the first location of the column to generate redacted data for a response to the data query.
-
公开(公告)号:US20240111787A1
公开(公告)日:2024-04-04
申请号:US18539079
申请日:2023-12-13
Applicant: Snowflake Inc.
Inventor: Benoit Dageville , Thierry Cruanes , Marcin Zukowski , Allison Waingold Lee , Philipp Thomas Unterbrunner
IPC: G06F16/27 , A61F5/56 , G06F9/48 , G06F9/50 , G06F16/14 , G06F16/182 , G06F16/21 , G06F16/22 , G06F16/23 , G06F16/2453 , G06F16/2455 , G06F16/2458 , G06F16/25 , G06F16/28 , G06F16/951 , G06F16/9535 , G06F16/9538 , H04L67/1095 , H04L67/1097 , H04L67/568
CPC classification number: G06F16/273 , A61F5/566 , G06F9/4881 , G06F9/5016 , G06F9/5044 , G06F9/5083 , G06F9/5088 , G06F16/148 , G06F16/1827 , G06F16/211 , G06F16/221 , G06F16/2365 , G06F16/24532 , G06F16/24545 , G06F16/24552 , G06F16/2456 , G06F16/2471 , G06F16/254 , G06F16/27 , G06F16/283 , G06F16/951 , G06F16/9535 , G06F16/9538 , H04L67/1095 , H04L67/1097 , H04L67/568
Abstract: A method, apparatus, and system for join operations of a plurality of relations that are distributed over a plurality of storage locations over a network of computing components.
-
公开(公告)号:US20240111762A1
公开(公告)日:2024-04-04
申请号:US18526666
申请日:2023-12-01
Applicant: Snowflake Inc.
Inventor: Subramanian Muralidhar , Benoit Dageville , Thierry Cruanes , Nileema Shingte , Saurin Shah , Torsten Grabs , Istvan Cseri
IPC: G06F16/242 , G06F3/06 , G06F9/54 , G06F16/16 , G06F16/22 , G06F16/23 , G06F16/2455 , G06F16/25
CPC classification number: G06F16/2423 , G06F3/0605 , G06F3/0644 , G06F3/0653 , G06F3/067 , G06F9/542 , G06F16/164 , G06F16/2282 , G06F16/2358 , G06F16/2393 , G06F16/24557 , G06F16/256
Abstract: Disclosed herein are systems and methods for efficiently querying external tables. 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.
-
77.
公开(公告)号:US20240104116A1
公开(公告)日:2024-03-28
申请号:US18524784
申请日:2023-11-30
Applicant: Snowflake Inc.
CPC classification number: G06F16/283 , G06F16/2264 , G06F16/284
Abstract: The subject technology generates a nested object based on a set of metadata, the set of metadata including information linking the nested object to a table object associated with a base table. The subject technology generates a second table object associated with the nested object, the second table object representing a secondary index of the base table, the second table object including information linking the second table object to the nested object. The subject technology generates a second nested object based on a particular set of metadata, the particular set of metadata including information linking the second nested object to the table object. The subject technology generates a third table object associated with the second nested object, the third table object representing a particular secondary index of the base table, the third table object including information linking the third table object to the second nested object.
-
公开(公告)号:US20240095217A1
公开(公告)日:2024-03-21
申请号:US18522182
申请日:2023-11-28
Applicant: Snowflake Inc.
Inventor: Tyler Jones , Peter Povinec
CPC classification number: G06F16/1734 , G06F16/144 , G06F16/156 , G06F16/1865 , H04L67/01 , H04L67/14
Abstract: In an embodiment, a database platform maintains a first account and a second account, where the second account has stored therein an attachable-and-detachable database session. The database platform receives, from a second-account user in the second account, a request to grant, to a first-account user in the first account, access to the attachable-and-detachable database session, and responsively grants the requested access. The database platform receives, from the first-account user, an attachment request requesting that the first-account user attach to the attachable-and-detachable database session, and responsively sets the attachable-and-detachable database session as a current database session for the first-account user. The database platform executes at least one command received from the first-account user with respect to the attachable-and-detachable database session.
-
79.
公开(公告)号:US20240086397A1
公开(公告)日:2024-03-14
申请号:US18511204
申请日:2023-11-16
Applicant: Snowflake Inc.
Inventor: Benoit Dageville , Johan Harjono , Kunal Prafulla Nabar , Steven James Pelley
IPC: G06F16/23 , G06F16/2455
CPC classification number: G06F16/2365 , G06F16/2455
Abstract: Systems, methods, and devices for retrying a query. A method includes receiving a query directed to database data and assigning execution of the query to one or more execution nodes of an execution platform, the one or more execution nodes configured to execute the query on a first version of a database platform. The method includes determining that execution of the query was unsuccessful. The method includes assigning a first retry execution of the query to the one or more execution nodes of the execution platform and determining whether a regression or an intermittent fault caused the execution of the query to be unsuccessful based at least in part on whether the first retry execution of the query was successful or unsuccessful.
-
公开(公告)号:US11929986B1
公开(公告)日:2024-03-12
申请号:US18325388
申请日:2023-05-30
Applicant: Snowflake Inc.
Inventor: Khondokar Sami Igram , Laxman Mamidi , Sanjay Srivastava , Chieh-Sheng Wang , Di Wu
CPC classification number: H04L63/0263 , G06F21/6218 , H04L63/0272 , H04L63/083
Abstract: Methods, systems, and computer programs are presented for enabling automated secure data sharing from a private cloud region to a public cloud region and vice versa. A cloud data platform confirms a relationship establishment procedure between a provider and a consumer is recorded with a cloud data platform, the provider being associated with a private cloud deployment and the consumer being associated with a public cloud deployment in a public region. The cloud data platform enables disabling of a firewall policy that is preventing data traffic between the private cloud deployment and the public cloud deployment and enables data sharing between the private cloud deployment and the public cloud deployment. The cloud data platform enables data sharing in a database of the cloud data platform.
-
-
-
-
-
-
-
-
-