US 11,928,157 B2
Projection constraints in a query processing system
Khalid Zaman Bijon, Santa Cruz, CA (US); Thierry Cruanes, San Mateo, CA (US); Simon Holm Jensen, Menlo Park, CA (US); Allison Waingold Lee, Pebble Beach, CA (US); Daniel N. Meredith, Laguna Beach, CA (US); Subramanian Muralidhar, Mercer Island, WA (US); David Schultz, Piedmont, CA (US); and Zixi Zhang, San Mateo, CA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Sep. 23, 2022, as Appl. No. 17/934,814.
Claims priority of provisional application 63/366,281, filed on Jun. 13, 2022.
Prior Publication US 2023/0401260 A1, Dec. 14, 2023
Int. Cl. G06F 16/903 (2019.01)
CPC G06F 16/90335 (2019.01) 30 Claims
OG exemplary drawing
 
1. A method comprising:
receiving, from a consumer account, a first query directed towards a shared dataset of a provider account, the first query identifying a first operation and including available values specifying data that is accessible to the consumer account by query requests;
accessing a first set of data from the shared dataset to perform the first operation, the first set of data including data accessed from a first column of the shared dataset;
determining, by at least one hardware processor, that the provider account attached a projection constraint policy to the first column, the projection constraint policy restricting output of data values, to the consumer account, stored in the first column;
determining, based on a context of the first query, that the projection constraint policy should be enforced in relation to the first query;
enforcing the projection constraint policy in relation to the first query, the enforcing comprising enabling the consumer account to perform the first operation on the data values stored in the first column while maintaining confidentiality of the data values; and
generating an output to the first query based on the first set of data and the first operation, the output to the first query maintaining the confidentiality of the data values by not including the data values stored in the first column based on enforcing the projection constraint policy in relation to the first query.