DOCUMENTATION
/
Getting Started
Guides
Developer
Reference
Releases
Tutorials
Snowflake Open Catalog
Status
  1. Overview
    • Release notes
    • Snowflake weekly, Snowsight, and feature releases
    • Behavior changes
        1. About behavior changes
          • Behavior change policy
            • Behavior change management
              • Current bundles
              • 2025_03 Bundle (Preview)
              • 2025_02 Bundle (Disabled by Default)
              • 2025_01 Bundle (Enabled by Default)
              • Previous bundles
                1. 2024_08 Bundle (Generally Enabled)
                2. 2024_07 bundle
                3. 2024_06 bundle
                4. 2024_05 bundle
                5. 2024_04 bundle
                    1. Security
                    2. Snowflake Native App Framework: Roles with the ATTACH LISTING privilege can run the DESCRIBE APPLICATION PACKAGE command
                      • SQL Changes - Commands & Functions
                      • DESC FUNCTION command: New column IS_AGGREGATE in output
                        • DESCRIBE SESSION POLICY: Add allowed_secondary_roles column
                          • SHOW ENDPOINTS command: New column and changes to output
                            • SHOW SHARES command: New column (SECURE_OBJECTS_ONLY)
                              • SHOW TABLES command, TABLES view, and GET_DDL command: Changes related to the READ ONLY property for tables
                                • SHOW VERSIONS IN MODEL: Add aliases column
                                  • SHOW/DESC COMPUTE POOL command: New columns
                                    • SHOW/DESC SERVICE commands and Information Schema view: New STATUS column
                                      • SQL Changes — Usage Views & Information Schema Views / Table Functions
                                      • Account Usage views: Add support for versioned schemas in Snowflake Native Apps
                                        • LISTING_CONSUMPTION_DAILY view: New columns
                                          • NOTIFICATION_HISTORY table function: Changes to output
                                            • STAGES View (ACCOUNT_USAGE): New Column STORAGE_INTEGRATION
                                              • Virtual Warehouse
                                              • WAREHOUSE_EVENTS_HISTORY View (ACCOUNT_USAGE): New columns and changes to events
                                                • Data Pipelines
                                                • Dynamic tables: Updates to dynamic table default refresh mode
                                                  • Data Governance
                                                  • Masking policy: Comply with the scale and precision of a column
                                                    • Replication
                                                    • Replication support for CREATE <class_name> privilege
                                                      • Extensibility & Developer
                                                      • Event tracing: Trace IDs propagated from parent to child through procedure calls
                                                        • Snowpark Container Services: Changes to access control for services and endpoints
                                                      • 2024_03 bundle
                                                      • 2024_02 bundle
                                                      • 2024_01 bundle
                                                      • 2023_08 bundle
                                                      • 2023_07 bundle
                                                      • 2023_06 bundle
                                                      • 2023_05 bundle
                                                      • 2023_04 bundle
                                                      • 2023_03 bundle
                                                      • 2023_02 bundle
                                                      • 2023_01 bundle
                                                      • Earlier bundles
                                                      • Unbundled changes
                                                  • Streamlit in Snowflake releases
                                                    • Client, driver, and library releases
                                                      1. Monthly releases
                                                      2. Client versions & support policy
                                                      3. Snowflake Connector releases
                                                        1. Snowflake Connector for Google Analytics Raw Data
                                                          • Snowflake Connector for Google Analytics Aggregate Data
                                                            • Snowflake Connector for ServiceNow V2
                                                              • Snowflake Connector for MySQL
                                                                • Snowflake Connector for PostgreSQL
                                                                  • Snowflake Connector for Sharepoint
                                                                    • Native SDK for Connectors
                                                                      1. Native SDK for Connectors Java library
                                                                        • Native SDK for Connectors Java Test library
                                                                          • Native SDK for Connectors Java Template
                                                                            • Native SDK Example Java GitHub Connector
                                                                          • Recent improvements
                                                                          • Performance improvements
                                                                          • SQL improvements
                                                                            • Feature information
                                                                            • Preview features
                                                                              ReleasesBehavior changesPrevious bundles2024_04 bundleSHOW TABLES command, TABLES view, and GET_DDL command: Changes related to the READ ONLY property for tables

                                                                              SHOW TABLES command, TABLES view, and GET_DDL command: Changes related to the READ ONLY property for tables¶

                                                                              Attention

                                                                              This behavior change is in the 2024_04 bundle.

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

                                                                              When this behavior change bundle is enabled, you can create tables with a new READ ONLY property. New output related to this property is added when you run the SHOW TABLES command, query the TABLES view, or run the GET_DDL command.

                                                                              SHOW TABLES command: New is_immutable column¶

                                                                              A new column is added to the output of the SHOW TABLES command.

                                                                              Before the change:

                                                                              The output of the SHOW TABLES command does not include an is_immutable column.

                                                                              After the change:

                                                                              The output of the SHOW TABLES command includes an is_immutable column.

                                                                              Column name

                                                                              Description

                                                                              is_immutable

                                                                              Y if the table was created with the READ ONLY property; N otherwise.

                                                                              TABLES view (Information Schema): New IS_IMMUTABLE column¶

                                                                              A new column is added to the TABLES view.

                                                                              Before the change:

                                                                              The TABLES view does not include an IS_IMMUTABLE column.

                                                                              After the change:

                                                                              The TABLES view includes an IS_IMMUTABLE column.

                                                                              Column name

                                                                              Data type

                                                                              Description

                                                                              IS_IMMUTABLE

                                                                              TEXT

                                                                              Indicates whether the table was created with the READ ONLY property. Valid values are YES or NO.

                                                                              Note

                                                                              The ACCOUNT_USAGE.TABLES view will not include the IS_IMMUTABLE column because temporary tables are not reported in this view.

                                                                              The GET_DDL command returns output for tables created with the READ ONLY property¶

                                                                              The GET_DDL command returns the following output for tables that were created with the READ ONLY property:

                                                                              CREATE OR REPLACE TEMPORARY READ ONLY TABLE <table_name> CLONE <src_table_name>
                                                                              

                                                                              Ref: 1572

                                                                              Was this page helpful?

                                                                              Visit Snowflake
                                                                              Join the conversation
                                                                              Develop with Snowflake
                                                                              Share your feedback
                                                                              Read the latest on our blog
                                                                              Get your own certification
                                                                              Privacy NoticeSite Terms© 2025 Snowflake, Inc. All Rights Reserved.
                                                                              1. SHOW TABLES command: New is_immutable column
                                                                              2. TABLES view (Information Schema): New IS_IMMUTABLE column
                                                                              3. The GET_DDL command returns output for tables created with the READ ONLY property
                                                                              Language: English
                                                                              • English
                                                                              • Français
                                                                              • Deutsch
                                                                              • 日本語
                                                                              • 한국어
                                                                              • Português