Question

A data engineer builds a view that joins a proprietary customer-scoring table with a public reference table. The view will be shared with an external partner account through a Snowflake data share. Company policy requires that the partner must be able to query the results but must NOT be able to see the underlying SQL logic or infer excluded rows through query optimizations. Which view type should the engineer create?

Accepted Answer

A secure view, because it hides the view definition and disables query optimizations that could expose underlying data

Answer

A standard view, because standard views always hide their definition from consumers by default

Answer

A materialized view, because materialized views cannot be inspected and are the only view type shareable

Answer

A standard view with a masking policy applied to every column