Snowflake has filed a patent for techniques that enable triggering pipeline execution based on data changes. The pipelines can be used for data ingestion or other specified tasks and can span account, organization, cloud region, and cloud provider boundaries. The method involves storing a table, generating a secure view, sharing the view with another account, capturing change data, creating a task with a gate clause, determining if the gate clause is satisfied, and executing the task to update the secure view. GlobalData’s report on Snowflake gives a 360-degree view of the company including its patenting strategy. Buy the report here.
According to GlobalData’s company profile on Snowflake, Social media analytics was a key innovation area identified from patents. Snowflake's grant share as of September 2023 was 66%. Grant share is based on the ratio of number of grants to total number of patents.
Triggering pipeline execution based on data change

A recently filed patent (Publication Number: US20230315755A1) describes a method for managing data in a multi-tenant network database system. The method involves storing a table in a first account of the system and generating a secure view of the table. This secure view is then shared with a second account in the same system. Change data capture information is generated to track any changes made to the secure view in the second account based on operations performed on the table.
The method also includes creating a task in the second account, which is defined by a gate clause. The gate clause is evaluated based on the change data capture information for the secure view. If the gate clause is satisfied, the task is executed to update the secure view. The task can be triggered based on commit-processing of the operations performed on the table.
The patent further describes the relationship between the first and second accounts. They can be part of a single deployment of the multi-tenant network database system or different deployments. In the case of different deployments, a refresh processing element is provided in the second deployment. The secure view references this refresh processing element, which triggers the execution of the second task.
Additionally, the method involves maintaining a list of tasks that reference the table. This allows for efficient management and tracking of tasks related to the secure view.
The secure view created in the method restricts access by the second account to a subset of data in the table. This ensures that the second account only has access to the relevant and authorized information.
In summary, the patent describes a method for managing data in a multi-tenant network database system. It involves storing a table, generating a secure view, sharing the secure view, tracking changes to the secure view, creating and executing tasks based on gate clauses, and maintaining a list of tasks. The method provides a secure and efficient way to manage data in a multi-tenant environment.
To know more about GlobalData’s detailed insights on Snowflake, buy the report here.
Data Insights
From
The gold standard of business intelligence.
Blending expert knowledge with cutting-edge technology, GlobalData’s unrivalled proprietary data will enable you to decode what’s happening in your market. You can make better informed decisions and gain a future-proof advantage over your competitors.