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 nameDescription
is_immutableY 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 nameData typeDescription
IS_IMMUTABLETEXTIndicates 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