Workday Activity Logging connector reference

Beta

This feature is in Beta. To use it, a workspace admin must turn on Lakeflow Connect for Workday Activity Logging from the Previews page. See Manage Databricks previews.

Reference information for the managed Workday Activity Logging connector, including the supported source table and the activity_logging destination schema.

Supported source tables

The Workday Activity Logging connector uses the Workday Privacy API v1 activityLogging endpoint and supports the following source table under the default source schema:

Source table	Primary key	Description	Sync mode	Cursor field
activity_logging	lw_id	User activity log events from your Workday tenant.	Incremental, append-only	time

Source table	Primary key	Description	Sync mode	Cursor field
activity_logging	lw_id	User activity log events from your Workday tenant.	Incremental, append-only	time

Connector options

The Workday Activity Logging connector has no additional configuration options beyond the pipeline settings available for all managed connectors. See Examples.

Destination table schemas

activity_logging

Primary key: lw_id Cursor field: time

Field	Data type
lw_id	STRING
time	TIMESTAMP
systemAccount	STRING
activityAction	STRING
requestTime	TIMESTAMP
userAgent	STRING
taskId	STRING
deviceType	STRING
ipAddress	STRING
userActivityEntryCount	LONG
sessionId	STRING
target	STRUCT<id: STRING, descriptor: STRING, href: STRING>
taskDisplayName	STRING

Field	Data type
lw_id	STRING
time	TIMESTAMP
systemAccount	STRING
activityAction	STRING
requestTime	TIMESTAMP
userAgent	STRING
taskId	STRING
deviceType	STRING
ipAddress	STRING
userActivityEntryCount	LONG
sessionId	STRING
target	STRUCT<id: STRING, descriptor: STRING, href: STRING>
taskDisplayName	STRING

note

This table doesn't support SCD type 2 because activity log records are append-only.

Required Workday account permissions

Permission	Required for
View access to the System Auditing domain under Report/Task Permissions	Reading user activity log reports
Get access to the System Auditing domain under Integration Permissions	Reading user activity log data through the API

Permission	Required for
View access to the System Auditing domain under Report/Task Permissions	Reading user activity log reports
Get access to the System Auditing domain under Integration Permissions	Reading user activity log data through the API