How to reset simulated_data_sharing_consumer?

Ilya Milman 0
Viewed 19

Snowflake documentation recommends setting simulated_data_sharing_consumer parameter at a session level for testing data shares, in a manner similar to this:

-- For example, for a consumer account named xy12345:
alter session set simulated_data_sharing_consumer = xy12345;

Is it possible to reset this parameter, without ending the session? If so, how? I was not able to find specific instruction in Snowflake documentation.

data-sharing snowflake-cloud-data-platform
1 Answers

ALTER SESSION:

UNSET

Specifies one (or more) parameters to unset for the session, which resets them to the defaults.

Thus:

ALTER SESSION UNSET simulated_data_sharing_consumer;
Lukasz Szozda0
Related