APPLICATION_CONFIGURATIONS view¶

This Information Schema view displays a row for each application configuration currently defined in the specified or current database where the information schema is located.

For more information about application configuration, see Application configuration.

Columns¶

The following table provides definitions for the APPLICATION_CONFIGURATIONS view columns.

Column	Data type	Description
NAME	STRING	The name of the configuration.
APPLICATION_NAME	STRING	The name of the application that the configuration is in.
CREATED_ON	TIMESTAMP	The timestamp when the configuration object was created.
UPDATED_ON	TIMESTAMP	The timestamp when the configuration object was last updated.
TYPE	STRING	The type of the configuration. Possible values are APPLICATION_NAME and STRING.
STATUS	STRING	The status of the configuration. Possible values are PENDING and DONE.
SENSITIVE	BOOLEAN	Whether the value is sensitive or not.
VALUE	STRING	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_ON	TIMESTAMP	The last updated timestamp when the value was set or unset.
LABEL	STRING	A user-friendly name to be displayed in the UI, provided by the provider.
DESCRIPTION	STRING	The description of the configuration.
APPLICATION_ROLES	STRING	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 view only displays configurations for which the current role for the session has been granted access privileges.
The view does not include configurations that have been dropped.

Examples¶

Retrieve all listings in the current account:

SELECT * FROM <any_database>.INFORMATION_SCHEMA.APPLICATION_CONFIGURATIONS;

Copy