Snowflake Sept 2023 Releases

Soumak Das
3 min readSep 18, 2023

SQL Updates Introduction of New Function:

IS_DATABASE_ROLE_IN_SESSION In this latest release, we introduce a new function:

Function Name IS_DATABASE_ROLE_IN_SESSION

Description This function is designed to verify whether a database role is within the user’s active primary or secondary role hierarchy for the ongoing session. It can also check if the specified column contains a database role that is part of the user’s active primary or secondary role hierarchy for the current session. For more details, refer to the section on sharing data protected by a role-based policy — Preview.

Data Loading / Unloading Updates Enhancements in Replicating Streams on Snowflake Tables via Snowpipe Streaming In this release, we are delighted to announce that Snowflake now supports replicating streams on tables populated by Snowpipe Streaming. For additional information, please consult the section on Replication and Snowpipe Streaming.

Updates in Snowpipe Streaming Authentication With the release of Snowpipe Streaming SDK version 2.0.3, we are excited to inform you that Snowpipe Streaming now offers OAuth authentication support. Moreover, the role property for Snowpipe Streaming is now optional. When configuring Snowpipe Streaming, you have the flexibility to set the authorization_type to OAuth and create an OAuth integration with the custom client. For detailed instructions, please refer to Configure Snowflake OAuth for Custom Clients and Configuring Snowpipe Streaming.

--

--

Soumak Das

Sr. Data Engineer @EY & Snowflake/Airflow/Databricks/AWS writer