Patents by Inventor German Alberto Gil Echeverri
German Alberto Gil Echeverri has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Publication number: 20240054147Abstract: A method of implementing sub-table replication starts with the processor detecting an update to an entitlements table. The processor performs filtering of a data table based on the update to the entitlements table. The data table including an entitlements column. The processor detects an update to the entitlements column and performs incremental replication of the data table by causing a version-based replication to be executed. Other embodiments are also described herein.Type: ApplicationFiled: October 25, 2023Publication date: February 15, 2024Inventors: Pui Kei Johnston Chu, Shreyas Narendra Desai, German Alberto Gil Echeverri, Prasanna Krishnan, Nithin Mahesh, Subramanian Muralidhar, Eric Robinson, Sahaj Saini
-
Patent number: 11841877Abstract: A method of implementing sub-table replication starts with the processor detecting an update to an entitlements table. The processor performs filtering of a data table based on the update to the entitlements table. The data table including an entitlements column. The processor detects an update to the entitlements column and performs incremental replication of the data table by causing a version-based replication to be executed. Other embodiments are also described herein.Type: GrantFiled: June 21, 2022Date of Patent: December 12, 2023Assignee: Snowflake Inc.Inventors: Pui Kei Johnston Chu, Shreyas Narendra Desai, German Alberto Gil Echeverri, Prasanna Krishnan, Nithin Mahesh, Subramanian Muralidhar, Eric Robinson, Sahaj Saini
-
Publication number: 20230244695Abstract: 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.Type: ApplicationFiled: April 5, 2023Publication date: August 3, 2023Inventors: Pui Kei Johnston Chu, Shreyas Narendra Desai, German Alberto Gil Echeverri, Prasanna Krishnan, Nithin Mahesh, Subramanian Muralidhar, Eric Robinson, Sahaj Saini
-
Publication number: 20230244642Abstract: Provided herein are systems and methods for replicating share objects to remote deployments. An example method includes generating, at a second deployment in a data exchange, a replica of a share object included in a first deployment of the data exchange. The share object grants privileges to a first account to access a first database of the first deployment, wherein the first database comprises a database object. The method also includes retrieving, at the first deployment, share grant metadata from the share object of the first deployment, wherein the share grant metadata includes a reference to the database object and allows the first account to use the database object. The method also includes transmitting a message comprising the share grant metadata to the replica in the second deployment. The share grant metadata in the replica allows a second account to use the database object replicated in the second deployment.Type: ApplicationFiled: April 13, 2023Publication date: August 3, 2023Inventors: Pui Kei Johnston Chu, Benoit Dageville, Shreyas Narendra Desai, German Alberto Gil Echeverri, Prasanna Krishnan, Vishnu Dutt Paladugu, Bowen Zhang
-
Patent number: 11645244Abstract: Provided herein are systems and methods for an efficient method of replicating share objects to remote deployments. An example method includes receiving, at a first deployment in a data exchange, a refresh message from a second deployment in the data exchange, wherein the first deployment comprises a database that stores a database object. The method also includes, in response to receiving the refresh message, retrieving, at the first deployment, a share grant from a share object of the first deployment and transmitting, by a processing device of the first deployment, a message including the share grant to the second deployment. The share grant includes a reference to the database object and allows a consumer to use the database object.Type: GrantFiled: August 25, 2022Date of Patent: May 9, 2023Assignee: Snowflake Inc.Inventors: Pui Kei Johnston Chu, Benoit Dageville, Shreyas Narendra Desai, German Alberto Gil Echeverri, Prasanna Krishnan, Vishnu Dutt Paladugu, Bowen Zhang
-
Patent number: 11640412Abstract: 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.Type: GrantFiled: May 31, 2022Date of Patent: May 2, 2023Assignee: Snowflake Inc.Inventors: Pui Kei Johnston Chu, Shreyas Narendra Desai, German Alberto Gil Echeverri, Prasanna Krishnan, Nithin Mahesh, Subramanian Muralidhar, Eric Robinson, Sahaj Saini
-
Publication number: 20220405252Abstract: Provided herein are systems and methods for an efficient method of replicating share objects to remote deployments. An example method includes receiving, at a first deployment in a data exchange, a refresh message from a second deployment in the data exchange, wherein the first deployment comprises a database that stores a database object. The method also includes, in response to receiving the refresh message, retrieving, at the first deployment, a share grant from a share object of the first deployment and transmitting, by a processing device of the first deployment, a message including the share grant to the second deployment. The share grant includes a reference to the database object and allows a consumer to use the database object.Type: ApplicationFiled: August 25, 2022Publication date: December 22, 2022Inventors: Pui Kei Johnston Chu, Benoit Dageville, Shreyas Narendra Desai, German Alberto Gil Echeverri, Prasanna Krishnan, Vishnu Dutt Paladugu, Bowen Zhang
-
Publication number: 20220318269Abstract: A method of implementing sub-table replication starts with the processor detecting an update to an entitlements table. The processor performs filtering of a data table based on the update to the entitlements table. The data table including an entitlements column. The processor detects an update to the entitlements column and performs incremental replication of the data table by causing a version-based replication to be executed. Other embodiments are also described herein.Type: ApplicationFiled: June 21, 2022Publication date: October 6, 2022Inventors: Pui Kei Johnston Chu, Shreyas Narendra Desai, German Alberto Gil Echeverri, Prasanna Krishnan, Nithin Mahesh, Subramanian Muralidhar, Eric Robinson, Sahaj Saini
-
Patent number: 11461285Abstract: Provided herein are systems and methods for an efficient method of replicating share objects to remote deployments. For example, the method may include generating a global representation of a share object of a first database account located in a first region. The share object includes grant metadata associated with a set of objects of a database located in the first region and associated with the first database account. The method may further include, in response to a database refresh command received from a second database account associated with a database replica located in a second region, replicating the set of objects of the database to the database replica. The method may further include, in response to a share refresh command received from the second database account, replicating the grant metadata to a share object replica located in the second region.Type: GrantFiled: March 14, 2022Date of Patent: October 4, 2022Assignee: Snowflake Inc.Inventors: Pui Kei Johnston Chu, Benoit Dageville, Shreyas Narendra Desai, German Alberto Gil Echeverri, Prasanna Krishnan, Vishnu Dutt Paladugu, Bowen Zhang
-
Publication number: 20220292115Abstract: 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.Type: ApplicationFiled: May 31, 2022Publication date: September 15, 2022Inventors: Pui Kei Johnston Chu, Shreyas Narendra Desai, German Alberto Gil Echeverri, Prasanna Krishnan, Nithin Mahesh, Subramanian Muralidhar, Eric Robinson, Sahaj Saini
-
Patent number: 11436257Abstract: A method of implementing sub-table replication starts with the processor detecting an update to an entitlements table. The processor performs filtering of a data table based on the update to the entitlements table. The data table including an entitlements column. The processor detects an update to the entitlements column and performs incremental replication of the data table by causing a version-based replication to be executed. Other embodiments are also described herein.Type: GrantFiled: June 18, 2021Date of Patent: September 6, 2022Assignee: Snowflake Inc.Inventors: Pui Kei Johnston Chu, Shreyas Narendra Desai, German Alberto Gil Echeverri, Prasanna Krishnan, Nithin Mahesh, Subramanian Muralidhar, Eric Robinson, Sahaj Saini
-
Patent number: 11397751Abstract: A method of implementing sub-table replication starts with the processor detecting an update to an entitlements table. The processor performs filtering of a data table based on the update to the entitlements table. The data table including an entitlements column. The processor detects an update to the entitlements column and performs incremental replication of the data table by causing a version-based replication to be executed. Other embodiments are also described herein.Type: GrantFiled: June 18, 2021Date of Patent: July 26, 2022Assignee: Snowflake Inc.Inventors: Pui Kei Johnston Chu, Shreyas Narendra Desai, German Alberto Gil Echeverri, Prasanna Krishnan, Nithin Mahesh, Subramanian Muralidhar, Eric Robinson, Sahaj Saini
-
Patent number: 11372891Abstract: A method of implementing sub-table replication starts with the processor detecting a first update to an entitlements table. The processor then performs incremental replication of the data table by causing a full inventory replication at a next refresh to be executed for provider accounts associated with the provider account identifiers in the entitlements table. Other embodiments are also described herein.Type: GrantFiled: April 9, 2021Date of Patent: June 28, 2022Assignee: Snowflake Inc.Inventors: Pui Kei Johnston Chu, Shreyas Narendra Desai, German Alberto Gil Echeverri, Prasanna Krishnan, Nithin Mahesh, Subramanian Muralidhar, Eric Robinson, Sahaj Saini
-
Publication number: 20220197872Abstract: Provided herein are systems and methods for an efficient method of replicating share objects to remote deployments. For example, the method may include generating a global representation of a share object of a first database account located in a first region. The share object includes grant metadata associated with a set of objects of a database located in the first region and associated with the first database account. The method may further include, in response to a database refresh command received from a second database account associated with a database replica located in a second region, replicating the set of objects of the database to the database replica. The method may further include, in response to a share refresh command received from the second database account, replicating the grant metadata to a share object replica located in the second region.Type: ApplicationFiled: March 14, 2022Publication date: June 23, 2022Inventors: Pui Kei Johnston Chu, Benoit Dageville, Shreyas Narendra Desai, German Alberto Gil Echeverri, Prasanna Krishnan, Vishnu Dutt Paladugu, Bowen Zhang
-
Patent number: 11294868Abstract: Provided herein are systems and methods for an efficient method of replicating share objects to remote deployments. For example, the method may comprise modifying a share object of a first account of a data exchange into a global object wherein the share object includes grant metadata indicating share grants to a set of objects of a database. The method may further comprise creating, in a second account of the data exchange, a local replica of the share object on the remote deployment based on the global object, wherein the second account is located in a remote deployment. The set of objects of the database may be replicated to a local database replica on the remote deployment and the share grants may be replicated to the local replica of the share object.Type: GrantFiled: August 27, 2021Date of Patent: April 5, 2022Assignee: SNOWFLAKE INC.Inventors: Pui Kei Johnston Chu, Benoit Dageville, Shreyas Narendra Desai, German Alberto Gil Echeverri, Prasanna Krishnan, Vishnu Dutt Paladugu, Bowen Zhang
-
Publication number: 20210390083Abstract: Provided herein are systems and methods for an efficient method of replicating share objects to remote deployments. For example, the method may comprise modifying a share object of a first account of a data exchange into a global object wherein the share object includes grant metadata indicating share grants to a set of objects of a database. The method may further comprise creating, in a second account of the data exchange, a local replica of the share object on the remote deployment based on the global object, wherein the second account is located in a remote deployment. The set of objects of the database may be replicated to a local database replica on the remote deployment and the share grants may be replicated to the local replica of the share object.Type: ApplicationFiled: August 27, 2021Publication date: December 16, 2021Inventors: Pui Kei Johnston Chu, Benoit Dageville, Shreyas Narendra Desai, German Alberto Gil Echeverri, Prasanna Krishnan, Vishnu Dutt Paladugu, Bowen Zhang
-
Publication number: 20210374159Abstract: A method of implementing sub-table replication starts with the processor detecting an update to an entitlements table. The processor performs filtering of a data table based on the update to the entitlements table. The data table including an entitlements column. The processor detects an update to the entitlements column and performs incremental replication of the data table by causing a version-based replication to be executed. Other embodiments are also described herein.Type: ApplicationFiled: June 18, 2021Publication date: December 2, 2021Inventors: Pui Kei Johnston Chu, Shreyas Narendra Desai, German Alberto Gil Echeverri, Prasanna Krishnan, Nithin Mahesh, Subramanian Muralidhar, Eric Robinson, Sahaj Saini
-
Publication number: 20210374158Abstract: A method of implementing sub-table replication starts with the processor detecting a first update to an entitlements table. The processor filters of a data table based on the first update. The processor then detects a second update to the entitlements table and performs incremental replication of the data table by causing a full inventory replication at a next refresh to be executed for provider accounts associated with the provider account identifiers in the entitlements table. Other embodiments are also described herein.Type: ApplicationFiled: April 9, 2021Publication date: December 2, 2021Inventors: Pui Kei Johnston Chu, Shreyas Narendra Desai, German Alberto Gil Echeverri, Prasanna Krishnan, Nithin Mahesh, Subramanian Muralidhar, Eric Robinson, Sahaj Saini
-
Patent number: 11144511Abstract: Provided herein are systems and methods for an efficient method of replicating share objects to remote deployments. For example, the method may comprise modifying a share object of a first account of a data exchange into a global object wherein the share object includes grant metadata indicating share grants to a set of objects of a database. The method may further comprise creating, in a second account of the data exchange, a local replica of the share object on the remote deployment based on the global object, wherein the second account is located in a remote deployment. The set of objects of the database may be replicated to a local database replica on the remote deployment and the share grants may be replicated to the local replica of the share object.Type: GrantFiled: March 5, 2021Date of Patent: October 12, 2021Assignee: Snowflake Inc.Inventors: Pui Kei Johnston Chu, Benoit Dageville, Shreyas Narendra Desai, German Alberto Gil Echeverri, Prasanna Krishnan, Vishnu Dutt Paladugu, Bowen Zhang
-
Patent number: 11055315Abstract: A method of implementing sub-table replication starts with the processor detecting an update to an entitlements table. The processor performs filtering of a data table based on the update to the entitlements table. The data table including an entitlements column. The processor detects an update to the entitlements column and performs incremental replication of the data table by causing a version-based replication to be executed. Other embodiments are also described herein.Type: GrantFiled: July 31, 2020Date of Patent: July 6, 2021Assignee: Snowflake Inc.Inventors: Pui Kei Johnston Chu, Shreyas Narendra Desai, German Alberto Gil Echeverri, Prasanna Krishnan, Nithin Mahesh, Subramanian Muralidhar, Eric Robinson, Sahaj Saini