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. |
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 |
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> |
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 |
teams
| Field |
Data type |
id |
BIGINT |
name |
STRING |
picture_url |
STRING |
users |
ARRAY<STRUCT<id: STRING>> |
| 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>> |
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 |
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 |