snowflake.snowpark.functions.current_secondary_roles

snowflake.snowpark.functions.current_secondary_roles() → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.38.0/src/snowflake/snowpark/_functions/scalar_functions.py#L71-L80)

Returns a JSON string that lists all secondary roles granted to the current user.

Example

>>> # Return result is tied to session, so we only test if the result exists
>>> result = session.create_dataframe([1]).select(current_secondary_roles()).collect()
>>> assert result[0]['CURRENT_SECONDARY_ROLES()'] is not None
Copy
Language: English