US 11,816,248 B2
Query processing using data clean rooms
Rachel Frances Blum, South Orange, NJ (US); Justin Langseth, Kailua, HI (US); and Michael Earle Rainey, Kennewick, WA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Jan. 31, 2023, as Appl. No. 18/162,701.
Application 18/162,701 is a continuation of application No. 17/932,610, filed on Sep. 15, 2022, granted, now 11,620,409.
Application 17/932,610 is a continuation of application No. 17/644,722, filed on Dec. 16, 2021, granted, now 11,468,195.
Application 17/644,722 is a continuation of application No. 17/463,293, filed on Aug. 31, 2021, granted, now 11,222,141.
Application 17/463,293 is a continuation of application No. 17/334,297, filed on May 28, 2021, granted, now 11,138,340.
Claims priority of provisional application 63/201,489, filed on Apr. 30, 2021.
Prior Publication US 2023/0169213 A1, Jun. 1, 2023
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 21/00 (2013.01); G06F 21/62 (2013.01); G06F 16/245 (2019.01); G06F 16/27 (2019.01)
CPC G06F 21/6254 (2013.01) [G06F 16/245 (2019.01); G06F 16/27 (2019.01)] 30 Claims
OG exemplary drawing
 
1. A method performed by executing instructions on at least one hardware processor, the method comprising:
generating a cross reference table that cross references a first dataset and a second dataset, the first dataset being from a first database account, the second dataset being from a second database account;
receiving a query directed to a combination of the first and second datasets;
generating an interim table in the first database account by applying the query to the cross reference table and the first dataset;
generating results data in the second database account by applying the query to the interim table and the second dataset; and
storing the results data in the first database account.