snowflake.snowpark.functions.last_transaction¶

snowflake.snowpark.functions.last_transaction() → Column[source]¶

Returns the query ID of the last transaction committed or rolled back in the current session. If no transaction has been committed or rolled back in the current session, returns NULL.

Returns:

The last transaction.

Return type:

Column

Example:

CopyExpand

>>> df = session.create_dataframe([1])
>>> result = df.select(last_transaction()).collect()
>>> # Result will be None if no transaction has occurred
>>> assert result[0]['LAST_TRANSACTION()'] is None or isinstance(result[0]['LAST_TRANSACTION()'], str)

Show lessSee more

Scroll to top