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 nameData typeDescription
NAMEVARCHARThe name of the extension.
IDNUMBERThe identifier of the extension.
SOURCE_TYPEVARCHAR

The source type of the extension:

  • APPLICATION PACKAGE
  • LISTING
SOURCEVARCHAR

If the source type is APPLICATION PACKAGE, the name of the application package. If the source type is LISTING, the identifier of the listing.

VERSIONVARCHARThe version of the Snowflake Native App extension that is registered with the Trust Center.
PATCHNUMBERThe patch number of the Native App extension that is registered with the Trust Center.
PREVIOUS_VERSIONVARCHARThe previous version of the Native App extension that is registered with the Trust Center.
PREVIOUS_PATCHNUMBERThe previous patch number of the Native App extension registered with the Trust Center.
REGISTRATION_STATEVARCHAR

The state of the registration of the extension with the Trust Center:

  • COMPLETED
  • IN_PROGRESS
  • FAILED
REGISTRATION_TARGET_VERSIONVARCHARThe version of the Native App extension that is in the process of being registered with the Trust Center.
REGISTRATION_TARGET_PATCHNUMBERThe patch number of the Native App extension that is in the process of being registered with the Trust Center.
REGISTRATION_ATTEMPTED_ONTIMESTAMP_LTZThe timestamp of the last attempted registration.
REGISTRATION_FAILURE_REASONVARCHARIf the last attempted registration failed, the reason for the failure. Otherwise, NULL.
REGISTERED_TIMESTAMPTIMESTAMP_LTZThe timestamp for when the extension was registered with the Trust Center for the first time.