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

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
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. Cursor field: created_at_int.	Incremental

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>>

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>>

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