Schema:: TRUST_CENTER

EXTENSIONS view¶

The SNOWFLAKE.TRUST_CENTER.EXTENSIONS view displays a row for each extension that is registered with the Trust Center.

For more information, see Using Trust Center extensions.

The view has the following columns:

Columns¶

Column name	Data type	Description
NAME	VARCHAR	The name of the extension.
ID	NUMBER	The identifier of the extension.
SOURCE_TYPE	VARCHAR	The source type of the extension: `APPLICATION PACKAGE` `LISTING`
SOURCE	VARCHAR	If the source type is `APPLICATION PACKAGE`, the name of the application package. If the source type is `LISTING`, the identifier of the listing.
VERSION	VARCHAR	The version of the Snowflake Native App extension that is registered with the Trust Center.
PATCH	NUMBER	The patch number of the Native App extension that is registered with the Trust Center.
PREVIOUS_VERSION	VARCHAR	The previous version of the Native App extension that is registered with the Trust Center.
PREVIOUS_PATCH	NUMBER	The previous patch number of the Native App extension registered with the Trust Center.
REGISTRATION_STATE	VARCHAR	The state of the registration of the extension with the Trust Center: `COMPLETED` `IN_PROGRESS` `FAILED`
REGISTRATION_TARGET_VERSION	VARCHAR	The version of the Native App extension that is in the process of being registered with the Trust Center.
REGISTRATION_TARGET_PATCH	NUMBER	The patch number of the Native App extension that is in the process of being registered with the Trust Center.
REGISTRATION_ATTEMPTED_ON	TIMESTAMP_LTZ	The timestamp of the last attempted registration.
REGISTRATION_FAILURE_REASON	VARCHAR	If the last attempted registration failed, the reason for the failure. Otherwise, NULL.
REGISTERED_TIMESTAMP	TIMESTAMP_LTZ	The timestamp for when the extension was registered with the Trust Center for the first time.