US 12,235,874 B2
Cross-organization and cross-cloud automated data pipelines
Tyler Arthur Akidau, Seattle, WA (US); Istvan Cseri, Seattle, WA (US); Tyler Jones, Redwood City, CA (US); Dinesh Chandrakant Kulkarni, Sammamish, WA (US); Daniel Mills, Seattle, WA (US); Daniel E. Sotolongo, Seattle, WA (US); and Di Fei Zhang, Redmond, WA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Mar. 20, 2024, as Appl. No. 18/610,863.
Application 18/610,863 is a continuation of application No. 18/103,977, filed on Jan. 31, 2023, granted, now 11,966,416.
Application 18/103,977 is a continuation of application No. 17/657,497, filed on Mar. 31, 2022, granted, now 11,620,310.
Prior Publication US 2024/0232224 A1, Jul. 11, 2024
Int. Cl. G06F 16/00 (2019.01); G06F 16/27 (2019.01)
CPC G06F 16/273 (2019.01) 18 Claims
OG exemplary drawing
 
1. A method comprising:
storing a table in a first account using one or more data storage devices in a first deployment of a multi-tenant network database system;
generating a secure view of the table;
sharing the secure view with a second account associated with a second deployment of the multi-tenant network database system, the secure view limiting access of at least a portion of the table to the second account;
replicating, by a refresh component in the second deployment, the secure view to generate a replicated secure view for use by the second account;
detecting, by the refresh component, a transaction executed on the table by the first account;
triggering, by the refresh component, a task in the second account based on detecting the transaction, the task being defined by a gate clause;
determining the gate clause in the task is satisfied based on change data capture information for the secure view; and
in response to determining that the gate clause is satisfied, executing the task to update the replicated secure view.