Query validation and processing in data clean rooms

A computer system comprising:

• at least one hardware processor;
• and
• one or more non-transitory computer readable storage media containing instructions that, when executed by the at least one hardware processor, cause the computer system to perform operations comprising:
• generating, at a provider database account, an installation file that, when processed, generates instances of a defined access clean room providing clean room functionality, defines parameters for the instances of the defined access clean room, generates one or more procedures for the instances of the defined access clean room, and controls visibility of objects across different consumer accounts;
• providing the installation file to a consumer database account;
• installing, in the consumer database account, the installation file to generate an application instance of the defined access clean room;
• sharing, by the provider database account, source provider data with the defined access clean room, the sharing making the source provider data accessible to the consumer database account via the application instance;
• sharing, by the provider database account, a query template with the consumer database account via the application instance;
• receiving a query generated by the consumer database account based on the query template;
• validating that the query is consistent with the query template;
• generating, based on validating that the query is consistent with the query template, query results by executing the query;
• and
• storing the query results in the consumer database account.

One or more non-transitory computer readable storage media containing instructions that, when executed by at least one hardware processor of a computer system, cause the computer system to perform operations comprising:

• generating, at a provider database account, an installation file that, when processed, generates instances of a defined access clean room providing clean room functionality, defines parameters for the instances of the defined access clean room, generates one or more procedures for the instances of the defined access clean room, and controls visibility of objects across different consumer accounts;
• providing the installation file to a consumer database account;
• installing, in the consumer database account, the installation file to generate an application instance of the defined access clean room;
• sharing, by the provider database account, source provider data with the defined access clean room, the sharing making the source provider data accessible to the consumer database account via the application instance;
• sharing, by the provider database account, a query template with the consumer database account via the application instance;
• receiving a query generated by the consumer database account based on the query template;
• validating that the query is consistent with the query template;
• generating, based on validating that the query is consistent with the query template, query results by executing the query;
• and
• storing the query results in the consumer database account.