Anaplan 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 Anaplan connector, including supported source tables and destination table schemas.

Supported source tables

The Anaplan connector supports the following source tables, all under the default source schema:

Source table	Primary key	Description	Sync mode	Cursor field
audit_events	id	Audit trail events for your Anaplan tenant, such as user sign-ins, model and workspace changes, and administrative actions.	Incremental	createdDate
users	id	User accounts in your Anaplan tenant, including names, email addresses, and status.	Full refresh only

Source table	Primary key	Description	Sync mode	Cursor field
audit_events	id	Audit trail events for your Anaplan tenant, such as user sign-ins, model and workspace changes, and administrative actions.	Incremental	createdDate
users	id	User accounts in your Anaplan tenant, including names, email addresses, and status.	Full refresh only

Connector options

For usage in a pipeline definition, see Examples.

Option	Type	Scope	Required	Applies to	Description
start_datetime	string	Table	No	audit_events	Earliest audit event to ingest on the first sync, as an ISO 8601 UTC timestamp (for example, 2026-07-09T12:00:00Z). Defaults to 365 days before the first sync.

Option	Type	Scope	Required	Applies to	Description
start_datetime	string	Table	No	audit_events	Earliest audit event to ingest on the first sync, as an ISO 8601 UTC timestamp (for example, 2026-07-09T12:00:00Z). Defaults to 365 days before the first sync.

Destination table schemas

audit_events

Primary key: id Cursor field: createdDate

Field	Data type
id	BIGINT
eventTypeId	STRING
objectId	STRING
tenantId	STRING
userId	STRING
ipAddress	STRING
hostName	STRING
userAgent	STRING
message	STRING
success	BOOLEAN
createdDate	BIGINT
eventDate	BIGINT
createdTimeZone	STRING
eventTimeZone	STRING
additionalAttributes	VARIANT
checksum	STRING

Field	Data type
id	BIGINT
eventTypeId	STRING
objectId	STRING
tenantId	STRING
userId	STRING
ipAddress	STRING
hostName	STRING
userAgent	STRING
message	STRING
success	BOOLEAN
createdDate	BIGINT
eventDate	BIGINT
createdTimeZone	STRING
eventTimeZone	STRING
additionalAttributes	VARIANT
checksum	STRING

note

This table does not support SCD type 2 because it has VARIANT columns.

users

Primary key: id Sync mode: Full refresh only

Field	Data type
id	STRING
email	STRING
firstName	STRING
lastName	STRING
active	BOOLEAN
customerId	STRING
emailOptIn	BOOLEAN
lastLoginDate	STRING

Field	Data type
id	STRING
email	STRING
firstName	STRING
lastName	STRING
active	BOOLEAN
customerId	STRING
emailOptIn	BOOLEAN
lastLoginDate	STRING