What is the MOST efficient way to share a subset of data from a table with a consumer account?
A secure view can filter the rows and columns exposed from a base table and be granted to a Snowflake share, allowing a consumer account to access only that subset while the underlying table and business logic remain protected. Snowflake specifically recommends secure views or secure UDFs instead of direct table sharing, and documents secure views for filtering data by conditions for consumer accounts.
Community Discussion