US 12,135,721 B2
Symmetric query processing in a database clean room
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 Oct. 3, 2023, as Appl. No. 18/480,028.
Application 18/480,028 is a continuation of application No. 18/162,708, filed on Jan. 31, 2023, granted, now 11,822,554.
Application 18/162,708 is a continuation of application No. 18/161,541, filed on Jan. 30, 2023, granted, now 11,928,115.
Application 18/161,541 is a continuation of application No. 17/652,873, filed on Feb. 28, 2022, granted, now 11,567,943.
Application 17/652,873 is a continuation in part of application No. 17/538,785, filed on Nov. 30, 2021, granted, now 12,067,019.
Claims priority of provisional application 63/266,253, filed on Dec. 30, 2021.
Prior Publication US 2024/0028597 A1, Jan. 25, 2024
Int. Cl. G06F 16/2455 (2019.01); G06F 16/242 (2019.01); G06F 16/27 (2019.01); G06F 21/62 (2013.01)
CPC G06F 16/24565 (2019.01) [G06F 16/2443 (2019.01); G06F 16/27 (2019.01); G06F 21/6227 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A method performed by executing instructions on at least one hardware processor, the method comprising:
sharing, by a first database account, a first source dataset that resides in the first database account in a first data clean room with a database account other than the first database account;
sharing, by a second database account, a second source dataset that resides in a third database account in the first data clean room with a database account other than the second database account;
storing, by the second database account, a first approved-statements table that includes database statements that are permitted by the second database account to be executed against the combination of the shared first source dataset and the shared second source dataset; and
processing one or more first-account queries received from the first database account that are included in the first approved-statements table.