Fourth Connector

Fourth is a leading brand that offers restaurant and hospitality-specific technology, services, and analytics to efficiently manage your workforce and inventory

4.8 on G2

Weld · Data Sources

Fourth

FourthYour warehouseLive

payroll22 columnsSynced

employee_payroll_period9 columnsSynced

shift36 columnsSynced

shift_forecast36 columnsSyncing

contractor_shift27 columnsQueued

Lands in

snowflake

bigquery

databricks

Agent context over MCP

How it works

Set up in minutes.
No code, no maintenance.

Fourth

Fourth

Data source

Authenticating...

Ready to connect

Overview

Fourth in your warehouse.
Ready for your agents.

Fourth is a leading brand that offers restaurant and hospitality-specific technology, services, and analytics to efficiently manage your workforce and inventory Weld's Fourth connector is fully managed: it extracts data from Fourth, loads it into your warehouse, and keeps it in sync. The data lands in a clean, documented schema with agent context attached, so analysts can query it with SQL or dbt, and agents can query it over the Weld MCP server without guessing at tables or joins.

Agent context

Fourth data schema.
The map your agents read.

Every table, field and relationship Weld syncs from Fourth is served to agents as context over MCP, so they pick the right tables and join on the right keys.

tables: 10
fields: 199
relationships: 1

Loading diagram…

contractor_shift

contractor_shift

location_canonical_id

department_name

contractor_shift_expense

expense_type_name

location_foreign_id

department_name

department_foreign_id

employee_payroll_period

period_tax_year

period_start_date

period_end_date

department_foreign_id

department_code

department_name

employee_foreign_id

employee_personnel_number

employee_forename

payroll_forecast

department_foreign_id

department_code

department_name

employee_foreign_id

employee_personnel_number

employee_forename

department_name

department_code

department_foreign_id

system_forecast

system_forecast_items

department_name

department_code

department_foreign_id

system_forecast

system_forecast_items

location_foreign_id

department_code

department_name

department_foreign_id

location_foreign_id

department_code

department_name

department_foreign_id

Open the schema explorer Open the full schema explorer

Weld MCP server

Ask your agent.
It already knows Fourth.

Connect Claude, Cursor, ChatGPT or your own agent to Weld over MCP. It reads the Fourth context, finds the tables it needs and queries your warehouse.

Agent contextFourth tables, fields and joins
QuerySQL against your warehouse
OperateCheck, rerun and refresh syncs

Set up the MCP server

Claude CodeOpus 5

ConnectedWeld MCPAgent contextFourthtables10fields199joins1

>

How many employee_payroll_period rows do we have per payroll? Use our Fourth data.

Reading the Fourth context first, so the query uses the right tables and keys.

●weld·search_available_references

⎿raw.fourth.employee_payroll_period

raw.fourth.payroll

+ 8 more Fourth tables

●weld·get_reference_schema

⎿employee_payroll_period · 9 columns

joins payroll on payroll_id

●weld·run_query

⎿select p.id, count(*) from {{raw.fourth.employee_payroll_period}} e

join {{raw.fourth.payroll}} p on e.payroll_id = p.id

group by 1

submitted

●weld·get_query_status

⎿DONE

●weld·get_query_result

⎿rows returned

✓Answered from Fourth data in your warehouse

>Ask about your Fourth dataMCP

Destinations

Load Fourth into any warehouse.
Set up in minutes, no code.

Resources

Everything you need.
To get started.

Connect your agents

Set up Claude, Cursor, ChatGPT or Codex against your Weld workspace.

Weld Connect API

Build custom connectors

Use the Weld Connect API to build and publish your own connector.

Common questions

Answers to frequently asked questions about Weld connectors.

Weld Connect API

Set it up in code.
One REST API.

Use the Weld Connect REST API to create Fourth connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.

Explore Weld Connect API reference

POST/elt_syncs

# Create a Fourth ELT sync
curl -X POST https://connect.weld.app/elt_syncs \
  -H "x-api-key: $API_KEY" \
  -d '{
    "connection_id": "conn_abc123",
    "integration_id": "fourth",
    "destination_schema_name": "fourth_data",
    "sync_interval": "0 * * * *"
  }'
▌

FAQ

Common questions.
About connectors.

Something not covered here? A data engineer can walk through your setup with you.

Put your Fourth data to work.

Connect Fourth, pick a warehouse, and your agents can query it today. Free for 14 days, no credit card.

Fourth

Source

Weld

MCPAgents

Start for free Talk to us

Connectors

Explore more connectors.
300+ and counting.

View all connectors