Monday.com connector reference

Beta

This feature is in Beta. To use it, a workspace admin must turn on Lakeflow Connect for Monday.com from the Previews page. See Manage Databricks previews.

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

Connector options

The Monday.com connector supports the following configuration options. Set pipeline-scoped options in the source_configurations block and table-scoped options in the connector_options block of each table in your pipeline definition. See Examples for usage.

Option	Type	Scope	Required	Applies to	Description
`start_datetime`	String (ISO 8601, `yyyy-MM-dd'T'HH:mm:ss'Z'`)	Pipeline	No	`activity_logs` table	Earliest timestamp from which to ingest activity logs, in ISO 8601 UTC format (for example, `2026-01-01T00:00:00Z`). Defaults to the Unix epoch, so the first sync ingests all available history. Has no effect on the full-refresh batch tables (`boards`, `users`, `teams`, `tags`, `workspaces`, and `updates`).
`board_ids`	Array of strings	Table	No	`boards` and `activity_logs` tables	Board IDs to ingest, specified as a JSON array of ID strings (for example, `["1234567890","1234567891"]`). When set, the connector ingests only the specified boards and the activity logs for those boards. When omitted, the connector ingests all boards in the account. Set this option on both tables so that each covers the same boards.

Option	Type	Scope	Required	Applies to	Description
`start_datetime`	String (ISO 8601, `yyyy-MM-dd'T'HH:mm:ss'Z'`)	Pipeline	No	`activity_logs` table	Earliest timestamp from which to ingest activity logs, in ISO 8601 UTC format (for example, `2026-01-01T00:00:00Z`). Defaults to the Unix epoch, so the first sync ingests all available history. Has no effect on the full-refresh batch tables (`boards`, `users`, `teams`, `tags`, `workspaces`, and `updates`).
`board_ids`	Array of strings	Table	No	`boards` and `activity_logs` tables	Board IDs to ingest, specified as a JSON array of ID strings (for example, `["1234567890","1234567891"]`). When set, the connector ingests only the specified boards and the activity logs for those boards. When omitted, the connector ingests all boards in the account. Set this option on both tables so that each covers the same boards.

Supported source tables

The Monday.com connector supports the following source tables, all under the default source schema:

Source table	Primary key	Description	Sync mode	Cursor field
`boards`	`id`	Boards in your Monday.com account, including their columns, groups, and settings.	Full refresh only
`users`	`id`	Users in your Monday.com account, including their roles and contact details.	Full refresh only
`teams`	`id`	Teams in your Monday.com account and their members.	Full refresh only
`tags`	`id`	Tags defined in your Monday.com account.	Full refresh only
`workspaces`	`id`	Workspaces in your Monday.com account and their settings.	Full refresh only
`updates`	`id`	Updates posted on items, including replies and attached assets.	Full refresh only
`activity_logs`	`id`	Board activity events, such as item and column changes, across your boards.	Incremental	`created_at_int`

Source table	Primary key	Description	Sync mode	Cursor field
`boards`	`id`	Boards in your Monday.com account, including their columns, groups, and settings.	Full refresh only
`users`	`id`	Users in your Monday.com account, including their roles and contact details.	Full refresh only
`teams`	`id`	Teams in your Monday.com account and their members.	Full refresh only
`tags`	`id`	Tags defined in your Monday.com account.	Full refresh only
`workspaces`	`id`	Workspaces in your Monday.com account and their settings.	Full refresh only
`updates`	`id`	Updates posted on items, including replies and attached assets.	Full refresh only
`activity_logs`	`id`	Board activity events, such as item and column changes, across your boards.	Incremental	`created_at_int`

Destination table schemas

`boards`

Field	Data type
`id`	`STRING`
`name`	`STRING`
`board_kind`	`STRING`
`type`	`STRING`
`columns`	`ARRAY<STRUCT<`archived`: BOOLEAN,` description`: STRING,` id`: STRING,` settings_str`: STRING,` title`: STRING,` type`: STRING,` width`: BIGINT>>`
`communication`	`STRING`
`description`	`STRING`
`groups`	`ARRAY<STRUCT<`archived`: BOOLEAN,` color`: STRING,` deleted`: BOOLEAN,` id`: STRING,` position`: STRING,` title`: STRING>>`
`owners`	`ARRAY<STRUCT<`id`: STRING>>`
`creator`	`STRUCT<`id`: STRING>`
`permissions`	`STRING`
`state`	`STRING`
`subscribers`	`ARRAY<STRUCT<`id`: STRING>>`
`tags`	`ARRAY<STRUCT<`id`: STRING>>`
`top_group`	`STRUCT<`id`: STRING>`
`updated_at`	`TIMESTAMP`
`updated_at_int`	`BIGINT`
`updates`	`ARRAY<STRUCT<`id`: STRING>>`
`views`	`ARRAY<STRUCT<`id`: STRING,` name`: STRING,` settings_str`: STRING,` type`: STRING,` view_specific_data_str`: STRING>>`
`workspace`	`STRUCT<`id`: STRING,` name`: STRING,` kind`: STRING,` description`: STRING>`

Field	Data type
`id`	`STRING`
`name`	`STRING`
`board_kind`	`STRING`
`type`	`STRING`
`columns`	`ARRAY<STRUCT<`archived`: BOOLEAN,` description`: STRING,` id`: STRING,` settings_str`: STRING,` title`: STRING,` type`: STRING,` width`: BIGINT>>`
`communication`	`STRING`
`description`	`STRING`
`groups`	`ARRAY<STRUCT<`archived`: BOOLEAN,` color`: STRING,` deleted`: BOOLEAN,` id`: STRING,` position`: STRING,` title`: STRING>>`
`owners`	`ARRAY<STRUCT<`id`: STRING>>`
`creator`	`STRUCT<`id`: STRING>`
`permissions`	`STRING`
`state`	`STRING`
`subscribers`	`ARRAY<STRUCT<`id`: STRING>>`
`tags`	`ARRAY<STRUCT<`id`: STRING>>`
`top_group`	`STRUCT<`id`: STRING>`
`updated_at`	`TIMESTAMP`
`updated_at_int`	`BIGINT`
`updates`	`ARRAY<STRUCT<`id`: STRING>>`
`views`	`ARRAY<STRUCT<`id`: STRING,` name`: STRING,` settings_str`: STRING,` type`: STRING,` view_specific_data_str`: STRING>>`
`workspace`	`STRUCT<`id`: STRING,` name`: STRING,` kind`: STRING,` description`: STRING>`

`users`

Field	Data type
`birthday`	`TIMESTAMP`
`country_code`	`STRING`
`created_at`	`TIMESTAMP`
`join_date`	`STRING`
`email`	`STRING`
`enabled`	`BOOLEAN`
`id`	`STRING`
`is_admin`	`BOOLEAN`
`is_guest`	`BOOLEAN`
`is_pending`	`BOOLEAN`
`is_view_only`	`BOOLEAN`
`is_verified`	`BOOLEAN`
`location`	`STRING`
`mobile_phone`	`STRING`
`name`	`STRING`
`phone`	`STRING`
`photo_original`	`STRING`
`photo_small`	`STRING`
`photo_thumb`	`STRING`
`photo_thumb_small`	`STRING`
`photo_tiny`	`STRING`
`time_zone_identifier`	`STRING`
`title`	`STRING`
`url`	`STRING`
`utc_hours_diff`	`BIGINT`

Field	Data type
`birthday`	`TIMESTAMP`
`country_code`	`STRING`
`created_at`	`TIMESTAMP`
`join_date`	`STRING`
`email`	`STRING`
`enabled`	`BOOLEAN`
`id`	`STRING`
`is_admin`	`BOOLEAN`
`is_guest`	`BOOLEAN`
`is_pending`	`BOOLEAN`
`is_view_only`	`BOOLEAN`
`is_verified`	`BOOLEAN`
`location`	`STRING`
`mobile_phone`	`STRING`
`name`	`STRING`
`phone`	`STRING`
`photo_original`	`STRING`
`photo_small`	`STRING`
`photo_thumb`	`STRING`
`photo_thumb_small`	`STRING`
`photo_tiny`	`STRING`
`time_zone_identifier`	`STRING`
`title`	`STRING`
`url`	`STRING`
`utc_hours_diff`	`BIGINT`

`teams`

Field	Data type
`id`	`BIGINT`
`name`	`STRING`
`picture_url`	`STRING`
`users`	`ARRAY<STRUCT<`id`: STRING>>`

`tags`

Field	Data type
`color`	`STRING`
`id`	`STRING`
`name`	`STRING`

`workspaces`

Field	Data type
`created_at`	`TIMESTAMP`
`description`	`STRING`
`id`	`STRING`
`kind`	`STRING`
`name`	`STRING`
`state`	`STRING`
`account_product`	`STRUCT<`id`: STRING,` kind`: STRING>`
`owners_subscribers`	`ARRAY<STRUCT<`id`: STRING>>`
`settings`	`STRUCT<`icon`: STRUCT<`color`: STRING,` image`: STRING>>`
`team_owners_subscribers`	`ARRAY<STRUCT<`id`: STRING,` name`: STRING>>`
`teams_subscribers`	`ARRAY<STRUCT<`id`: STRING,` name`: STRING>>`
`users_subscribers`	`ARRAY<STRUCT<`id`: STRING>>`

Field	Data type
`created_at`	`TIMESTAMP`
`description`	`STRING`
`id`	`STRING`
`kind`	`STRING`
`name`	`STRING`
`state`	`STRING`
`account_product`	`STRUCT<`id`: STRING,` kind`: STRING>`
`owners_subscribers`	`ARRAY<STRUCT<`id`: STRING>>`
`settings`	`STRUCT<`icon`: STRUCT<`color`: STRING,` image`: STRING>>`
`team_owners_subscribers`	`ARRAY<STRUCT<`id`: STRING,` name`: STRING>>`
`teams_subscribers`	`ARRAY<STRUCT<`id`: STRING,` name`: STRING>>`
`users_subscribers`	`ARRAY<STRUCT<`id`: STRING>>`

`updates`

Field	Data type
`assets`	`ARRAY<STRUCT<`created_at`: TIMESTAMP,` file_extension`: STRING,` file_size`: BIGINT,` id`: STRING,` name`: STRING,` original_geometry`: STRING,` public_url`: STRING,` uploaded_by`: STRUCT<`id`: STRING>,` url`: STRING,` url_thumbnail`: STRING>>`
`body`	`STRING`
`created_at`	`TIMESTAMP`
`creator_id`	`STRING`
`id`	`STRING`
`item_id`	`STRING`
`replies`	`ARRAY<STRUCT<`id`: STRING,` creator_id`: STRING,` created_at`: TIMESTAMP,` text_body`: STRING,` updated_at`: TIMESTAMP,` body`: STRING>>`
`text_body`	`STRING`
`updated_at`	`TIMESTAMP`

Field	Data type
`assets`	`ARRAY<STRUCT<`created_at`: TIMESTAMP,` file_extension`: STRING,` file_size`: BIGINT,` id`: STRING,` name`: STRING,` original_geometry`: STRING,` public_url`: STRING,` uploaded_by`: STRUCT<`id`: STRING>,` url`: STRING,` url_thumbnail`: STRING>>`
`body`	`STRING`
`created_at`	`TIMESTAMP`
`creator_id`	`STRING`
`id`	`STRING`
`item_id`	`STRING`
`replies`	`ARRAY<STRUCT<`id`: STRING,` creator_id`: STRING,` created_at`: TIMESTAMP,` text_body`: STRING,` updated_at`: TIMESTAMP,` body`: STRING>>`
`text_body`	`STRING`
`updated_at`	`TIMESTAMP`

`activity_logs`

Field	Data type
`id`	`STRING`
`account_id`	`STRING`
`user_id`	`STRING`
`event`	`STRING`
`data`	`STRING`
`entity`	`STRING`
`created_at`	`STRING`
`created_at_int`	`BIGINT`
`pulse_id`	`BIGINT`
`board_id`	`BIGINT`

Connector options​

Supported source tables​

Destination table schemas​

boards​

users​

teams​

tags​

workspaces​

updates​

activity_logs​