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_immutablecolumn.- After the change:
The output of the SHOW TABLES command includes an
is_immutablecolumn.Column name
Description
is_immutableYif the table was created with the READ ONLY property;Notherwise.
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
YESorNO.
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