-
公开(公告)号:US11487778B1
公开(公告)日:2022-11-01
申请号:US17649571
申请日:2022-02-01
Applicant: Snowflake Inc.
Abstract: Provided herein are systems and methods for configuring managed event tables. A system includes at least one hardware processor coupled to a memory and configured to collect using an event table instance within a sandbox process, log data generated by a UDF during execution of the UDF code. The log data is provided from the sandbox process to an execution node process of the execution node. The log data is formatted using the execution node process, to generate formatted log data. The formatting is based on a configuration of a managed event table that is external to the execution node. The at least one hardware processor further causes ingestion of the formatted log data from the execution node process into the managed event table.
-
公开(公告)号:US20250086193A1
公开(公告)日:2025-03-13
申请号:US18954797
申请日:2024-11-21
Applicant: Snowflake inc.
Abstract: Techniques for configuring a managed event table (MET) include detecting, by at least one hardware processor, a query for the MET. The query received at a first computing node of a network-based database system. The method includes retrieving via an ingestion function configured at the first computing node, reformatted data from a dedicated storage location of a first process into the MET. The reformatted data is based on log data associated with a second process. The first process and the second process are executing at a second computing node of the network-based database system. The method includes processing the query using the reformatted data in the MET.
-
公开(公告)号:US12182155B2
公开(公告)日:2024-12-31
申请号:US18302515
申请日:2023-04-18
Applicant: Snowflake Inc.
Abstract: Techniques for configuring event tables include retrieving, by at least one hardware processor of a computing node, log data at a first process of the computing node. The log data is associated with a function executing at a second process of the computing node. The log data is revised using a table stage to generate revised log data. The table stage is configured as a dedicated storage location of the first process. The revising includes a data enrichment process based on metadata associated with execution of the function at the second process. The revised log data is ingested into an event table.
-
公开(公告)号:US20240281557A1
公开(公告)日:2024-08-22
申请号:US18652655
申请日:2024-05-01
Applicant: SNOWFLAKE INC.
Inventor: Damien Carru , Jeremy Yujui Chen , Pui Kei Johnston Chu , Thierry Cruanes , Istvan Cseri , Benoit Dageville , Unmesh Jagtap , Subramanian Muralidhar
CPC classification number: G06F21/6227 , G06F9/44505 , G06Q30/06 , G06F2221/2141
Abstract: Embodiments of the present disclosure related to sharing applications within a data sharing platform. An example method includes replicating a database from a provider account of a data sharing platform to a consumer account of the data sharing platform. The method further includes executing an installation script within the consumer account to install an application in the consumer account of the data sharing platform responsive to the replicating. The method further includes creating, by a processing device, a set of database roles to manage execution of the application in the consumer account, wherein one or more of the set of database roles determine access privileges granted to the application for accessing the database inside the consumer account. The application is to perform a data processing service relative to a data asset in the database.
-
公开(公告)号:US20240281245A1
公开(公告)日:2024-08-22
申请号:US18470585
申请日:2023-09-20
Applicant: Snowflake Inc.
Inventor: Damien Carru , Jeremy Yujui Chen , Pui Kei Johnston Chu , Benoit Dageville , Scott C. Gray , Unmesh Jagtap , Subramanian Muralidhar
CPC classification number: G06F8/71 , G06F8/658 , G06F9/4488
Abstract: Methodologies for upgrading and patching an in-database application package and its application instances. A data platform determines a number of objects of an application instance running on the data platform at a previous version level of an application package of the application instance. In response to determining the number of objects of the application package running on the data platform at the previous version level of the application package is one or more, the data platform continues determining the number of objects running on the data platform at a previous version level of the application package. In response to determining the number of objects of the application instance running on the data platform at the previous version level of the application package is none, the data platform upgrades the application instance to the new version of the application package.
-
公开(公告)号:US20240163316A1
公开(公告)日:2024-05-16
申请号:US18423012
申请日:2024-01-25
Applicant: Snowflake Inc.
Inventor: Jeremy Yujui Chen , Unmesh Jagtap , William A. Pugh , Brian Smith , Xu Xu
IPC: H04L9/40
CPC classification number: H04L63/20
Abstract: A data platform for developing and deploying a user application within a unified security context. The data platform authorizes a first user to use an editor to access source code of a user application based on security policies of a security context and authorizes the first user to use an application and data manager to set usage privileges for a second user to use the user application based on the security policies of the security context. To provide the user application to the second user, the data platform deploys the user application by instantiating a User Defined Function (UDF) server and an application engine of the UDF server within the security context, instantiating the user application as an application of the application engine within the security context, and authorizing access by the user application to databased on the security policies of the security context.
-
公开(公告)号:US20230403306A1
公开(公告)日:2023-12-14
申请号:US18053956
申请日:2022-11-09
Applicant: Snowflake Inc.
Inventor: Jeremy Yujui Chen , Unmesh Jagtap , William A. Pugh , Brian Smith , Xu Xu
IPC: H04L9/40
CPC classification number: H04L63/20
Abstract: A data platform for developing and deploying a user application within a unified security context. The data platform authorizes a first user to use an editor to access source code of a user application based on security policies of a security context and authorizes the first user to use an application and data manager to set usage privileges for a second user to use the user application based on the security policies of the security context. To provide the user application to the second user, the data platform deploys the user application by instantiating a User Defined Function (UDF) server and an application engine of the UDF server within the security context, instantiating the user application as an application of the application engine within the security context, and authorizing access by the user application to databased on the security policies of the security context.
-
公开(公告)号:US20230401326A1
公开(公告)日:2023-12-14
申请号:US18187031
申请日:2023-03-21
Applicant: Snowflake Inc.
Inventor: Damien Carru , Jeremy Yujui Chen , Pui Kei Johnston Chu , Scott C. Gray , Unmesh Jagtap , Mohamad Raja Gani Mohamad Abdul , William A. Pugh , Ahmed Waseef Shawkat , Xu Xu
CPC classification number: G06F21/6218 , G06F21/604 , G06F2221/2141 , G06F2221/2113
Abstract: A data platform for managing an application as a first-class database object. The data object can include User Interface (UI) components. The data application can be shared by a provider account to a plurality of consumer accounts using a share object and based on grant commands. The consumer accounts can deploy and operate the UI component based on the share object.
-
公开(公告)号:US11755311B1
公开(公告)日:2023-09-12
申请号:US18169823
申请日:2023-02-15
Applicant: Snowflake Inc.
Inventor: Damien Carru , Benoit Dageville , Unmesh Jagtap , Subramanian Muralidhar , Jan Michael Timmerman
CPC classification number: G06F8/65 , G06F16/219
Abstract: A versioned schema of a data platform. A process of maintaining a call stack of executing objects of an application package having a versioned schema includes calling, by a first procedure executed by one or more processors, a second procedure of a versioned application instance, and determining, by the first procedure, a version of the second procedure based on a call context. In response to determining that the version of the second procedure is not in the call context, the first procedure determines a current version of the versioned application package adds the current version to the call context as the version of the second procedure.
-
公开(公告)号:US11750661B1
公开(公告)日:2023-09-05
申请号:US17934899
申请日:2022-09-23
Applicant: Snowflake Inc.
Inventor: Damien Carru , Jeremy Yujui Chen , Timothy S. Conkling , Thierry Cruanes , Benoit Dageville , Unmesh Jagtap , William A. Pugh , Shrikant Ravindra Shanbhag , Xu Xu
IPC: H04L9/40 , G06F16/955
CPC classification number: H04L63/20 , G06F16/955 , H04L63/102
Abstract: A data platform for managing an application as a first-class database object. The data platform includes at least one processor and a memory storing instructions that cause the at least one processor to perform operations including detecting a data request from a browser for a data object located on the data platform, executing a stored procedure, the stored procedure containing instructions that cause the at least one processor to perform additional operations including instantiating a User Defined Function (UDF) server, an application engine, and the application within a security context of the data platform based on a security policy determined by an owner of the data object. The data platform then communicates with the browser using the application engine as a proxy server.
-
-
-
-
-
-
-
-
-