Data overlap count adjustment in a multiple tenant database system

    公开(公告)号:US11461493B1

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

    申请号:US17847681

    申请日:2022-06-23

    Applicant: SNOWFLAKE INC.

    Abstract: Systems, methods, and devices for generating a secure join of database data are disclosed. A method creates a secure view of datapoints of a consumer account and processes, using a secure user defined function (UDF), the datapoints of the consumer account and datapoints of a provider account to generate a secure join key. The datapoints of the consumer account are provided to the secure UDF using the secure view. The method further performs, by a processor, an analysis of the datapoints of the consumer account and the datapoints of the provider account of the secure join key. The analysis returns a count value of overlapping datapoints between the consumer account and the provider account. The method further adjusts the count value of overlapping datapoints based on a number of distinct rows associated with the provider account, and provides the adjusted count value of overlapping datapoints to the consumer account.

    Data exchange
    25.
    发明授权

    公开(公告)号:US10977268B2

    公开(公告)日:2021-04-13

    申请号:US16428592

    申请日:2019-05-31

    Applicant: Snowflake Inc.

    Abstract: A data warehouse storing databases for a plurality of users, including service providers hosting data for other users of the data warehouse may implement a data exchange. A provider of data creates a listing in the exchange including metadata. A consumer browses the metadata and select a listing to add to consumed shares of the consumer. Browsing may be filtered to implement a private exchange. Adding of data may be limited by access controls requiring verification of the consumer's identity. The added data may be filtered to include only data that relates to the consumer. Sharing may be bi-directional such that a request to add a listing for first data of a provider may also reference second data of the consumer such that the first data is added to the consumed shares of the consumer and the second data is added to the consumed shares of the provider.

    Data Exchange
    26.
    发明申请
    Data Exchange 审中-公开

    公开(公告)号:US20200380007A1

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

    申请号:US16428592

    申请日:2019-05-31

    Applicant: Snowflake Inc.

    Abstract: A data warehouse storing databases for a plurality of users, including service providers hosting data for other users of the data warehouse may implement a data exchange. A provider of data creates a listing in the exchange including metadata. A consumer browses the metadata and select a listing to add to consumed shares of the consumer. Browsing may be filtered to implement a private exchange. Adding of data may be limited by access controls requiring verification of the consumer's identity. The added data may be filtered to include only data that relates to the consumer. Sharing may be bi-directional such that a request to add a listing for first data of a provider may also reference second data of the consumer such that the first data is added to the consumed shares of the consumer and the second data is added to the consumed shares of the provider.

    Cloud data sharing for applications

    公开(公告)号:US12229424B2

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

    申请号:US18162692

    申请日:2023-01-31

    Applicant: Snowflake Inc.

    Abstract: A request to share cloud data associated with a first account in a database system with an application is received. Based on the request, second-party application data and third-party data that is accessible by the first account is identified. The second-party application data comprises application data corresponding to a second application provided by a second-party application provider. The third-party data corresponds to a second account maintained by the database system. The second account corresponds to a third-party data provider. The application is enabled to access the cloud data associated with the first account based on the request. The cloud data comprises customer data associated with the first account, second-party application data, and the third-party data.

    OVERLAP RESULTS DATA GENERATION ON A CLOUD DATA PLATFORM

    公开(公告)号:US20230385286A1

    公开(公告)日:2023-11-30

    申请号:US18162688

    申请日:2023-01-31

    Applicant: Snowflake Inc.

    CPC classification number: G06F16/24568 G06F16/24564 G06F16/244 G06F16/2456

    Abstract: A system for generating similarity data for different datasets in a cloud data platform. A first dataset of a plurality of datasets on the cloud data platform is identified, where the first dataset is associated with a first user of the cloud data platform. A semantic type for each feature the first dataset is identified, and each semantic type for the first dataset is compared with existing data of the first user. Semantic types for each feature of each dataset are identified, and each semantic type for the first dataset is compared to each semantic type of each dataset. Overlap requests are generated to output overlap datasets between the first dataset and each of the plurality of datasets. A results dataset is generated by applying the overlap requests to a joined dataset comprising data from the first dataset and data from each of the plurality of datasets.

Patent Agency Ranking