Anthropic 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 provides reference information for the Anthropic connector, including supported tables and their schemas.

Supported source tables

The Anthropic connector supports the following source tables:

Source table	Primary key	Description	Sync mode	Cursor field
`audit_log_activities`	`id`	Compliance Activity Feed entries for your Anthropic organization. Each row is an audit activity event, with the raw event payload preserved in the `actor` column.	Incremental	`created_at`
`organizations`	`uuid`	Organizations in your Anthropic account. This is the directory root that the `users`, `roles`, and `settings` tables are ingested per.	Full refresh only
`users`	`org_uuid`, `id`	Users in each organization. Requires the `read:compliance_user_data` scope on the Compliance Access Key.	Full refresh only
`roles`	`org_uuid`, `id`	Roles defined in each organization.	Full refresh only
`groups`	`id`	Groups in your Anthropic organization.	Full refresh only
`settings`	`organization_id`, `name`	Effective compliance settings for each organization, one row per setting. The setting value is preserved in the `value` column.	Full refresh only
`chats`	`id`	Content metadata for claude.ai chats, ingested per user.	Incremental	`updated_at`
`messages`	`id`	Full message content for claude.ai chats, ingested per chat. Message content, files, generated files, and artifacts are preserved in `VARIANT` columns.	Incremental	`created_at`

Source table	Primary key	Description	Sync mode	Cursor field
`audit_log_activities`	`id`	Compliance Activity Feed entries for your Anthropic organization. Each row is an audit activity event, with the raw event payload preserved in the `actor` column.	Incremental	`created_at`
`organizations`	`uuid`	Organizations in your Anthropic account. This is the directory root that the `users`, `roles`, and `settings` tables are ingested per.	Full refresh only
`users`	`org_uuid`, `id`	Users in each organization. Requires the `read:compliance_user_data` scope on the Compliance Access Key.	Full refresh only
`roles`	`org_uuid`, `id`	Roles defined in each organization.	Full refresh only
`groups`	`id`	Groups in your Anthropic organization.	Full refresh only
`settings`	`organization_id`, `name`	Effective compliance settings for each organization, one row per setting. The setting value is preserved in the `value` column.	Full refresh only
`chats`	`id`	Content metadata for claude.ai chats, ingested per user.	Incremental	`updated_at`
`messages`	`id`	Full message content for claude.ai chats, ingested per chat. Message content, files, generated files, and artifacts are preserved in `VARIANT` columns.	Incremental	`created_at`

Connector options

The Anthropic connector has no additional configuration options beyond the pipeline settings available for all managed connectors. See Ingest data from Anthropic.

Destination table schemas

`audit_log_activities`

Primary key: id Cursor field: created_at

Field	Data type
`id`	`STRING`
`created_at`	`STRING`
`type`	`STRING`
`organization_id`	`STRING`
`organization_uuid`	`STRING`
`actor`	`VARIANT`
`claude_chat_id`	`STRING`
`claude_project_id`	`STRING`

`organizations`

Primary key: uuid Sync mode: Full refresh only

Field	Data type
`uuid`	`STRING`
`name`	`STRING`
`created_at`	`STRING`

`users`

Primary key: org_uuid, id Sync mode: Full refresh only

Field	Data type
`org_uuid`	`STRING`
`id`	`STRING`
`full_name`	`STRING`
`email`	`STRING`
`organization_role`	`STRING`
`created_at`	`STRING`

`roles`

Primary key: org_uuid, id Sync mode: Full refresh only

Field	Data type
`org_uuid`	`STRING`
`id`	`STRING`
`name`	`STRING`
`description`	`STRING`
`created_at`	`STRING`
`updated_at`	`STRING`

`groups`

Primary key: id Sync mode: Full refresh only

Field	Data type
`id`	`STRING`
`name`	`STRING`
`description`	`STRING`
`source_type`	`STRING`
`roles`	`ARRAY<STRING>`
`created_at`	`STRING`
`updated_at`	`STRING`

`settings`

Primary key: organization_id, name Sync mode: Full refresh only

Field	Data type
`organization_id`	`STRING`
`name`	`STRING`
`type`	`STRING`
`value`	`VARIANT`

`chats`

Primary key: id Cursor field: updated_at

Field	Data type
`id`	`STRING`
`user_id`	`STRING`
`name`	`STRING`
`created_at`	`STRING`
`updated_at`	`STRING`
`deleted_at`	`STRING`
`model`	`STRING`
`organization_id`	`STRING`
`organization_uuid`	`STRING`
`project_id`	`STRING`
`href`	`STRING`
`is_deleted`	`BOOLEAN`

`messages`

Primary key: id Cursor field: created_at

Field	Data type
`chat_id`	`STRING`
`id`	`STRING`
`role`	`STRING`
`content`	`VARIANT`
`files`	`VARIANT`
`generated_files`	`VARIANT`
`artifacts`	`VARIANT`
`created_at`	`STRING`

Supported source tables​

Connector options​

Destination table schemas​

audit_log_activities​

organizations​

users​

roles​

groups​

settings​

chats​

messages​