SHOW SPECIFICATIONS¶

Lists the app specifications that have been defined for an app.

See also:

DESCRIBE SPECIFICATION, ALTER APPLICATION SET SPECIFICATIONS

Syntax¶

SHOW [ { APPROVED | DECLINED | PENDING } ] SPECIFICATIONS [ IN APPLICATION <app_name> ];
Copy

Parameters¶

APPROVED | DECLINED | PENDING

Narrows the output to app specifications with one of these statuses.

IN APPLICATION app_name

Specifies the name of the app whose app specification you want to view.

Usage notes¶

  • Consumers must provide the name of an app using the IN APPLICATION clause.

  • An app can run this command without specifying the IN APPLICATION clause.

Output¶

The command output provides information about the properties of an app specification in the following columns:

Column

Description

name

Name of the app specification.

requested_on

Timestamp when the app specification was requested.

type

Type of app specification. Supported values are: ‘EXTERNAL ACCESS` and SECURITY INTEGRATION. supported.

sequence_number

ID for a version of an app specification. This value is incremented each time a provider changes the app specification definition.

status

Specifies the current status of the app specification. Possible values are:

  • APPROVED: The consumer approved the app specification.

  • PENDING: The app specification is waiting for the consumer to approve or decline.

  • DECLINED: The consumer declined the app specification.

status_updated_on

Timestamp of the last status change.

label

Name of the app specification that is displayed to the consumer in Snowsight.

description

Description of the app specification that is displayed to the consumer in Snowsight.

definition

Values that are part of the app specification definition. The values of this column depend on the type of app specification.

Examples¶

Show all specifications that you have privileges to view:

SHOW SPECIFICATIONS;
Copy