Categories:

System functions (System Control)

SYSTEM$SET_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.

此函数仅支持单值引用。如果已使用相同的引用名称创建了关联,现有关联将被覆盖。

语法

SYSTEM$SET_REFERENCE('<reference_name>', '<reference_string>')

实参

必填

'reference_name'

The name of the reference as specified in the manifest.yml file of the app.

'reference_string'

使用者账户中的对象引用 ID,由系统生成。