New ERROR_ LOGGING column in TABLES views and commands (Pending)¶
Attention
This behavior change is in the 2026_03 bundle.
For the current status of the bundle, refer to Bundle history.
- Before the change:
The following views and commands don’t include information about whether error logging is enabled for a table:
- INFORMATION_SCHEMA.TABLES view
- ACCOUNT_USAGE.TABLES view
- ORGANIZATION_USAGE.TABLES view
- SHOW TABLES command
- GET_DDL command
- After the change:
When the 2026_03 behavior change bundle is enabled in your account, the following changes take effect:
- A new
ERROR_LOGGINGcolumn (BOOLEAN) is added to the INFORMATION_SCHEMA.TABLES, ACCOUNT_USAGE.TABLES, and ORGANIZATION_USAGE.TABLES views. The column indicates whether error logging is enabled for a table. - A new
error_loggingcolumn (STRING) is added to the output of the SHOW TABLES command. - The GET_DDL command output for tables with error logging enabled includes
the
ERROR_LOGGING = TRUEproperty, so you can use the output to recreate the table with the same setting.
For more information about error logging, see DML error logging.
- A new
Ref: 2185