Managed event tables in a database system

    公开(公告)号:US11487778B1

    公开(公告)日:2022-11-01

    申请号:US17649571

    申请日:2022-02-01

    Applicant: Snowflake Inc.

    Abstract: Provided herein are systems and methods for configuring managed event tables. A system includes at least one hardware processor coupled to a memory and configured to collect using an event table instance within a sandbox process, log data generated by a UDF during execution of the UDF code. The log data is provided from the sandbox process to an execution node process of the execution node. The log data is formatted using the execution node process, to generate formatted log data. The formatting is based on a configuration of a managed event table that is external to the execution node. The at least one hardware processor further causes ingestion of the formatted log data from the execution node process into the managed event table.

    TABLE DATA PROCESSING USING A CHANGE TRACKING COLUMN

    公开(公告)号:US20220327107A1

    公开(公告)日:2022-10-13

    申请号:US17809203

    申请日:2022-06-27

    Applicant: Snowflake Inc.

    Abstract: A system includes one or more processors and data storage containing instructions executable by the one or more processors to perform operations. The operations include detecting a first executed transaction causing a first modification to table data stored in a table. The table data is associated with a corresponding metadata file with metadata information of the table. A new metadata file is generated responsive to the first executed transaction. The new metadata file includes the metadata information and additional metadata associated with the first modification. A second executed transaction causing a second modification to the table data is detected. The table data is updated with a change tracking column. The change tracking column includes lineage of executed transactions on the table data. The lineage indicates at least the first transaction and the second transaction.

    System and method for global data sharing

    公开(公告)号:US11463508B1

    公开(公告)日:2022-10-04

    申请号:US17858645

    申请日:2022-07-06

    Applicant: SNOWFLAKE INC.

    Abstract: Sharing data in a data exchange across multiple cloud computing platforms and/or cloud computing platform regions is described. An example computer-implemented method can include receiving data sharing information from a data provider for sharing a data set in a data exchange from a first cloud computing entity to a set of second cloud computing entities. In response to receiving the data sharing information, the method may also include creating an account with each of the set of second cloud computing entities. The method may also further include sharing the data set from the first cloud computing entity with the set of second cloud computing entities using at least the corresponding account of that second cloud computing entity.

    Incremental refresh of a materialized view

    公开(公告)号:US11461309B2

    公开(公告)日:2022-10-04

    申请号:US17238539

    申请日:2021-04-23

    Applicant: Snowflake Inc.

    Abstract: Systems, methods, and devices for incrementally refreshing a materialized view are disclosed. A method includes generating a materialized view based on a source table. The method includes merging the source table and the materialized view to generate a merged table to identify whether an update has been executed on the source table that is not reflected in the materialized view. The method includes, in response to detecting an update made to the source table that is not reflected in the materialized view, applying the update to the materialized view.

    DATABASE CONFIGURATIONS FOR REMOTE DEPLOYMENTS

    公开(公告)号:US20220300533A1

    公开(公告)日:2022-09-22

    申请号:US17662963

    申请日:2022-05-11

    Applicant: Snowflake Inc.

    Abstract: Techniques for database configurations for remote deployments include a method performed by a data platform executing instructions on at least one processor. The method includes provisioning by at least one hardware processor, a remote deployment of a data platform with a plurality of objects. The plurality of objects includes at least one task object associated with a primary deployment of the data platform. The method further includes detecting using the at least one task object of the plurality of objects, a request to replicate a database stored at the primary deployment of the data platform at the remote deployment. Responsive to the request, database data is pushed from the database stored at the primary deployment to at least a second object of the plurality of objects provisioned at the remote deployment.

    PRUNING INDEX GENERATION AND ENHANCEMENT

    公开(公告)号:US20220277013A1

    公开(公告)日:2022-09-01

    申请号:US17654887

    申请日:2022-03-15

    Applicant: Snowflake Inc.

    Abstract: A source table organized into a set of micro-partitions is accessed by a network-based data warehouse. A pruning index is generated based on the source table. The pruning index comprises a set of filters that indicate locations of distinct values in each column of the source table. A query directed at the source table is received at the network-based data warehouse. The query is processed using the pruning index. The processing of the query comprises pruning the set of micro-partitions of the source table to scan for data matching the query, the pruning of the plurality of micro-partitions comprising identifying, using the pruning index, a sub-set of micro-partitions to scan for the data matching the query.

Patent Agency Ranking