A Snowflake Architect created a new data share and would like to verify that only specific records in secure views are visible within the data share by the consumers. What is the recommended way to…

Question

Options

• ACreate reader accounts as shown below and impersonate the consumers by logging in with their
• BCreate a row access policy as shown below and assign it to the data share.
• CSet the session parameter called SIMULATED_DATA_SHARING_C0NSUMER as shown below in
• DAlter the share settings as shown below, in order to impersonate a specific consumer account.

• A
  2% (1)
• B
  7% (3)
• C
  88% (37)
• D
  2% (1)

Explanation

The SIMULATED_DATA_SHARING_CONSUMER session parameter allows a data provider to simulate the data access of a consumer account without creating a reader account or logging in with the consumer credentials. This parameter can be used to validate the data accessibility by the consumers in a data share, especially when using secure views or secure UDFs that filter data based on the current account or role. By setting this parameter to the name of a consumer account, the data provider can see the same data as the consumer would see when querying the shared database. This is a convenient and efficient way to test the data sharing functionality and ensure that only the intended data is visible to the consumers.

No community discussion yet for this question.