Author

Jonas Thordal

Co-founder & CEO

55 posts

Posts by Jonas Thordal

Tools & Platforms··24 min read

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.

News & Product updates··5 min read

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.

Tools & Platforms··21 min read

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.

News & Product updates··8 min read

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.

News & Product updates··16 min read

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.

News & Product updates··6 min read

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.

Tools & Platforms··11 min read

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.

News & Product updates··14 min read

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.

News & Product updates··13 min read

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.

News & Product updates··5 min read

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.

News & Product updates··5 min read

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.

News & Product updates··4 min read

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.

News & Product updates··5 min read

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.

Tools & Platforms··13 min read

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.

News & Product updates··4 min read

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.

News & Product updates··3 min read

Weld Product Updates – January 2026

This month, Weld introduced Weld Connect API, Shiphero, AppLovin and Amazon Attribution integrations as well as new connector updates.

News & Product updates··4 min read

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.

News & Product updates··3 min read

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.

News & Product updates··7 min read

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.

News & Product updates··3 min read

Weld Product Updates – November 2025

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

News & Product updates··4 min read

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.

News & Product updates··3 min read

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.

News & Product updates··2 min read

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.

Tools & Platforms··14 min read

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.

News & Product updates··3 min read

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.

News & Product updates··3 min read

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.

Tools & Platforms··16 min read

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.

News & Product updates··2 min read

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.

Unknown··6 min read

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.

Tools & Platforms··14 min read

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.

Tools & Platforms··5 min read

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.

Tools & Platforms··2 min read

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.

Tools & Platforms··4 min read

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.

News & Product updates··1 min read

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

News & Product updates··2 min read

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.

Tools & Platforms··2 min read

How to extract data from Freshdesk

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

Customer Stories··3 min read

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.

Unknown··6 min read

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.

News & Product updates··1 min read

New feature Alert: Audit Logs 🚨

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

News & Product updates··3 min read

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.

Unknown··17 min read

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.

News & Product updates··3 min read

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.

News & Product updates··3 min read

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.

News & Product updates··1 min read

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.

News & Product updates··1 min read

Weld August 2023 Updates

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

News & Product updates··4 min read

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.

Tools & Platforms··4 min read

​​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...

Tools & Platforms··3 min read

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.

News & Product updates··3 min read

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.

News & Product updates··3 min read

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.

Tools & Platforms··4 min read

How to measure (and improve) marketing performance

Boosting your marketing performance starts with tracking your efforts. Measure your marketing data with KPIs.

Tools & Platforms··8 min read

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.

Tools & Platforms··7 min read

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?

News & Product updates··5 min read

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.

Tools & Platforms··6 min read

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.