Sendgrid Connector

SendGrid provides a cloud-based service that assists businesses with email delivery. The service manages various types of email including shipping notifications, friend requests, sign-up confirmations, and email newsletters.

4.8 on G2

Weld · Data Sources

Sendgrid

SendgridYour warehouseLive

segment9 columnsSynced

sender17 columnsSynced

legacy_campaign12 columnsSynced

legacy_segment_recipient11 columnsSyncing

legacy_segment_recipient_custom_field8 columnsQueued

Lands in

snowflake

bigquery

databricks

Agent context over MCP

How it works

Set up in minutes.
No code, no maintenance.

Sendgrid

Sendgrid

Data source

Authenticating...

Ready to connect

Overview

Sendgrid in your warehouse.
Ready for your agents.

SendGrid provides a cloud-based service that assists businesses with email delivery. The service manages various types of email including shipping notifications, friend requests, sign-up confirmations, and email newsletters. Weld's Sendgrid connector is fully managed: it extracts data from Sendgrid, 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

Sendgrid data schema.
The map your agents read.

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

tables: 40
fields: 335
relationships: 5

Loading diagram…

legacy_campaign

legacy_list_recipient

legacy_segment_recipient

state_province_region

event_webhook_setting

group_resubscribe

group_unsubscribe

global_unsubscribe

group_suppression

inbound_parse_setting

legacy_campaign

suppression_group_id

custom_unsubscribe_url

legacy_campaign_list

legacy_campaign_segment

legacy_campaign_category

legacy_category

legacy_category_stat

recipient_count

legacy_list_recipient

legacy_list_recipient_custom_field

recipient_count

legacy_segment_condition

legacy_segment_recipient

legacy_segment_recipient_custom_field

mailbox_provider_stat

last_event_time

sample_updated_at

template_version

generate_plain_content

unsubscribe_group

last_email_sent_at

Open the schema explorer Open the full schema explorer

Models

Sendgrid models.
What the numbers mean.

Open-source SQL that turns the raw Sendgrid tables into the reports people ask about. Deploy them in Weld and your agent queries the definitions, not guesses.

Open the models

Weld MCP server

Ask your agent.
It already knows Sendgrid.

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

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

Set up the MCP server

Claude CodeOpus 5

ConnectedWeld MCPAgent contextSendgridtables40fields335joins5

>

How many legacy_campaign rows do we have per sender? Use our Sendgrid data.

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

●weld·search_available_references

⎿raw.sendgrid.legacy_campaign

raw.sendgrid.sender

+ 38 more Sendgrid tables

●weld·get_reference_schema

⎿legacy_campaign · 12 columns

joins sender on sender_id

●weld·run_query

⎿select s.id, count(*) from {{raw.sendgrid.legacy_campaign}} l

join {{raw.sendgrid.sender}} s on l.sender_id = s.id

group by 1

submitted

●weld·get_query_status

⎿DONE

●weld·get_query_result

⎿rows returned

✓Answered from Sendgrid data in your warehouse

>Ask about your Sendgrid dataMCP

Destinations

Load Sendgrid 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 Sendgrid 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 Sendgrid ELT sync
curl -X POST https://connect.weld.app/elt_syncs \
  -H "x-api-key: $API_KEY" \
  -d '{
    "connection_id": "conn_abc123",
    "integration_id": "sendgrid",
    "destination_schema_name": "sendgrid_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 Sendgrid data to work.

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

Sendgrid

Source

Weld

MCPAgents

Start for free Talk to us

Connectors

Explore more connectors.
300+ and counting.

View all connectors