US 11,928,115 B2
Query processing with restrictions 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 Jan. 30, 2023, as Appl. No. 18/161,541.
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.
Claims priority of provisional application 63/266,253, filed on Dec. 30, 2021.
Prior Publication US 2023/0177055 A1, Jun. 8, 2023
This patent is subject to a terminal disclaimer.
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)] 30 Claims
OG exemplary drawing
 
1. A method performed by executing instructions on at least one hardware processor, the method comprising:
receiving a query directed to a combination of a first source dataset from a first database account of a distributed database and a second source dataset from a second database account of the distributed database;
generating an approved statements table that contains database statement language that can be executed against the combination of the first and second source datasets;
based on determining that the approved statements table includes the query, executing the query to produce results data; and
storing the results data in the first database account.