DATA_CLASSIFICATION_LATEST view (ACCOUNT_USAGE): schemaId column name changed to schema_id (Preview)¶

With this behavior change, the name of the schemaId column in the ACCOUNT_USAGE DATA_CLASSIFICATION_LATEST view is changing to schema_id.

If you have SQL statements that refer to the column name schemaId, you must change those statements to use schema_id as the column name.

Before the change:

Referring to the column name schemaId does not cause a SQL statement to fail. For example:

SELECT schemaId FROM SNOWFLAKE.ACCOUNT_USAGE.DATA_CLASSIFICATION_LATEST LIMIT 1;

Copy

+----------+
| SCHEMAID |
|----------|
| ...      |
+----------+

After the change:

Referring to the column name schemaId causes a SQL statement to fail. For example:

SELECT schemaId FROM SNOWFLAKE.ACCOUNT_USAGE.DATA_CLASSIFICATION_LATEST LIMIT 1;

Copy

000904 (42000): SQL compilation error: error line 1 at position 7
invalid identifier 'SCHEMAID'

Ref: 1885