APPLICATION_CONFIGURATIONS view

This Account Usage view displays a row for each application configuration currently defined in the specified or current database where the account usage schema is located.

For more information about application configuration, see Application configuration.

Columns

The following table provides definitions for the APPLICATION_CONFIGURATIONS view columns.

ColumnData typeDescription
IDNUMBERThe system-generated ID for the application configuration.
NAMESTRINGThe name of the configuration.
APPLICATION_IDNUMBERThe system-generated ID for the application that the configuration is in.
APPLICATION_NAMESTRINGThe name of the application that the configuration is in.
CREATED_ONTIMESTAMPThe timestamp when the configuration object was created.
MODIFIED_ONTIMESTAMPThe timestamp when the configuration object was last updated.
DELETED_ONTIMESTAMPThe timestamp when the configuration object was deleted.
TYPESTRINGThe type of the configuration. Possible values are APPLICATION_NAME and STRING.
STATUSSTRINGThe status of the configuration. Possible values are PENDING and DONE.
SENSITIVEBOOLEANWhether the value is sensitive or not.
VALUESTRING

The value that is set by the consumer.

For application configurations of the APPLICATION_NAME type, this is the most up-to-date name of the application specified by the consumer. This may not be the same as initially provided if the application has been renamed. If the application has been dropped, no value will be shown here, as if the value is not set.

When SENSITIVE=TRUE, the value is hidden, unless the executing role is the application owning the configuration.

VALUE_UPDATED_ONTIMESTAMPThe last updated timestamp when the value was set or unset.
LABELSTRINGA user-friendly name to be displayed in the UI, provided by the provider.
DESCRIPTIONSTRINGThe description of the configuration.
APPLICATION_ROLESSTRING

The comma-separated app role names that have access to the configuration.

This displays the most up-to-date names, even if roles have been renamed. If an application role has been dropped, it will not be included in the output list.

Usage notes

  • The retention time for deleted app configurations is 365 days. Data older than 365 days will not be available in the view.

Examples

Retrieve all listings in the current account:

SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.APPLICATION_CONFIGURATIONS;