Jonas Thordal
Co-founder & CEO
55 posts
Posts by Jonas Thordal

What is a semantic layer, and why AI agents need one
A semantic layer defines each metric once, so dashboards and AI agents give the same number. See a worked MRR example and dbt vs Cube vs Snowflake.

Weld Earns 28 G2 Badges in Fall 2026
Weld earned 28 G2 badges in Fall 2026, including Momentum Leader in three categories. What customers said on G2, and what we shipped since spring.

SCD Type 2 in SQL: MERGE, dbt Snapshots and History Tables
Build SCD Type 2 with a tested MERGE for BigQuery, Snowflake and Postgres or a dbt snapshot, and handle deletes, late rows and as-of queries.

Use agents in your Weld workspace
Ed now works as an agent on the same tools as the Weld MCP server: it searches your tables, checks its SQL against your warehouse and applies models.

Weld Product Updates – September 2026
Weld's September 2026 updates: Capture deletes (Beta), custom full sync schedules, Snowflake upper-case names and five new sources, including Walmart.

Weld is now an official MotherDuck technology partner
Weld is a MotherDuck technology partner for ingestion and reverse ETL, and MotherDuck is a Weld destination. Three ways teams combine the two.

The agent context stack: what AI agents need before they can answer "what is our revenue?"
AI agents give different answers and lose trust. Here's the agent context stack that fixes it: skills, MCP, a semantic layer, context and permissions.

Weld Product Updates – August 2026
August brought five new sources including Zoho CRM and Typeform, SQL Server as a destination, Microsoft Teams notifications and real Criteo campaign data.

Weld Product Updates – July 2026
July brought Gmail, Toast Analytics, HTTP File and Webhooks connectors, ClickHouse as a destination, and Reverse ETL management via API and MCP server.

Weld Product Updates – June 2026
June brought Snowflake as an ELT source, promo codes at checkout, new Google My Business Profile streams, and Fourth, Unleashed and SevenRooms connectors.

Weld Product Updates – May 2026
May brought the MCP server for AI tools, GitHub integration for data models, ShopifyQL reports, per-stream schedules, and Linear and Amazon Vendor Central.

Weld Product Updates – April 2026
April brought Viewer and Editor roles, a REST API for data models, bulk model import, four new connectors, and updates to Shopify, Amazon Ads and Stripe.

Weld Product Updates – March 2026
March 2026 in Weld: Klarna and PayPal connectors, a Usage Dashboard with forecasting, dbt-compatible model import and export, and connector updates.

Top 10 Fivetran Alternatives in 2026
Ten Fivetran alternatives compared on pricing, connectors and fit, with every price checked on the vendor's site and an honest take on when to stay.

Weld Product Updates – February 2026
February 2026 in Weld: Amazon Redshift as a destination, a Reddit Ads connector, multi ad account backfill, and updates to Google Ads, GA4 and Shopify.

Weld Product Updates – January 2026
This month, Weld introduced Weld Connect API, Shiphero, AppLovin and Amazon Attribution integrations as well as new connector updates.

Introducing Weld Connect - A Production-Ready REST API for Modern Data Teams
Weld Connect is a REST API for managing data across CRMs, finance systems, marketing platforms and analytics tools from your own code.

Weld Product Updates – December 2025
December 2025 in Weld: better Facebook, Shopify, Apple, TikTok and HubSpot connectors, faster CDC and BigQuery, plus usage tracking and billing tools.

2025 at Weld: Platform Progress, Connectors, and Infrastructure Milestones
A look back at the platform milestones, connector launches and infrastructure improvements that shaped Weld in 2025, and what we're building next.

Weld Product Updates – November 2025
November 2025 in Weld: Notion, LinkedIn Company Pages and LaunchDarkly connectors, BigQuery partitioning and clustering, and faster CDC.

Weld Product Updates – October 2025
October 2025 in Weld: Intercom, TikTok Ads and Klaviyo connectors, BigQuery as a source, groundwork for MySQL CDC, and better monitoring and stability.

Weld Product Updates - September 2025
September 2025 in Weld: PostgreSQL CDC testing, BigQuery table expiration monitoring, Shopify and Facebook Ads features, REST API updates and G2 badges.

Weld Product Updates – August 2025
August 2025 in Weld: a new transform tool setup flow, chunked syncs, sync triggers from Weld Transform, an AI upgrade to Ed and a Python pipeline guide.

Build vs Buy Data Pipelines: What It Really Costs to Own a Connector
Build your own data pipelines or buy a managed tool? What a connector must handle, a cost model you can redo with your numbers, and a decision matrix.

Weld Product Updates – July 2025
July 2025 in Weld: Snowflake key pair authentication, Amazon SP pricing data, Facebook Ads improvements, better orchestration and a Python pipeline guide.

Weld Product Updates – June 2025
June 2025 in Weld: a redesigned Reverse ETL flow, new marketing analytics tables, Xero Profit and Loss support and custom connector guides.

SQL vs NoSQL: Differences, Database Types and Which Data Goes Where
SQL vs NoSQL with one worked example: the same order as tables and as a document, queried both ways. Plus NoSQL types, ACID vs BASE and when to use each.

Weld Joins the dbt Labs Technology Integration Partner Program
Weld is now an official dbt Labs Technology Integration Partner, making it easier than ever for teams to sync, transform, and activate their data.

PostgreSQL vs. BigQuery – Which Data Warehouse Should You Choose?
PostgreSQL and BigQuery are two of the most popular data warehouses. We weigh the pros and cons of each to help you make the best decision.

Data Modeling Framework: The 5 Layers of a Data Warehouse
A five-layer data modeling framework for your warehouse: landing, raw, staging, core and analytics, with SQL taking Shopify and Facebook Ads through each.

2024: A year of innovation and big wins at Weld
From new AI-powered tools to innovative integrations, 2024 was transformative for Weld and our users. Dive into the highlights and see what’s next for 2025.

Weld ranks high on G2's Winter 2025 reports
Weld earned 30+ badges in G2's Winter 2025 reports, including Momentum Leader and High Performer in ETL Tools, Data Extraction and more.

Weld + Shopify: Powering your ecommerce brand with data
Weld's Shopify integration is one of our most used connectors. Learn how it works and see real-world use cases for your ecommerce business.

New feature Alert: Sync History Insights Chart
Finding and sorting data sources, as well as seeing a historical overview of your syncs, is now easier than ever

New feature Alert: Protected Tables & GPT-4o
Protected Tables let you lock tables to keep data safe, and Ed now runs on GPT-4o for faster SQL and auto-generated insights.

How to extract data from Freshdesk
Sync Freshdesk data with Weld to enhance customer support insights. Use ERD to map relationships and improve metrics.

How Juni saves 40+ hours a week on building and maintaining data pipelines
Juni uses Weld to sync data to its Customer Success, Marketing and Sales tools in real time, saving 40+ hours a week on pipelines.

What is Net Revenue Retention (NRR) and how do you calculate it?
Net Revenue Retention is a business metric widely used in subscibtion business. Learn how Learn how to calculate it and how to avoid common mistakes.

New feature Alert: Audit Logs 🚨
Introducing Audit Logs: Enhance account security and transparency with comprehensive tracking of user actions and operations.

Weld Secures Spot on G2's 2024 Best Software List
Weld has achieved a prestigious recognition by securing a position on G2's 2024 Best Software list, ranking in the Top 50 IT Infrastructure Products.

How to Calculate MRR: Formula, Components and a Worked Example
The MRR formula, its five components, the rules for annual plans, discounts, trials and tax, and a worked example with a full MRR bridge and SQL.

Empower Your Sales, Marketing and Customer Success Teams By Syncing Customer Data to HubSpot [2024 Update]
Weld now integrates with HubSpot. Sync customer data into HubSpot so your sales, marketing and customer success teams work from the same data.

A Year in Review: Weld's Journey in 2023
Highlights of 2023 including the Weld AI Assistant, Google BigQuery Usage Stats, SQL Templates, New Connectors, G2 Leader Batch and much more.

Weld November 2023 Updates
Weld in November 2023: YouTube Analytics, Google Drive, Search Console and Clerk.io connectors, BigQuery usage stats and monthly sync usage limits.

Weld August 2023 Updates
Facebook Ads custom reports, AI Assistant upgraded to GPT-4, Slack notifications, new SQL templates, ERD diagrams in documentation.

Highlights from 2022
A look back at Weld in 2022: better lineage, 50+ new standard connectors, custom connectors and orchestration, plus the features we planned next.

Is the future dominated by niche single product companies or will the bundled approach win?
The ‘modern data stack’ market is highly fragmented and dominated by many niche players, which is characteristic of an early stage industry before the...

Google Analytics is deemed unlawful in Denmark – now what?
Last week, Denmark was the fourth European country to deem Google Analytics as breaching GDPR. Here's what you can do about it.

Weld’s data lineage feature just leveled up, bringing even more visibility to your data ops
We expanded Lineage in Weld into a complete, end-to-end visual map of your data operations. What changed and how it helps you.
From Tracking Pixels to Conversion APIs - The Future of Facebook Ads
With today's rapidly changing ad platform landscape, the benefits of syncing customer data directly into Facebook Ads are many.

How to measure (and improve) marketing performance
Boosting your marketing performance starts with tracking your efforts. Measure your marketing data with KPIs.

How to Create a Sales Forecasting Model — Webinar Recap
Christian Sassano shared his methodology for building a sales forecasting model in a recent webinar. Read the recap and watch the replay here.

BigQuery vs. Snowflake – Which Data Warehouse should you choose?
Two of the most popular data warehouse options today are BigQuery and Snowflake. But, which one is best for your business?

The year in Weld – A look back at 2021
Weld turned one in 2021. Our highlights from the first year, and what we planned for 2022.

Build vs. Buy – How to approach the Modern Data Stack
Should you build you own modern data stack, or buy a ready-made solution? We consider the pros and cons in this quick guide.
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.