Secure message exchange between deployments

    公开(公告)号:US10938780B1

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

    申请号:US16809209

    申请日:2020-03-04

    Applicant: Snowflake Inc.

    Abstract: Different database deployments, or other data system deployments, may want to communicate with each other without sacrificing security or control. To this end, embodiments of the present disclosure may provide secure message exchange techniques for a source and/or target deployment. Configurable rule sets may be stored in the deployments; the rule sets may define what messages may be communicated between deployments. The deployments may implement a selective filtering scheme in one or more stages based on the rule sets to filter outgoing and/or incoming messages.

    STORING DATABASE METADATA IN MULTIPLE LEVELS

    公开(公告)号:US20210019334A1

    公开(公告)日:2021-01-21

    申请号:US17062859

    申请日:2020-10-05

    Applicant: Snowflake Inc.

    Abstract: The subject technology stores database data in a table, the table comprising a plurality of micro-partitions each having rows and columns. The subject technology stores metadata for the table in a data structure, the metadata comprising a first level of the data structure comprising a column expression property comprising information about data stored in a column of a micro-partition of the table, a micro-partition expression property comprising information about data stored in the micro-partition of the table, and a second level of the data structure comprising a grouping expression property comprising information about data stored in the micro-partition and one or more additional micro-partitions of the table.

    MANAGING NETWORK CONNECTIONS BASED ON THEIR ENDPOINTS

    公开(公告)号:US20210014281A1

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

    申请号:US17035354

    申请日:2020-09-28

    Applicant: SNOWFLAKE INC.

    Abstract: The disclosure relates generally to methods, systems, and apparatuses for managing network connections. A system for managing network connections includes a storage component, a decoding component, a rule manager component, and a notification component. The storage component is configured to store a list of expected connections for a plurality of networked machines, wherein each connection in the list of expected connections defines a start point and an end point for the connection. The decoding component is configured to decode messages from the plurality of networked machines indicating one or more connections for a corresponding machine. The rule manager component is configured to identify an unexpected presence or absence of a connection on at least one of the plurality of network machines based on the list of expected connections. The notification component is configured to provide a notification or indication of the unexpected presence or absence.

    Flexible computing
    277.
    发明授权

    公开(公告)号:US10860381B1

    公开(公告)日:2020-12-08

    申请号:US16874388

    申请日:2020-05-14

    Applicant: Snowflake Inc.

    Abstract: Embodiments of the present disclosure may provide dynamic and fair assignment techniques for allocating resources on a demand basis. Assignment control may be separated into at least two components: a local component and a global component. Each component may have an active dialog with each other; the dialog may include two aspects: 1) a demand for computing resources, and 2) a total allowed number of computing resources. The global component may allocate resources from a pool of resources to different local components, and the local components in turn may assign their allocated resources to local competing requests. The allocation may also be throttled or limited at various levels.

    MANAGING VERSIONS OF DATABASE METADATA IN STORAGE

    公开(公告)号:US20200327115A1

    公开(公告)日:2020-10-15

    申请号:US16915435

    申请日:2020-06-29

    Applicant: Snowflake Inc.

    Abstract: A method for a database system includes storing table data for a database, the table data including information in rows and columns of one or more database tables. The method includes storing metadata on immutable storage, the metadata including information about the table data for the database. In one embodiment, mutable metadata may be periodically consolidated in the background to create new versions of metadata files and which allows for deletions of old metadata files and old data files.

    Managing membership in a private data exchange

    公开(公告)号:US10798100B1

    公开(公告)日:2020-10-06

    申请号:US16746758

    申请日:2020-01-17

    Applicant: Snowflake Inc.

    Abstract: Systems and methods for managing membership in a private data exchange are provided herein. In one embodiment, the method comprises adding a new member to a data exchange, wherein the data exchange comprises a set of listings, each listing comprising data from one or more datasets stored on a cloud computing service. An account type is assigned to the new member, the account type comprising at least one of a consumer type, provider type, or exchange administrator type. Each of the account types associated with one or more rights with respect to the set of listings, such that the new member has a set of rights based on the account type. The set of rights of the new member are then modified with respect to one or more listings from the set of listings based on a set of visibility and access rules for each of the set of listings.

Patent Agency Ranking