Getting it into your agent
One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.
git clone --depth 1 https://github.com/hamzaamjad/cursor-rulesWrote this? Show the measurements
A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.
[](https://agentmods.dev/rules/hamzaamjad/cursor-rules/207-dbt-incremental-loading-patterns)<a href="https://agentmods.dev/rules/hamzaamjad/cursor-rules/207-dbt-incremental-loading-patterns"><img src="https://agentmods.dev/badge/rules/hamzaamjad/cursor-rules/207-dbt-incremental-loading-patterns/github.svg" alt="Measured on agentmods" height="20"></a>Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.
<a href="https://agentmods.dev/rules/hamzaamjad/cursor-rules/207-dbt-incremental-loading-patterns"><img src="https://agentmods.dev/badge/rules/hamzaamjad/cursor-rules/207-dbt-incremental-loading-patterns.svg" alt="Reviewed on agentmods" width="80" height="20"></a>What it costs to keep this loaded
Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.
| Model | Per session | Once invoked |
|---|---|---|
| Fable 5.1 | $0.00000 | $0.00315 |
| Opus 5.5 | $0.00000 | $0.00126 |
| Sonnet 5.5 | $0.00000 | $0.00063 |
| Haiku 4.5 | $0.00000 | $0.00032 |
Grade A, and why
207-dbt-incremental-loading-patterns scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 1mo ago.
A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.
Nothing flagged
None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.
What it actually says
dbt-incremental-loading-patterns
Purpose: Ensure reliable and performant incremental loads in dbt models.
1. Multi-Timestamp Tracking
- Track all relevant timestamps (e.g.,
created_at,updated_at, related entities) to avoid missed updates. - Example filter:
WHERE orders.created_at > (SELECT MAX(created_at) FROM {{ this }}) OR orders.updated_at > (SELECT MAX(updated_at) FROM {{ this }})
2. Time-Window Backfill
- Support variable backfill windows via
vars, e.g.backfill_days. - Use conditional logic to backfill a recent window without full refresh.
3. Incremental Predicates
- Use
incremental_predicatesfor database-driven merge conditions.
4. Conditional Full Refresh
- Toggle between
tableandincrementalbased on aforce_refreshvar.
5. Partitioned Incremental Models
- Combine clustering/partitioning with incremental filters for large tables (Snowflake/BigQuery).
6. Insert-Overwrite Strategy
- Use
insert_overwritefor partition-level refreshes in supported warehouses.
7. Lookback Window
- Reprocess recent partitions via a configurable lookback window to catch late-arriving data.
References: knowledge_base/data_modeling/dbt/incremental_loading_patterns.md
What this file has done since we first saw it
Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.
- 1mo ago First seen · 37 lines · 0 tokens per session scan A c1efe614990a
207-dbt-incremental-loading-patterns is a cursor rule published in the GitHub repository hamzaamjad/cursor-rules (2 stars, last pushed 1y ago), licensed MIT. It costs nothing until one of its globs matches a file; then it loads 315 tokens. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-31.
Other cursor rules, from other repositories
as-contract-cast-smell
// ❌ WRONG — bypasses the family ContractSerializer seam const contract = JSON.parse(raw) as Contract; const contract = JSON.parse(raw) as Contract .
no-backward-compatibility
Do not add backward-compatibility shims or migration scaffolding.
postgresql
This guide defines the definitive best practices for writing clean, performant, and maintainable PostgreSQL SQL, focusing on modern conventions and avoiding common pitfalls.
ehs-ims-conventions
EHS IMS app — RBAC, data layer, tRPC, migrations, AI boundaries.
sync-timedb-archive-janitor-contract
Day-close / cold-path worker contracts for synctimedb (A invariants; B tick coordinator retired).
schema
Scalable and secure schema design patterns for relational databases, NoSQL, and APIs. / TR: İlişkisel veri tabanları, NoSQL ve API'ler için ölçeklenebilir ve güvenli şema tasarım kalıpları.