US 12,353,583 B2
Secure multi-party encrypted identifier data sharing
Justin Langseth, Kailua, HI (US); Michael Earle Rainey, Pasco, WA (US); and William L. Stratton, Jr., Atlanta, GA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on May 19, 2022, as Appl. No. 17/664,135.
Application 17/664,135 is a continuation of application No. 17/390,938, filed on Jul. 31, 2021, granted, now 11,347,886.
Claims priority of provisional application 63/216,888, filed on Jun. 30, 2021.
Prior Publication US 2023/0004670 A1, Jan. 5, 2023
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/9535 (2019.01); G06F 16/27 (2019.01); G06F 21/62 (2013.01); H04L 9/40 (2022.01); H04L 9/06 (2006.01)
CPC G06F 21/6227 (2013.01) [G06F 16/27 (2019.01); G06F 16/9535 (2019.01); H04L 63/0421 (2013.01); H04L 9/0643 (2013.01)] 22 Claims
OG exemplary drawing
 
1. A method comprising:
generating, by a requester database account of a distributed database, a query 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, the provider data set generated by the provider account using micro-batches of a database object, the micro-batches being re-ordered from an initial order of a table of the provider data set;
generating, by the requester database account, an encrypted requester data set using a data set of the requester database account and a pass phrase that is private to the requester database account;
generating, by the requester database account, a requester shared data table comprising the encrypted requester data set;
generating, by the provider database account, a user defined function that generates results data using the requester shared data table in the encrypted requester data set and the provider data set; and
generating, by the requester database account, the results data for the query request by inputting, by the requester database account, the pass phrase into the user defined function and executing the user defined function.