DOCUMENTATION
Getting Started
Guides
Developer
Reference
Releases
Status
Ctrl+K

Releases

  1. What's New
    • Behavior Changes
      • About Behavior Changes
        • Behavior Change Policy
          • Behavior Change Management
            • Current Bundles
            • 2023_06 Bundle - Disabled by Default
              • Security Changes
              • WRITE/USAGE stage privileges: Directory table refreshes allowed (Pending)
                • SQL Changes - General
                • Cloning: Alerts cloned when cloning databases or schemas (Pending)
                  • Sequences and columns: Changes to SHOW command, view, and GET_DDL function output (Pending)
                    • Query History: Queries for alert conditions and actions included in history (Pending)
                      • SQL Changes - Commands & Functions
                      • SHOW USERS command: Output filtered based on privileges granted to active role (Pending)
                        • SHOW STAGES command: New columns (Pending)
                          • SYSTEM$GET_PRIVATELINK_CONFIG function: OCSP account identifier URL added to output (Pending)
                            • DYNAMIC_TABLE_REFRESH_HISTORY function: DATA_TIMESTAMP value in output displayed in new format (Pending)
                              • New function: ARRAY_FLATTEN may conflict with similarly named UDFs (Pending)
                                • CREATE ALERT and ALTER ALERT commands: Some validation checks no longer performed on individual statements in conditions and actions (Pending)
                                  • SHOW commands: New column (Pending)
                                    • SQL Changes - Usage Views & Information Schema Views / Table Functions
                                    • Query and Task History views and functions: New columns (Pending)
                                      • ALERT_HISTORY view and function (Account Usage and Information Schema): Changes to output when action contains RETURN statement (Pending)
                                        • ROLES view (Account Usage): New columns and new value for ROLE_TYPE column (Pending)
                                          • GRANTS_TO_ROLES view: New column in the output and new values for existing columns (Pending)
                                            • TABLES view (Account Usage and Information Schema): New column and column values (Pending)
                                              • Task views and functions (Account Usage and Information Schema): New column (Pending)
                                                • Task views and functions (Account Usage and Information Schema): ATTEMPT_NUMBER value changed to 1-based (Pending)
                                                  • METERING_HISTORY view (Account Usage): New column (Pending)
                                                    • Data Loading & Unloading Changes
                                                    • Snowpipe: Modification of auto-ingest notification integration queue for Azure and GCP not allowed (Pending)
                                                      • PUT command on GCP: OVERWRITE parameter must be set to TRUE to overwrite files (Pending)
                                                        • Data Pipelines Changes
                                                        • Dynamic tables: TARGET_LAG parameter set to less than 1 minute for new or modified tables results in error (Pending)
                                                          • Tasks: Graph completion time differs from final task (Pending)
                                                            • Data Sharing Changes
                                                            • GRANT OWNERSHIP command: Ownership transfer not allowed for shared databases (Pending)
                                                              • Database roles: Updated error messages when granting to a share (Pending)
                                                                • Reader accounts: DROP ACCOUNT command not supported (Pending)
                                                                  • Data Governance Changes
                                                                  • SEMANTIC_CATEGORY system tag: Allowed values constraint removed (Pending)
                                                                    • Replication Changes
                                                                    • BLOCK_NON_READLIST_OPERATIONS_ON_STAGES_IN_SECONDARY: Parameter set to TRUE by default (Pending)
                                                                      • Developer and Extensibility Changes
                                                                      • TABLES views (Account Usage and Information Schema): TABLE_TYPE column value shows correct value for event tables (Pending)
                                                                        • Native Apps: GET_DDL error message updated on APPLICATION PACKAGE (Pending)
                                                                          • Procedures (caller’s rights): SQL statements that include PUT and GET commands produce a compiler error (Pending)
                                                                            • Native Apps: Different privileges required to rename APPLICATION and APPLICATION PACKAGE (Pending)
                                                                              • UDTFs: Default column names updated for Python vectorized UDTFs (Pending)
                                                                              • 2023_05 Bundle - Enabled by Default
                                                                                • 2023_04 Bundle - Generally Enabled
                                                                                  • Previous Bundles
                                                                                    1. 2023_03 Bundle
                                                                                      • 2023_02 Bundle
                                                                                        • 2023_01 Bundle
                                                                                          • 2022_08 Bundle
                                                                                            • 2022_07 Bundle
                                                                                              • 2022_06 Bundle
                                                                                                • 2022_05 Bundle
                                                                                                  • 2022_04 Bundle
                                                                                                    • 2022_03 Bundle
                                                                                                      • 2022_02 Bundle
                                                                                                        • 2022_01 Bundle
                                                                                                          • November 2021 - No Bundle
                                                                                                            • 2021_10 Bundle
                                                                                                              • 2021_08 Bundle
                                                                                                                • 2021_07 Bundle
                                                                                                                  • 2021_06 Bundle
                                                                                                                    • 2021_05 Bundle
                                                                                                                      • 2021_04 Bundle
                                                                                                                        • March 2021 - No Bundle
                                                                                                                          • 2021_02 Bundle
                                                                                                                            • 2021_01 Bundle
                                                                                                                              • January 2021 - Other
                                                                                                                              • Non-Bundled Changes
                                                                                                                              • Deprecated Features
                                                                                                                                • Preview Features
                                                                                                                                  • Performance Improvements
                                                                                                                                    • Clients, Drivers, and Libraries
                                                                                                                                      1. Monthly Releases
                                                                                                                                        • Client Versions & Support Policy
                                                                                                                                        ReleasesBehavior Changes2023_06 Bundle - Disabled by DefaultSYSTEM$GET_PRIVATELINK_CONFIG function: OCSP account identifier URL added to output (Pending)

                                                                                                                                        SYSTEM$GET_PRIVATELINK_CONFIG function: OCSP account identifier URL added to output (Pending)¶

                                                                                                                                        Attention

                                                                                                                                        This behavior change is in the 2023_06 bundle.

                                                                                                                                        For the current status of the bundle, refer to Bundle History.

                                                                                                                                        The behavior of the SYSTEM$GET_PRIVATELINK_CONFIG function is as follows:

                                                                                                                                        Currently

                                                                                                                                        The output of this function does not include the OCSP URL for your account identifier.

                                                                                                                                        Pending

                                                                                                                                        The output of this function does include the OCSP URL for your account identifier. The value is recorded as follows:

                                                                                                                                        "regionless-privatelink-ocsp-url": "ocsp.org_name-account_name.privatelink.snowflakecomputing.com"

                                                                                                                                        Where:

                                                                                                                                        org_name is the name of your Snowflake organization.

                                                                                                                                        account_name is the unique name of your account within your organization.

                                                                                                                                        Call the function to obtain the value:

                                                                                                                                        SELECT KEY, VALUE
                                                                                                                                          FROM TABLE(FLATTEN(
                                                                                                                                            input=>PARSE_JSON(
                                                                                                                                              SYSTEM$GET_PRIVATELINK_CONFIG())));
                                                                                                                                        
                                                                                                                                        Copy

                                                                                                                                        Ref: 1212

                                                                                                                                        Was this page helpful?

                                                                                                                                        Snowflake logo
                                                                                                                                        Visit Snowflake
                                                                                                                                        Have feedback? Let us know
                                                                                                                                        Join the conversation in our community
                                                                                                                                        Read the latest on our blog
                                                                                                                                        Develop with Snowflake
                                                                                                                                        Get your Snowflake certification
                                                                                                                                        Privacy NoticeSite Terms© 2023 Snowflake, Inc. All Rights Reserved.
                                                                                                                                        Language: English
                                                                                                                                        • English
                                                                                                                                        • Français
                                                                                                                                        • Deutsch
                                                                                                                                        • 日本語
                                                                                                                                        • 한국어
                                                                                                                                        • Português