TABLES, VIEWS, and EXTERNAL_
Attention
This behavior change is in the 2023_01 bundle.
For the current status of the bundle, refer to Bundle History.
New columns for tracking DDL operations have been added to the following Account Usage and Information Schema views:
-
ACCOUNT_USAGE:
-
INFORMATION_SCHEMA:
New columns:
| Column Name | Data Type | Description |
|---|---|---|
| LAST_DDL | TIMESTAMP | Specifies the timestamp of the last DDL operation performed on the table or view. |
| LAST_DDL_BY | TEXT | Specifies the username of the user who performed the last DDL operation on the table or view. |
Ref: 891