US 11,055,315 B1
System for implementing sub-database replication
Pui Kei Johnston Chu, San Mateo, CA (US); Shreyas Narendra Desai, Bellevue, WA (US); German Alberto Gil Echeverri, San Francisco, CA (US); Prasanna Krishnan, Palo Alto, CA (US); Nithin Mahesh, Redmond, WA (US); Subramanian Muralidhar, Mercer Island, WA (US); Eric Robinson, Sammamish, WA (US); and Sahaj Saini, Seattle, WA (US)
Assigned to Snowflake Inc., San Mateo, CA (US)
Filed by Snowflake Inc., San Mateo, CA (US)
Filed on Jul. 31, 2020, as Appl. No. 16/944,988.
Claims priority of provisional application 63/032,163, filed on May 29, 2020.
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/27 (2019.01); G06F 16/23 (2019.01); G06Q 30/02 (2012.01); G06Q 30/00 (2012.01); G06F 16/22 (2019.01)
CPC G06F 16/275 (2019.01) [G06F 16/2282 (2019.01); G06F 16/2379 (2019.01); G06Q 30/0185 (2013.01); G06Q 30/0205 (2013.01)] 30 Claims
OG exemplary drawing
 
1. A method of implementing sub-table replication comprising:
detecting, by a processor, an update to an entitlements table,
the entitlements table comprising a plurality of entitlements table rows, the entitlements table rows being associated with a plurality of client identifiers, a plurality of consumer account identifiers, and a plurality of provider account identifiers,
the update to the entitlements table being associated with a first entitlements table row of the entitlement table rows, the update to the entitlements table including a first client identifier of the client identifiers, a first consumer account identifier of the consumer account identifiers, or a first provider account identifier of the provider account identifiers;
performing filtering of a data table based on the update to the entitlements table, the data table comprising a plurality of data table rows associated the client identifiers and including an entitlements column and data content, the entitlements column including the provider account identifiers;
detecting an update to the entitlements column; and
performing incremental replication of the data table by causing a version-based replication to be executed.