By Alex Rolnik

Monday.com

Integrates with:

The Monday.com Kit pulls in source data to the data warehouse from multiple reports. The logic within the kit uses some of these reports to recreate your Monday.com boards as views within the database.

If no specific boards are selected in the source reports, the Kit will create a table for each Monday.com board. To get specific boards as tables in the data warehouse, you will need to filter the Monday – Boards report. That is the table that provides the logic with what boards to recreate. In the database, each board’s table will have the prefix “Monday_Board_…”.

The subitems within a Monday.com board are all combined into one Subitems board per Parent board. The Subitem_ID within these boards will map to the parents’ boards using the Subitem_ID_List column. If a board does not have subitems, it is considered an Individual board and will not have the Subitem_ID or Subitem_ID_List fields within the board.

This Kit includes…

Data ingestion rivers for the following Monday.com reports:

A master orchestration logic river that recreates each Monday.com board and subitems board within the data warehouse.
 
For more information on the kit, see the data flow and data model diagrams below. 

Configuring this Kit for use

Variables

In this Kit, there are three variables that are used to make for dynamic use of target configuration. 

  • {DB_Monday} is used in all Target configurations and queries as the target database.
  • {SCHEMA_Monday} is used in all Target configurations and queries as the target schema.
  • {Monday_Alert_Group} is used as the alert email address(es) for when a river fails.

Go to the Variables menu on the left side navigation bar and create variables for DB_Monday, SCHEMA_Monday, and Monday_Alert_Group. Then fill in the values as the Snowflake database and schema where you would like the data to land and the email address(es) to which you would like the failure emails sent.

Connections

Kits are imported with ‘blank’ source and target connections. In order to use the Kit, you have two options:

  • Swap out blank connections with existing connections
  • Add credentials to the blank connections that come with the imported Kit

Have questions about this Kit?

Set up a meeting with a Rivery solutions engineer.

Time to Ride the River

Rivery is free to try - no credit card required.