QuestionQ35Verified/Data CollaborationCopy linkReport a problemAsk AstroTutorSave questionWhat is the MOST efficient way to share a subset of data from a table with a consumer account?ACreate a secure User-Defined Function (UDF).BUse a dynamic table.CCreate an external table.DCreate a secure view.Show AnswerAnswerExplanationA 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.Learn moreUse secure objects to control data accessCreate and configure sharesShow comments0Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion