The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Sep. 17, 2024
Filed:
Apr. 05, 2023
Snowflake Inc., Bozeman, MT (US);
Pui Kei Johnston Chu, Richmond Hill, CA;
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);
Sahaj Saini, Seattle, WA (US);
Snowflake Inc., Bozeman, MT (US);
Abstract
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.