Snowflake inc. (20240403323). MATERIALIZED VIEW SUB-DATABASE REPLICATION

MATERIALIZED VIEW SUB-DATABASE REPLICATION

Organization Name

snowflake inc.

Inventor(s)

Pui Kei Johnston Chu of Richmond Hill (CA)

Shreyas Narendra Desai of Bellevue WA (US)

German Alberto Gil Echeverri of San Francisco CA (US)

Prasanna Krishnan of Palo Alto CA (US)

Nithin Mahesh of Redmond WA (US)

Subramanian Muralidhar of Mercer Island WA (US)

Eric Robinson of Sammamich WA (US)

Sahaj Saini of Seattle WA (US)

MATERIALIZED VIEW SUB-DATABASE REPLICATION

This abstract first appeared for US patent application 20240403323 titled 'MATERIALIZED VIEW SUB-DATABASE REPLICATION

Original Abstract Submitted

a system for sub-table replication within a materialized view of a source data table. a materialized view of a source data table is generated based on a query, the source data table having a plurality of data table rows associated with a plurality of client identifiers and including an entitlements column and data content, the entitlements column including a plurality of provider account identifiers and a plurality of consumer account identifiers. an update to an entitlements table of the source data table is detected where the entitlements table includes a plurality of entitlements table rows and where the entitlements table rows are associated with the client identifiers, the consumer account identifiers, and the provider account identifiers. an update to the source data table based on the first update to the entitlements table is detected, and an incremental replication of the materialized view of the source data table is performed.