-
公开(公告)号:US20240061730A1
公开(公告)日:2024-02-22
申请号:US18243609
申请日:2023-09-07
Applicant: Snowflake Inc.
Inventor: Damien Carru , Pui Kei Johnston Chu , Unmesh Jagtap , Xiaodi Ke , Haroldo Level , Subramanian Muralidhar , James Pan , Steven Parkes , Xie Xu
CPC classification number: G06F9/542 , G06F16/254
Abstract: Disclosed is an execution information sharing system that duplicates execution information to a provider target (and other targets) as it is being loaded to a consumer target. A first log information object and a second log information object are generated. The first and second log information objects comprise information indicating a consumer target and information indicating a provider target respectively where execution information generated by an application shared with a consumer account of a data exchange is written. A first event unloader and a second event unloader are generated based on the first and second log information objects respectively, wherein the first and second event unloaders are both linked to the application using a mapping. In response to receiving execution information from the application, the execution information is forwarded to the consumer target and the provider target using the first event unloader and the second event unloader respectively.
-
公开(公告)号:US11899646B2
公开(公告)日:2024-02-13
申请号:US18193069
申请日:2023-03-30
Applicant: Snowflake Inc.
Inventor: Selcuk Aya , Thierry Cruanes , Istvan Cseri , Benoit Dageville , Marcia Feitel , Steven P. Herbert , Xinglian Liu , James Malone , Subramanian Muralidhar , Muthunagappan Muthuraman , Polita Paulus , Marianne Shaw , Nileema Shingte , Wai Sing Wong , Jiaqi Yan
CPC classification number: G06F16/2282 , G06F16/2379 , G06F16/258
Abstract: The subject technology receives a command to commit a table in a different table format on an external volume. The subject technology generates a first snapshot of the table on internal storage. The subject technology generates a first list of metadata files on the internal storage. The subject technology generates, based on the first list of metadata files, a first set of metadata files on the internal storage. The subject technology generates a second snapshot of the table on the external volume. The subject technology generates a second list of metadata files on the external volume. The subject technology generates, based on the second list of metadata files, a second set of metadata files on the external volume. The subject technology generates a first set of data files in a different file format on the external volume.
-
公开(公告)号:US11886872B1
公开(公告)日:2024-01-30
申请号:US18169812
申请日:2023-02-15
Applicant: Snowflake Inc.
Inventor: Karol Pawel Bienkowski , Damien Carru , Jeremy Yujui Chen , Pui Kei Johnston Chu , Benoit Dageville , Scott C. Gray , Unmesh Jagtap , Subramanian Muralidhar
CPC classification number: G06F8/71 , G06F9/4488
Abstract: An in-database application package and application instance for a data platform. The data platform creates an application instance of an application package having a versioned schema, creates one or more system roles for the application instance, creates a user role and an administrator role for the application instance, creates one or more objects of the application instance based on a versioned schema, and grants one or more use privileges to the one or more roles. Application instances of the application package are upgraded or patched on the data platform based on application package versions. To ensure a proper upgrade or patch, the data platform tracks versions of executing objects of application instances in a call context.
-
公开(公告)号:US11886441B2
公开(公告)日:2024-01-30
申请号:US18052990
申请日:2022-11-07
Applicant: Snowflake Inc.
Inventor: Artin Avanes , Khalid Zaman Bijon , Yujie Li , Zheng Mi , Subramanian Muralidhar , David Schultz
CPC classification number: G06F16/24573 , G06F16/211 , G06F16/212 , G06F16/2291 , G06F16/2365 , G06F16/27 , G06F16/288 , G06F16/289
Abstract: A method of implementing object tagging framework starts with the processor receiving a tag creation command including a tag name. In response to the tag creation command, the processor creates a current tag. The processor then receives an association command, the tag name and a source object identifier. The processor determines a source object associated with the source object identifier. The source object includes a tag value. The processor associates the current tag with the source object. The processor receives a replication command including the source object and a target object. The processor causes replication of the source object to the target object that comprises replicating the current tag with the tag name and the tag value in the source object to the target object. Other embodiments are also described herein.
-
公开(公告)号:US11886419B2
公开(公告)日:2024-01-30
申请号:US18104095
申请日:2023-01-31
Applicant: Snowflake Inc.
Inventor: Durga Mahesh Arikatla , Laxman Mamidi , Subramanian Muralidhar , Chieh-Sheng Wang , Di Wu
CPC classification number: G06F16/2365 , G06F16/27
Abstract: A process of fulfilling a database deployment request for a data platform. A compute service manager of the data platform scans one or more accounts of a consumer region of the data platform for a pending listing fulfillment request, where the pending listing request includes a request for deployment of a consumer database and an associated share of grant metadata of the consumer database within the consumer region. When the compute service manager determines that an account of the one or more accounts has a pending listing fulfillment request, the compute service manager determines a listing for the pending listing fulfillment request based on listing data of the account. The compute service manager determines that no other fulfillment task is scheduled for the pending listing fulfillment request and schedules a background fulfillment task to perform the fulfillment process for the pending listing fulfillment request.
-
公开(公告)号:US11880491B2
公开(公告)日:2024-01-23
申请号:US18161574
申请日:2023-01-30
Applicant: Snowflake Inc.
Inventor: Raja Suresh Krishna Balakrishnan , Khalid Zaman Bijon , Subramanian Muralidhar , David Schultz
IPC: G06F21/62 , G06F16/245 , G06F16/28
CPC classification number: G06F21/6254 , G06F16/245 , G06F16/284
Abstract: Various embodiments provide for tag-based application of a masking policy, which can be used in connection with a data platform. In particular, various embodiments enable enforcement of one or more masking policies against an entity (e.g., object) of a data platform, such as a database, a table, a row, or a column, based on one or more tags associated with the entity.
-
公开(公告)号:US20230418699A1
公开(公告)日:2023-12-28
申请号:US18462044
申请日:2023-09-06
Applicant: Snowflake Inc.
Inventor: Artin Avanes , Thierry Cruanes , Monica J. Holboke , Allison Waingold Lee , Subramanian Muralidhar , David Schultz
IPC: G06F9/54 , G06F21/62 , G06F16/2455
CPC classification number: G06F9/547 , G06F21/6254 , G06F16/2456 , G06F9/541
Abstract: In an embodiment, a data platform creates an application in a data-provider account. The application includes one or more APIs corresponding to one or more underlying code blocks. The data platform shares provider data with the application in the data-provider account, and also installs, in a data-consumer account, an application instance of the application. The application instance includes one or more APIs corresponding to the one or more APIs in the application in the data-provider account. The data platform shares consumer data with the application instance in the data-consumer account, and 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. The data platform also saves output of the one or more respective associated underlying code blocks locally within the data-consumer account.
-
公开(公告)号:US20230401260A1
公开(公告)日:2023-12-14
申请号:US17934814
申请日:2022-09-23
Applicant: Snowflake Inc.
Inventor: Khalid Zaman Bijon , Thierry Cruanes , Simon Holm Jensen , Allison Waingold Lee , Daniel N. Meredith , Subramanian Muralidhar , David Schultz , Zixi Zhang
IPC: G06F16/903
CPC classification number: G06F16/90335
Abstract: A constraint system enforces projection constraints on data values stored in specified columns of a shared dataset when queries are received by a database system. A projection constraint identifies that the data in a column may be restricted from being projected (e.g., presented, read, outputted) in an output to a received query, while allowing specified operations to be performed on the data and a corresponding output to be provided. For example, the projection constraint may indicate a context for a query that triggers the constraint, such as based on the user that submitted the query. Enforcing projection constraints on queries received at the database system allows for data to be shared and used anonymously by entities to perform various operations without the need to tokenize the data.
-
公开(公告)号:US20230401193A1
公开(公告)日:2023-12-14
申请号:US18193069
申请日:2023-03-30
Applicant: Snowflake Inc.
Inventor: Selcuk Aya , Thierry Cruanes , Istvan Cseri , Benoit Dageville , Marcia Feitel , Steven P. Herbert , Xinglian Liu , James Malone , Subramanian Muralidhar , Muthunagappan Muthuraman , Polita Paulus , Marianne Shaw , Nileema Shingte , Wai Sing Wong , Jiaqi Yan
CPC classification number: G06F16/2282 , G06F16/2379 , G06F16/258
Abstract: The subject technology receives a command to commit a table in a different table format on an external volume. The subject technology generates a first snapshot of the table on internal storage. The subject technology generates a first list of metadata files on the internal storage. The subject technology generates, based on the first list of metadata files, a first set of metadata files on the internal storage. The subject technology generates a second snapshot of the table on the external volume. The subject technology generates a second list of metadata files on the external volume. The subject technology generates, based on the second list of metadata files, a second set of metadata files on the external volume. The subject technology generates a first set of data files in a different file format on the external volume.
-
公开(公告)号:US11841875B2
公开(公告)日:2023-12-12
申请号:US18060441
申请日:2022-11-30
Applicant: Snowflake Inc.
Inventor: Pui Kei Johnston Chu , Benoit Dageville , Shreyas Narendra Desai , Khondokar Sami Iqram , Subramanian Muralidhar , Chieh-Sheng Wang , Di Wu
CPC classification number: G06F16/27 , H04L63/0272
Abstract: A network device communication system can configure network devices, such as a first database in a multi-tenant deployment and a second database in a private deployment, to send and receive sequence messages, such as replication data, over a channel comprising a plurality of private network nodes. The first database can create a link specifying the data share and the second database. The second database selects the link and a secure area in the private deployment is created into which data is replicated and shared with further accounts in a computationally secure and efficient manner.
-
-
-
-
-
-
-
-
-