A Data Engineer created table t1 and applied the projection policy my_proj_policy to several columns:
t1
my_proj_policy
What effect will the policy have on the account_number and account_type columns?
account_number
account_type
When a projection policy disallows a column from being projected, Snowflake does not include that column in the final query result. It also prevents using the column to insert data into another table and prevents passing it as an argument to an external function or external stored procedure. Projection constraints do not prevent use of the column in a WHERE clause.
WHERE
Community Discussion