snowflake.snowpark.functions.system_reference¶

snowflake.snowpark.functions.system_reference(object_type: str, object_identifier: str, scope: str = 'CALL', privileges: Optional[List[str]] = None)[source]¶

Returns a reference to an object (a table, view, or function). When you execute SQL actions on a reference to an object, the actions are performed using the role of the user who created the reference.

Example::

CopyExpand

>>> df = session.create_dataframe([(1,)], schema=["A"])
>>> df.write.save_as_table("my_table", mode="overwrite", table_type="temporary")
>>> df.select(substr(system_reference("table", "my_table"), 1, 14).alias("identifier")).collect()
[Row(IDENTIFIER='ENT_REF_TABLE_')]

Show lessSee more

Scroll to top