#dbt

Posts tagged #dbt

1. Article

   Why finance and marketing never agree on revenue (checklist from 6 months of pain)

   Every month same meeting. Marketing dashboard say revenue X, finance report say Y, difference 4-8%, and data team (me) is asked to explain. After 6 months I made a checklist. Sharing in case it help someone. Where the numbers split Gross vs net. Marketing count order value at checkout. Finance count after cancellations, refunds and returns. Biggest gap is always this one. Which date. Order date, payment date,…

   Lin WeiSep 27, 20264likes3comments

2. Question

   dbt incremental model getting duplicate rows when late data arrive, how to fix?

   Using dbt on BigQuery. Orders model is incremental, source table get updated when order status change (paid, shipped, refunded). Model look like this: {{ config(materialized='incremental') }} select order_id, status, amount, updated_at from {{ source('shop', 'orders') }} {% if is_incremental() %} where updated_at > (select max(updated_at) from {{ this }}) {% endif %} Problem 1: same order_id appear multiple times…

   Lin WeiAug 28, 20262likes3comments