The Triple D Stack: DLT + dbt™ + DuckDB

import dlt
from dlt.sources.sql_database import sql_database

# Extract data from your database
pipeline = dlt.pipeline(
    pipeline_name="sales_pipeline",
    destination="duckdb"
)

# Load to DuckDB
source = sql_database(connection_string="postgresql://...")
info = pipeline.run(source, table_name="raw_sales")

-- dbt™ (second D in DDD Stack) models/sales_metrics.sql
{{ config(materialized='table') }}

SELECT 
    date_trunc('month', order_date) as month,
    product_category,
    SUM(revenue) as total_revenue,
    COUNT(DISTINCT customer_id) as unique_customers
FROM {{ ref('raw_sales') }}
GROUP BY 1, 2

-- Query your transformed data efficiently
SELECT 
    month,
    product_category,
    total_revenue,
    LAG(total_revenue) OVER (
        PARTITION BY product_category 
        ORDER BY month
    ) as prev_month_revenue
FROM sales_metrics
WHERE month >= CURRENT_DATE - INTERVAL '6 months'

# project.visivo.yml
name: Sales Analytics

traces:
  - name: revenue-trend
    model: ref(sales_metrics)
    columns:
      x: month
      y: total_revenue
    props:
      type: scatter
      mode: lines+markers
      name: Revenue Trend

  - name: category-sales
    model: ref(sales_metrics)
    columns:
      x: product_category  
      y: total_revenue
    props:
      type: bar
      name: Sales by Category

charts:
  - name: revenue-chart
    traces:
      - ref(revenue-trend)
  
  - name: category-chart
    traces:
      - ref(category-sales)

dashboards:
  - name: Sales Overview
    rows:
      - height: medium
        items:
          - chart: ref(revenue-chart)
          - chart: ref(category-chart)