snowflake.snowpark.functions.last_query_id¶
- snowflake.snowpark.functions.last_query_id(num: Union[snowflake.snowpark.column.Column, str] = None) Column [source]¶
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:
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