US 12,277,124 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. 29, 2024, as Appl. No. 18/425,312.
Application 18/425,312 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/0168958 A1, May 23, 2024
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)] 18 Claims
OG exemplary drawing
 
18. One or more machine-storage media containing instructions that, when executed by a machine, cause the machine to perform operations comprising:
receiving a first source dataset from a first database account by a second database account;
generating an approved statements table that contains database statement language that can be executed against a combination of the first source dataset and a second source dataset, the second source dataset originating from a different source than the first source dataset;
receiving a query directed to one or more datasets of a distributed database, the distributed database comprising a plurality of datasets from different database accounts; and
based on determining that the approved statements table includes a database statement for executing queries on the first source dataset and the second source dataset, executing the query on the first source dataset and the second source dataset to produce results data.