You are viewing documentation about an older version (1.40.0). View latest version

snowflake.snowpark.functions.last_query_id¶

snowflake.snowpark.functions.last_query_id(num: Union[snowflake.snowpark.column.Column, str] = None) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.40.0/src/snowflake/snowpark/_functions/scalar_functions.py#L981-L1008)¶

Returns the query ID of the last statement executed in the current session. If num is specified, returns the query ID of the nth statement executed in the current session.

Parameters:: num (ColumnOrName, optional) – The number of statements back to retrieve the query ID for. If None, returns the query ID of the last statement.
Returns:: The query ID as a string.
Return type:: Column

Example:

>>> df = session.create_dataframe([1], schema=["a"])
>>> result1 = df.select(last_query_id().alias("QUERY_ID")).collect()
>>> assert len(result1) == 1
>>> assert isinstance(result1[0]["QUERY_ID"], str)
>>> assert len(result1[0]["QUERY_ID"]) > 0
>>> result2 = df.select(last_query_id(1).alias("QUERY_ID")).collect()
>>> assert len(result2) == 1
>>> assert isinstance(result2[0]["QUERY_ID"], str)
>>> assert len(result2[0]["QUERY_ID"]) > 0