Tracking Exponam.Connect Usage from Delta Sharing System Audit Tables
Databricks Data publishers can track data access from Delta Sharing (generically) and Exponam.Connect (explicitly) via Databricks system audit tables. Monitoring this data requires a user to have Databricks Workstation access to the system audit tables.
From a Databricks Workstation, import the attached notebook. Follow the directions to insert your Databricks Workstation URL and access token. After running the notebook, the final Cmd will contain a data table with relevant data from which to analyze system usage.
Notes:
UserAgentProduct: the Exponam.Connect product being used - either the Pro edition running on Windows or the Web edition running on Mac / Office Web.
Platform: VSTO = Exponam.Connect on PC; Web = Exponam.Connect on Mac or Web.
userIdentifier = (MACHINE\user) if available OR (user) or UNKNOWN if this data is not available to the Add-in based on security settings.