DIRECTING REQUESTS TO DATABASES BASED ON CLIENT ACCOUNT ASSOCIATION

    公开(公告)号:US20250053576A1

    公开(公告)日:2025-02-13

    申请号:US18931781

    申请日:2024-10-30

    Applicant: Snowflake Inc.

    Abstract: Systems of methods of directing requests to databases based on client account association is disclosed. A method includes determining a first client account associated with a first request to perform a first transaction. The method includes determining a second client account associated with a second request to perform a second transaction. The method includes selecting, for the first request, a primary deployment that stores a first dataset responsive to determining the first client account associated with the first request. The method includes selecting, for the second request, a secondary deployment that stores a second dataset that includes the first dataset responsive to determining the second client account associated with the second request. The method includes executing, while the primary deployment and the secondary deployment are both available, the first transaction on the first dataset at the primary deployment and the second transaction on the second dataset at the secondary deployment.

    TASK EXECUTION USING A STREAM OF COMMITTED TRANSACTIONS

    公开(公告)号:US20250045274A1

    公开(公告)日:2025-02-06

    申请号:US18920733

    申请日:2024-10-18

    Applicant: Snowflake Inc.

    Abstract: A method includes ingesting, by at least one hardware processor, database data within a staging table of a database. The method further includes generating a task based on at least one data processing statement received from a user account. The method further includes executing the task on the database data in the staging table to generate modified data. The method further includes, in response to the task being fully executed on the database data, storing the modified data in a target table. In some aspects, the target table is configured within the database. The method further includes generating a stream of one or more transactions committed during the execution of the task to generate the modified data.

    Data exchange availability, listing visibility, and listing fulfillment

    公开(公告)号:US12182160B2

    公开(公告)日:2024-12-31

    申请号:US16994325

    申请日:2020-08-14

    Applicant: SNOWFLAKE INC.

    Abstract: Provided herein are systems and methods for providing a secure and efficient way to manage a data exchange's availability and manage the visibility of data listings of the data exchange. For example, the method may comprise specifying, by an exchange admin of the data exchange, a set of regions where the data exchange is available, each of the set of regions comprising one or more remote deployments. The method may further comprise specifying by a data provider, one or more of the set of regions where a data listing owned by the data provider is visible. Upon receiving a request to access the data listing from a remote deployment of the one or more regions, the data provider may determine whether to reject or fulfill the request. In response to determining that the request should be fulfilled, replicating data of the data listing to the remote deployment.

    Configuring an event table using computing node processes

    公开(公告)号:US12182155B2

    公开(公告)日:2024-12-31

    申请号:US18302515

    申请日:2023-04-18

    Applicant: Snowflake Inc.

    Abstract: Techniques for configuring event tables include retrieving, by at least one hardware processor of a computing node, log data at a first process of the computing node. The log data is associated with a function executing at a second process of the computing node. The log data is revised using a table stage to generate revised log data. The table stage is configured as a dedicated storage location of the first process. The revising includes a data enrichment process based on metadata associated with execution of the function at the second process. The revised log data is ingested into an event table.

    Schema evolution for key columnar data into row-organized sequences

    公开(公告)号:US12135697B2

    公开(公告)日:2024-11-05

    申请号:US18326929

    申请日:2023-05-31

    Applicant: Snowflake Inc.

    Abstract: The subject technology generates, by a compute service manager, a schema hash value for a new schema version associated with a new schema version value, the schema hash value based on determining a sum of hash values of a set of attributes of value columns, the set of attributes comprises a column identifier, and a logical type of a column. The subject technology stores a mapping of the schema hash value to the new schema version value for a table in a metadata database. The subject technology stores a new schema entry based on the schema hash value, the new schema version value, and a new column for the table in the metadata database, the metadata database storing multiple entries for different schema versions, each entry including a particular schema hash value for mapping to a corresponding schema version from the different schema versions.

Patent Agency Ranking