Workiva connector reference

Beta

This feature is in Beta. Workspace admins can control access to this feature from the Previews page. See Manage Databricks previews.

This page has reference information for the managed Workiva connector, including the supported source tables and their destination table schemas.

Supported source tables

The Workiva connector supports three source tables under the default source schema. The activities table supports incremental ingestion using the activityDateTime cursor field. The users and roles tables are ingested as full snapshots on each run.

Source table	Primary key	Description	Sync mode	Cursor field
activities	id	Audit activity events from your Workiva organization.	Incremental	activityDateTime
users	id	Users in your Workiva organization, from the organization user report.	Full snapshot	—
roles	id	Roles defined in your Workiva organization.	Full snapshot	—

Source table	Primary key	Description	Sync mode	Cursor field
activities	id	Audit activity events from your Workiva organization.	Incremental	activityDateTime
users	id	Users in your Workiva organization, from the organization user report.	Full snapshot	—
roles	id	Roles defined in your Workiva organization.	Full snapshot	—

Destination table schemas

activities

Field	Data type	Description
id	STRING	Primary key. Activity event identifier.
activityDateTime	TIMESTAMP	Event timestamp. The incremental cursor field.
summary	STRING	Human-readable summary of the activity.
outcome	STRING	Outcome of the activity, such as success or failure.
action	VARIANT	The action performed, as a nested object.
performer	VARIANT	The user or service that performed the action, as a nested object.
targets	VARIANT	The objects the action was performed on, as a nested array.
organization	VARIANT	The organization context of the activity, as a nested object.
workspace	VARIANT	The workspace context of the activity, as a nested object.
tags	VARIANT	Tags associated with the activity, as a nested array.
attachments	VARIANT	Attachments associated with the activity, as a nested array.

Field	Data type	Description
id	STRING	Primary key. Activity event identifier.
activityDateTime	TIMESTAMP	Event timestamp. The incremental cursor field.
summary	STRING	Human-readable summary of the activity.
outcome	STRING	Outcome of the activity, such as success or failure.
action	VARIANT	The action performed, as a nested object.
performer	VARIANT	The user or service that performed the action, as a nested object.
targets	VARIANT	The objects the action was performed on, as a nested array.
organization	VARIANT	The organization context of the activity, as a nested object.
workspace	VARIANT	The workspace context of the activity, as a nested object.
tags	VARIANT	Tags associated with the activity, as a nested array.
attachments	VARIANT	Attachments associated with the activity, as a nested array.

users

Field	Data type	Description
id	STRING	Primary key. User identifier.
type	STRING	Resource type of the record.
active	BOOLEAN	Whether the user is active.
displayName	STRING	Display name of the user.
email	STRING	Email address of the user.
firstName	STRING	First name of the user.
lastName	STRING	Last name of the user.
userName	STRING	Username of the user.
samlId	STRING	SAML identifier of the user.
lastLogin	TIMESTAMP	Timestamp of the user's last login.
licenses	VARIANT	Licenses assigned to the user, as a nested array.
organizationRoles	VARIANT	Organization-level roles assigned to the user, as a nested array.
workspaceMemberships	VARIANT	Workspace memberships of the user, as a nested array.

Field	Data type	Description
id	STRING	Primary key. User identifier.
type	STRING	Resource type of the record.
active	BOOLEAN	Whether the user is active.
displayName	STRING	Display name of the user.
email	STRING	Email address of the user.
firstName	STRING	First name of the user.
lastName	STRING	Last name of the user.
userName	STRING	Username of the user.
samlId	STRING	SAML identifier of the user.
lastLogin	TIMESTAMP	Timestamp of the user's last login.
licenses	VARIANT	Licenses assigned to the user, as a nested array.
organizationRoles	VARIANT	Organization-level roles assigned to the user, as a nested array.
workspaceMemberships	VARIANT	Workspace memberships of the user, as a nested array.

roles

Field	Data type	Description
id	STRING	Primary key. Role identifier.
name	STRING	Name of the role.

Field	Data type	Description
id	STRING	Primary key. Role identifier.
name	STRING	Name of the role.

Connector options

Option	Table	Description
start_datetime	activities	Optional. A UTC ISO-8601 timestamp (for example, 2025-01-01T00:00:00Z) that sets the start of the first-sync window for the activities table. When omitted, the connector backfills the previous 365 days.

Option	Table	Description
start_datetime	activities	Optional. A UTC ISO-8601 timestamp (for example, 2025-01-01T00:00:00Z) that sets the start of the first-sync window for the activities table. When omitted, the connector backfills the previous 365 days.