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

Supported source tables

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

Source table	Primary key	Description	Sync mode	Cursor field
`audit_logs`	`_id`	Account audit trail of create, update, and delete operations on resources, with the acting user and field-level changes.	Incremental	`time`

Source table	Primary key	Description	Sync mode	Cursor field
`audit_logs`	`_id`	Account audit trail of create, update, and delete operations on resources, with the acting user and field-level changes.	Incremental	`time`

Option	Type	Scope	Required	Applies to	Description
`start_datetime`	`string`	Table	No	`audit_logs`	ISO-8601 UTC datetime for the first sync's backfill start. Defaults to 365 days before the first sync.

See Examples for usage.

Primary key: _id Cursor field: time

Field	Data type
`_id`	`STRING`
`time`	`TIMESTAMP`
`event`	`STRING`
`source`	`STRING`
`resourceType`	`STRING`
`_resourceId`	`STRING`
`support`	`BOOLEAN`
`byUser`	`STRUCT<_id: STRING, email: STRING, name: STRING>`
`fieldChanges`	`ARRAY<STRUCT<fieldPath: STRING, oldValue: STRING, newValue: STRING>>`
`deletedInfo`	`STRUCT<name: STRING, _integrationId: STRING, _abstractFlowId: STRING, _syncId: STRING>`

Field	Data type
`_id`	`STRING`
`time`	`TIMESTAMP`
`event`	`STRING`
`source`	`STRING`
`resourceType`	`STRING`
`_resourceId`	`STRING`
`support`	`BOOLEAN`
`byUser`	`STRUCT<_id: STRING, email: STRING, name: STRING>`
`fieldChanges`	`ARRAY<STRUCT<fieldPath: STRING, oldValue: STRING, newValue: STRING>>`
`deletedInfo`	`STRUCT<name: STRING, _integrationId: STRING, _abstractFlowId: STRING, _syncId: STRING>`