-
公开(公告)号：US11086840B2
公开(公告)日：2021-08-10
申请号：US16213554
申请日：2018-12-07
Applicant: Snowflake Inc.
Inventor： Subramanian Muralidhar , Istvan Cseri , Torsten Grabs , Benoit Dageville
IPC: G06F16/23 , G06F16/27 , G06F16/245 , G06F9/46 , G06F16/18
Abstract: Systems, methods, and devices for generating a transactional change tracking summary for a database. A method includes executing a transaction on a table of a database, wherein the table includes a micro-partition and the transaction is executed on the micro-partition. The method includes, in response to the transaction being fully executed, generating a change tracking entry comprising an indication of one or modifications made to the table by the transaction. The method includes storing the change tracking entry in a change tracking stream, wherein the change tracking stream includes one or more sequential change tracking entries that each correspond to a different transaction that is fully executed on the table.
-
公开(公告)号：US10997210B1
公开(公告)日：2021-05-04
申请号：US16944983
申请日：2020-07-31
Applicant: Snowflake Inc.
Inventor： Pui Kei Johnston Chu , Shreyas Narendra Desai , German Alberto Gil Echeverri , Prasanna Krishnan , Nithin Mahesh , Subramanian Muralidhar , Eric Robinson , Sahaj Saini
Abstract: 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.
-
公开(公告)号：US10997165B2
公开(公告)日：2021-05-04
申请号：US16842942
申请日：2020-04-08
Applicant: Snowflake Inc.
Inventor： Subramanian Muralidhar , Benoit Dageville , Thierry Cruanes , Nileema Shingte , Saurin Shah , Torsten Grabs , Istvan Cseri
Abstract: Systems, methods, and devices for automated maintenance of external tables in database systems are disclosed. A method includes receiving, by a database platform, read access to content in an external data storage platform that is separate from the database platform. The method includes defining an external table based on the content in the external data storage platform. The method includes connecting the database platform to the external table such that the database platform has read access for the external table and does not have write access for the external table. The method includes generating metadata for the external table, the metadata comprising information about data stored in the external table. The method includes receiving a notification that a modification has been made to the content in the external data storage platform, the modification comprising one or more of an addition of a file, a deletion of a file, or an update to a file in a source location for the external table. The method includes refreshing the metadata for the external table in response to the modification being made to the content in the external data storage platform.
-
公开(公告)号：US20200334240A1
公开(公告)日：2020-10-22
申请号：US16385837
申请日：2019-04-16
Applicant: Snowflake Inc.
Inventor： Subramanian Muralidhar , Benoit Dageville , Thierry Cruanes , Nileema Shingte , Saurin Shah , Torsten Grabs , Istvan Cseri
Abstract: Systems, methods, and devices for automated maintenance of external tables in database systems are disclosed. A method includes receiving, by a database platform, read access to content in an external data storage platform that is separate from the database platform. The method includes defining an external table based on the content in the external data storage platform. The method includes connecting the database platform to the external table such that the database platform has read access for the external table and does not have write access for the external table. The method includes generating metadata for the external table, the metadata comprising information about data stored in the external table. The method includes receiving a notification that a modification has been made to the content in the external data storage platform, the modification comprising one or more of an addition of a file, a deletion of a file, or an update to a file in a source location for the external table. The method includes refreshing the metadata for the external table in response to the modification being made to the content in the external data storage platform.
-
公开(公告)号：US20200183909A1
公开(公告)日：2020-06-11
申请号：US16705566
申请日：2019-12-06
Applicant: Snowflake Inc.
Inventor： Subramanian Muralidhar , Istvan Cseri , Torsten Grabs , Benoit Dageville
IPC: G06F16/23 , G06F16/27 , G06F16/18 , G06F16/245
Abstract: Systems, methods, and devices for generating a transactional change tracking summary for a database. A method includes executing a transaction on a table of a database, wherein the table includes a micro-partition and the transaction is executed on the micro-partition. The method includes, in response to the transaction being fully executed, generating a change tracking entry comprising an indication of one or modifications made to the table by the transaction. The method includes storing the change tracking entry in a change tracking stream, wherein the change tracking stream includes one or more sequential change tracking entries that each correspond to a different transaction that is fully executed on the table
-
Patent Agency Ranking
公开(公告)号：US12218948B1
公开(公告)日：2025-02-04
申请号：US18409507
申请日：2024-01-10
Applicant: Snowflake Inc.
Inventor： Christine A. Avanessians , Damien Carru , Ramachandran Natarajan Iyer , Dennis Edgar Lynch , Subramanian Muralidhar
IPC: H04L9/40
Abstract: Systems and methods for an organization-level account for an organization on a data platform, users of which can possess administrative or management privileges with respect to the organization and across one or more others accounts of the organization.
-
公开(公告)号：US20250023880A1
公开(公告)日：2025-01-16
申请号：US18424469
申请日：2024-01-26
Applicant: Snowflake Inc.
Inventor： Christine A. Avanessians , Damien Carru , Ramachandran Natarajan Iyer , Dennis Edgar Lynch , Subramanian Muralidhar
IPC: H04L9/40
Abstract: Systems and methods for an organization-level account for an organization on a data platform, users of which can possess administrative or management privileges with respect to the organization and across one or more others accounts of the organization.
-
公开(公告)号：US20250013663A1
公开(公告)日：2025-01-09
申请号：US18897473
申请日：2024-09-26
Applicant: Snowflake Inc.
Inventor： Durga Mahesh Arikatla , Subramanian Muralidhar , Vishnu Dutt Paladugu , Shakhina Pulatova , Di Wu , Ziqi Xu
IPC: G06F16/27 , G06Q30/0201 , G06Q30/0601
Abstract: A data dictionary generation system automatically populates and updates a data dictionary for listings offering shared data. The data listing distribution component distributes the data dictionaries to various remote deployments in a data exchange by using a global messaging framework and replication method. For example, the data listing distribution component replicates a data dictionary generated for the listing and its shared data from a source deployment to one or more destination deployments associated with various geographic regions. The data listing distribution component distributes the listing to the various remote deployments to allow for the listing, including its shared data and data dictionary, to be accessed by users within the geographic region associated with the remote deployment.
-
公开(公告)号：US20240394395A1
公开(公告)日：2024-11-28
申请号：US18787930
申请日：2024-07-29
Applicant: Snowflake Inc.
Inventor： Damien Carru , Pui Kei Johnston Chu , Benoit Dageville , Shreyas Narendra Desai , Subramanian Muralidhar , Bowen Zhang
Abstract: Embodiments of the present disclosure relate to sharing data using database roles. Database roles are generated within a database container of a provider account. Grants to a particular subset of the plurality of data objects of the database container may be assigned to each of the database roles, and each of the database roles are granted to a share object. The share object is mounted within a consumer account to generate an imported copy of each of the database roles. The imported copy of one or more of the database roles is granted to each of one or more account level roles of the consumer account. When a new object is added to a particular database role, it is immediately available for consumption by any account level roles to which the imported copy of the particular database role has been granted.
-
公开(公告)号：US12105831B2
公开(公告)日：2024-10-01
申请号：US18475403
申请日：2023-09-27
Applicant: Snowflake Inc.
Inventor： Raja Suresh Krishna Balakrishnan , Khalid Zaman Bijon , Subramanian Muralidhar , David Schultz , Jian Xu
CPC classification number: G06F21/6227 , G06F2221/2141
Abstract: Systems and methods for managing column hiding are provided. The systems and methods receive, from a client device, a query associated with a table. The systems and methods determine an access restriction associated with the client device. The systems and methods identify a column of the table that is restricted by the access restriction associated with the client device. In response to identifying the column of the table that is restricted by the access restriction associated with the client device, the systems and methods provide a result of the query that excludes data corresponding to the column.
-
-
-
-
-
-
-
-
-
Search Results
264
records
(took 0.019 seconds)
