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.
A role used to execute this operation must have the following privileges at a minimum:
Privilege
Object
Notes
OWNERSHIP
Application
To run this command you must have the ownership privilege on the app.
For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.
For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.
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 pipe operator (->>) or the RESULT_SCAN function. Both constructs treat the output as a result set that you can query.
The output column names for this command are generated in lowercase. If you consume a result set from this command with the pipe operator or the RESULT_SCAN function, use double-quoted identifiers for the column names in the query to ensure that they match the column names in the output that was scanned. For example, if the name of an output column is type, then specify "type" for the identifier.
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4