- Categories:
System functions (System Control)
SYSTEM$ADD_REFERENCE¶
Called by a Snowflake Native App to associate a consumer reference string to a reference definition. The app can use this association to access the consumer object. The reference string passed to this system function is the value returned by the SYSTEM$REFERENCE function, which represents a consumer object.
For information about using this function in an app, see Request references and object-level privileges from consumers.
This function supports both single and multi-valued references. The function returns an
error if an association has already been created using the same value specified by
reference_name
.
Syntax¶
SYSTEM$ADD_REFERENCE('<reference_name>', '<reference_string>')
Arguments¶
'reference_name'
The name of the reference as specified in the
manifest.yml
file of the app.'reference_string'
The system-generated ID of the reference to the object in the consumer account.