Anaplan connector reference

Important

This feature is in Beta. Workspace admins can control access to this feature from the Previews page. See Manage Azure 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

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.

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

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