/dbt-date-spines

name: dbt-date-spines
type: skill

dbt Date Spine Hazard — Fixing current_date in Model Files

When This Applies

• `dbt_project_map` reports "WARNING: Models use current_date"
• `dbt run` produces far more rows than expected in a date-spine model

These are pre-shipped model SQL files in `models/` — you have direct write access. For general date spine syntax, see `duckdb-sql` skill section 2.

Fix Pattern

Edit the model SQL directly. Replace `current_date`/`current_timestamp`/`now()` with a data-driven endpoint — a subquery from the primary fact table:

-- Before:  ... CURRENT_DATE ...
-- After:   ... (SELECT MAX(order_date) FROM {{ ref('stg_orders') }}) ...

Use the fact table with the most rows, or the one referenced in the task instruction.

Package Model Override

If the flagged file is in `dbt_packages/` (marked "PACKAGE MODEL" in the warning): 1. Read the full SQL from the package model file 2. Create `models/<same_filename>.sql` — dbt prioritizes local models over package models 3. Paste the entire package SQL into the new file and replace `current_date` with the data-driven endpoint 4. Add `{{ config(materialized='table') }}` at the top

Example: if `dbt_packages/shopify_source/models/stg_shopify__order.sql` uses `current_date`:

-- models/stg_shopify__order.sql  (local override — copy ENTIRE package SQL here)
{{ config(materialized='table') }}
-- Replace current_date with a data-driven endpoint:
-- (SELECT MAX(order_date) FROM {{ ref('stg_orders') }})

Do NOT edit files inside `dbt_packages/` directly — `dbt deps` will overwrite your changes.

Finding the Right Date

Call `mcp__signalpilot__get_date_boundaries(connection_name="<id>")`. Use the primary fact table's max date (marked "USE THIS"). Never use the global max — dimension tables often have later dates.

Verification

dbt run --select <model_name>

SELECT MIN(date_col), MAX(date_col), COUNT(*) FROM <model_name>

The spine's max date must match the source data's endpoint, not today's date.