Patent ID: 11934553
Assignee: SNOWFLAKE INC.
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 0:
1. A method comprising:
generating, on a requester database account in a distributed database system, a clean room query request against a shared data set comprising a requester data set from the requester database account and a provider data set from a provider database account in the distributed database system, the requester database account not having access through the distributed database system to the provider data set in plain text format, the provider database account not having access through the distributed database system to the requester data set in plain text format;
generating, in the requester database account, a requester shared data table comprising the requester data set in an encrypted format that is encrypted using a pass phrase that is private to the requester database account;
receiving, from the provider database account, a shared user defined function that generates results data by processing the requester shared data table and the provider data set in a sandbox execution environment, the shared user defined function configured to accept a decryption parameter to generate the results data by (i) decrypting the requester data set in the sandbox execution environment, (ii) anonymizing the decrypted requester data set by generating a cross reference table that cross references the anonymized requester data set and the decrypted requester data set, and (iii) joining the anonymized requester data set and the provider data set on a user-identifier field in the sandbox execution environment without providing, to the requester database account, access to the provider data set; and
generating, in the requester database account, the results data for the clean room query request by inputting the pass phrase into the shared user defined function as the decryption parameter and executing the shared user defined function in the sandbox execution environment.