sql

{
  sql: `
    SELECT
      o.id,
      o.order_number,
      CAST(o.total_price AS DOUBLE) AS revenue,
      o.created_at,
      c.email AS customer_email
    FROM raw_orders o
    LEFT JOIN raw_customers c ON o.customer_id = c.id
    WHERE o.created_at >= '{{var.startDate}}'
  `,
  outputTable: "enriched_orders",
  outputSchema: {
    id: "VARCHAR",
    order_number: "INTEGER",
    revenue: "DOUBLE",
    created_at: "VARCHAR",
    customer_email: "VARCHAR",
  },
}