in case someone is looking for purely SQL based solution: (add LIMIT 1 to the query if you are looking for last op only)
select t.timestamp, t.operation, t.operationMetrics.numOutputRows as numOutputRows
from (
DESCRIBE HISTORY <catalog>.<schema>....
please see this documentation for accessing cloud storage by setting Unity Catalog objects: Storage Credential and External Location. https://docs.databricks.com/en/connect/unity-catalog/cloud-storage/index.html