SHOW REFERENCES

Lists the references defined for an application in the manifest file and the references the consumer has associated to the application.

Syntax

SHOW REFERENCES IN APPLICATION <name>
Copy

Parameters

name

Specifies the name of the application.

Output

This command displays the following information about the references defined for the application:

Column

Description

name

The name of the reference.

label

The label of the reference as specified in the manifest file.

description

A description of the reference and what it does.

privileges

The privileges that the reference requires. Refer to Object types and privileges that a reference can contain for the list of privileges that a reference can required for an object.

object_type

The type of object associated with the reference. Refer to Object types and privileges that a reference can contain for a list of the supported objects for a reference.

multi-valued

Indicates if the reference requires more than one type of object.

object_name

The name of the object specified by the reference after the consumer associates the object with the application.

schema_name

The name of the schema of the object associated with this reference or NULL if no object has been associated or if the associated object is an account object.

database_name

The name of database of the object associated with this reference or NULL if one of the following is true:

  • No object is specified in the reference definition.

  • The object is not a database or database object.

alias

A name that uniquely identifies a reference to an object, including the object name, scope and privileges

Usage notes

  • The command doesn’t require a running warehouse to execute.

  • The command only returns objects for which the current user’s current role has been granted at least one access privilege.

  • The MANAGE GRANTS access privilege implicitly allows its holder to see every object in the account. By default, only the account administrator (users with the ACCOUNTADMIN role) and security administrator (users with the SECURITYADMIN role) have the MANAGE GRANTS privilege.

  • To post-process the output of this command, you can use the RESULT_SCAN function, which treats the output as a table that can be queried.

Language: English