November 11-14, 2023 — 7.41 Release Notes (with behavior changes)¶

New SQL functions¶

The following function(s) are now available with this release:

UDFs and Stored Procedures: Support for Optional Arguments¶

You can now specify that an argument in a UDF or stored procedure is optional. In the CREATE FUNCTION or CREATE PROCEDURE statement, use the new DEFAULT keyword to specify the default value for an optional argument. For example:

CREATE FUNCTION my_udf(
  arg_1 VARCHAR,
  arg_2_optional VARCHAR DEFAULT 'default'
  arg_3_optional INTEGER DEFAULT 0) ...

When you call the UDF or stored procedure, you can omit any of the optional arguments:

SELECT my_udf(arg_1 => 'value', arg_3_optional => 1);

For more information, see the documentation on optional arguments for UDFs and stored procedures.

Snowflake alerts: Manual execution of alerts¶

With this release, we are pleased to announce the new EXECUTE ALERT SQL command, which you can use to execute an alert manually.

You can use the EXECUTE ALERT command to:

• Verify that a new alert works as you would expect.

• Execute an alert at a specific point in your data pipeline (for example, at the end of a stored procedure call).

You can run the EXECUTE ALERT command interactively. You can also run this command within a stored procedure or a Snowflake Scripting block.

For more information, see EXECUTE ALERT.

Replication of network rules — Preview¶

With this release, we are pleased to announce that network rules, which are currently in preview, are now replicated when you replicate the database in which they are contained. References between network policies and network policies are also replicated.

For more information, see Replicating network policies.

Dynamic tables: Support for GRANT <privilege> ON ALL/FUTURE DYNAMIC TABLE - Preview¶

As part of Behavior Change bundle 2023_08, Snowflake has enabled support for granting privileges on all and future dynamic tables.

For more information, see GRANT <privileges>.

Dynamic tables: Support for GRANT ALL/ALL PRIVILEGES ON DYNAMIC TABLE - Preview¶

As part of Behavior Change bundle 2023_08, Snowflake has enabled support for bulk grants on dynamic tables.

For more information, see Dynamic table privileges.

More control over notification contacts in Snowsight¶

Managing your notification contacts in Snowsight is improved, with more granular control over who can receive notifications for an organization or account, and the ability to send notifications to multiple email addresses.

For more information, see About notification contacts for Snowflake.

Snowsight is the default interface for Snowflake accounts in US government regions¶

Concluding the week of November 13, 2023, all users in Snowflake accounts in US government regions see Snowsight after logging in.

For more information, see About the Snowsight upgrade.

Changes to formatting of query results in worksheets and dashboards¶

As part of a behavior change in bundle 2023_07, query results no longer have automatic formatting applied in Snowsight.

For more information, see Snowsight worksheets and dashboards: Changes to formatting of query results.