Oliver O'Connor Betting
Data Engineer & Technical Writer
7 posts
Posts by Oliver O'Connor Betting

Weld Product Updates: October 2026
Weld's October 2026 updates: Ed now works as an agent, plus a new Overview page, multi-destination syncs and five new sources, including PagerDuty.

MCP Servers for Your Data Warehouse, Compared
See what the Snowflake, BigQuery, dbt and Weld MCP servers can actually do on three real tasks, with setup and permissions for each.

How to Migrate from dbt Cloud to dbt Core
How to move a dbt project from dbt Cloud to self-hosted dbt Core in 2026: what you lose, pricing, GitHub Actions jobs, Slim CI, docs and a safe cutover.

Weld MCP Server: Let Claude Manage Your Data Pipeline
Query your data warehouse and manage ELT pipelines from inside Claude. What the Weld MCP server can do, with a case study and examples clients use.

dbt in VS Code: The Official Extension, LLMs & Agentic Workflows
Set up dbt in VS Code with the official extension, then add GitHub Copilot, Claude Code, dbt MCP and agentic build and fix loops, plus Weld for ingestion.

How to Use Claude Code with dbt: AI-Powered Data Transformation Workflows
How to use Claude Code for dbt: project setup, model generation, agentic build and fix loops, the dbt MCP server, and Weld for data ingestion.

Update: Amazon Ads sponsored_product_ad_group upgraded to v3
Weld has updated its Amazon Ads integration to accommodate recent changes in the Amazon Ads API. Learn about the new table structures and field modifications.
Build the foundation
your AI runs on.
Connect your sources, keep them synced to your warehouse, and give every agent data it can trust. Free for 14 days, no credit card.