I added dbt-utils to an existing dbt project. Things worked great on dev, but not prod (“worked on my machine!”) The error message was telling me that the dbt_project.yml file was missing from the python dependency for dbt-utils Not the most helpful error message. But I found the fix. I needed to run dbt deps (really uv run dbt deps) to get things fixed After that, no more errors
I was working on a job for a client and had extracted a subset of production data into a duckdb database. I then set up the DuckDB MCP client (with my read-only mode flag turned on) I then fired up Claude Desktop and entered the following (note some data has been blanked out for privacy): I want to use the PRODUCTION_SCHEDULE table to find gaps in the coming months where the nothing will be running on production lines with `line_number` LINEABC1 and LINEABC2. The table has one row per scheduled run and has START and END columns to show when each run will begin and end. Can you write a query that will show us the gaps in between these runs between today and the end of september, 2025? Claude sonnet 3.7 churned away for about 40 seconds and produced an excellent result: ...