CREATING A GLOBAL DATA SHARING LISTING

    公开(公告)号:US20210320968A1

    公开(公告)日:2021-10-14

    申请号:US17244616

    申请日:2021-04-29

    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 creating a listing in a data exchange, the listing including a data set hosted by a first cloud computing entity. The data set can be shared with a second cloud computing entity. The method further includes receiving a request associated with a customer account of the second cloud computing entity to access the data set of the listing hosted by the first cloud computing entity and replicating at least a subset of the data set of the listing from the first cloud computing entity to a provider account at the second cloud computing entity to be accessible by the customer account at the second cloud computing entity

    Task scheduling in database systems
    185.
    发明授权

    公开(公告)号:US11106658B2

    公开(公告)日:2021-08-31

    申请号:US16203322

    申请日:2018-11-28

    Applicant: Snowflake Inc.

    Abstract: Systems, methods, and devices for executing a task on database data in response to a trigger event are disclosed. A method includes executing a transaction on a table comprising database data, wherein executing the transaction comprises generating a new table version. The method includes, in response to the transaction being fully executed, generating a change tracking entry comprising an indication of one or more modifications made to the table by the transaction and storing the change tracking entry in a change tracking stream. The method includes executing a task on the new table version in response to a trigger event.

    System and method for global data sharing

    公开(公告)号:US11082483B1

    公开(公告)日:2021-08-03

    申请号:US17220887

    申请日:2021-04-01

    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.

    TRACKING INTERMEDIATE CHANGES IN DATABASE DATA

    公开(公告)号:US20210216535A1

    公开(公告)日:2021-07-15

    申请号:US17219600

    申请日:2021-03-31

    Applicant: Snowflake Inc.

    Abstract: Systems, methods, and devices for tracking a series of changes to database data are disclosed. A method includes executing a transaction to modify data in a micro-partition of a table of a database by generating a new micro-partition that embodies the transaction. The method includes associating transaction data with the new micro-partition, wherein the transaction data comprises a timestamp when the transaction was fully executed, and further includes associating modification data with the new micro-partition that comprises an indication of one or more rows of the table that were modified by the transaction. The method includes joining the transaction data with the modification data to generate joined data and querying the joined data to determine a listing of intermediate modifications made to the table between a first timestamp and a second timestamp.

Patent Agency Ranking