Categories:: System functions (Information)

SYSTEM$GET_ALL_DEFAULT_COLUMNS_OVERRIDES¶

Returns the list of columns that were set by previous calls to SYSTEM$SET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMAND and SYSTEM$SET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECT.

For more information, see Handling new columns in SHOW command output and Snowflake views.

See also:: SYSTEM$SET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMAND , SYSTEM$GET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMAND , SYSTEM$UNSET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMAND , SYSTEM$SET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECT , SYSTEM$GET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECT , SYSTEM$UNSET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECT

语法

SYSTEM$GET_ALL_DEFAULT_COLUMNS_OVERRIDES()

实参

无。

返回 JSON 格式的 VARCHAR 值（字符串）。该字符串是 JSON 数组，其中包含每个 SHOW 命令的对象，以及具有列的覆盖列表的 Snowflake 视图的对象。

如果该对象表示 SHOW 命令的默认列的覆盖列表，则该对象包含以下名/值对：

名称	描述
`isShowCommand`	Indicates if the object represents the list of columns for a SHOW command. In this case, the value is `true`.
`showCommandType`	Type of the object for the SHOW command. For example, for SHOW NOTIFICATION INTEGRATIONS, the value is `"NOTIFICATION INTEGRATIONS"`.
`serializedDefaultColumns`	在之前的 SYSTEM$SET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMAND 调用中指定的以逗号分隔的列列表。列名称为大写。

如果该对象表示 Snowflake 视图的默认列的覆盖列表，则该对象包含以下名/值对：

名称	描述
`domain`	Type of the object. In this case, the value is `"VIEW"`.
`isShowCommand`	Indicates if the object represents the list of columns for a SHOW command. In this case, the value is `false`.
`dbName`	Name of the database containing the view. For INFORMATION_SCHEMA views, the value is an empty string (`""`).
`schemaName`	包含视图的架构的名称。
`objectName`	视图的名称。
`serializedDefaultColumns`	在之前的 SYSTEM$SET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECT 调用中指定的以逗号分隔的列列表。列名称为大写。

访问控制要求

只有账户管理员（被授予 ACCOUNTADMIN 角色的用户）可以调用此函数。

示例

以下示例返回了通过之前调用 SYSTEM$SET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMAND 和 SYSTEM$SET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECT 指定的列的列表：

SELECT SYSTEM$GET_ALL_DEFAULT_COLUMNS_OVERRIDES();

+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| SYSTEM$GET_ALL_DEFAULT_COLUMNS_OVERRIDES()                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
%--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------%
| [{"domain":"VIEW","isShowCommand":false,"dbName":"","schemaName":"INFORMATION_SCHEMA","objectName":"DATABASES","serializedDefaultColumns":"DATABASE_NAME,DATABASE_OWNER,IS_TRANSIENT,COMMENT,CREATED,LAST_ALTERED,RETENTION_TIME,TYPE,OWNER_ROLE_TYPE"},{"domain":"VIEW","isShowCommand":false,"dbName":"SNOWFLAKE","schemaName":"ACCOUNT_USAGE","objectName":"DATABASES","serializedDefaultColumns":"DATABASE_ID,DATABASE_NAME,DATABASE_OWNER,IS_TRANSIENT,COMMENT,CREATED,LAST_ALTERED,DELETED,RETENTION_TIME,RESOURCE_GROUP,TYPE,OWNER_ROLE_TYPE,OBJECT_VISIBILITY"},{"isShowCommand":true,"showCommandType":"NOTIFICATION INTEGRATIONS","serializedDefaultColumns":"name,type,category,enabled,comment,created_on"}] |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+