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:
ACCOUNT_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.
Ref: 2185