cianfhoghlaim/cianchosaint / .agents/skills/dlt
dlt
Verified| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 20.6 KB |
| references/crawl4ai-dlt-summary.md | markdown | 1.8 KB |
| references/dagster-dlt-assets.md | markdown | 3.9 KB |
| references/deploy-gcp-cloud-function-webhook.md | markdown | 2.1 KB |
| references/deploy-gcp-cloud-function.md | markdown | 2.0 KB |
| references/deploy-gcp-cloud-run.md | markdown | 2.4 KB |
| references/deploy-modal.md | markdown | 2.6 KB |
| references/destinations-cognee-memgraph.md | markdown | 3.3 KB |
| references/destinations-graphiti.md | markdown | 3.0 KB |
| references/destinations-lancedb.md | markdown | 3.4 KB |
| references/dlt-baml-orpc-mcp-typesafe-pipeline-analysis.md | markdown | 20.0 KB |
| references/dlt-transformations.md | markdown | 3.3 KB |
| references/dlthub-codebase-analysis.md | markdown | 32.4 KB |
| references/dlthub.md | markdown | 12.5 KB |
| references/openapi-generator.md | markdown | 2.3 KB |
| references/performance-optimisation.md | markdown | 3.3 KB |
| references/sqlmesh-init.md | markdown | 1.7 KB |
| references/type-safe-pipeline.md | markdown | 4.4 KB |
references/sqlmesh-init.md
View on GitHub# SQLMesh Init (hand off to the sqlmesh skill)
SQLMesh is a dbt-compatible SQL transformation framework. The
`sqlmesh init -t dlt` command bootstraps a SQLMesh project that
reads from a dlt-pipeline-managed DuckLake / MotherDuck destination
and applies SQL transformations downstream.
## Command
```bash
sqlmesh init -t dlt --dlt-pipeline <dlt-pipeline-name> <dialect>
```
Where:
- `<dlt-pipeline-name>` is the dlt pipeline name (e.g.
`ireland_curriculum`)
- `<dialect>` is the SQL dialect (e.g. `duckdb`, `snowflake`,
`bigquery`, `redshift`)
This generates a SQLMesh project with:
- A `models/` directory with starter SQL models
- A `config.yaml` that points at the dlt pipeline's destination
- A `seed.csv` for testing
- A `tests/` directory with example audit + unit tests
## Hand off to the sqlmesh skill
After `sqlmesh init`, the SQLMesh project is a **separate** tool
chain. The `dlt` skill's job is done at the init command; the
SQLMesh-specific patterns (incremental models, audits, unit tests,
virtual data warehouse) are covered by the **`sqlmesh` skill**.
## Cianfhoghlaim usage
- The `celtic-data-engineering-pipeline` spec — the dbt-duckdb
project at `orchestration/sqlmesh/` + `CelticDagsterDbtTranslator`
+ 2 marimo notebooks under `notebooks/`
- The `celtic-data-engineering-patterns` change (in openspec) for
the full setup
## Reference
- The `dlt - SQLMesh.md` reference was in `docs/dlt/` (deleted with
the `sync-skills-from-docs` change). The same content is in the
dltHub docs at <https://dlthub.com/docs/dlt-ecosystem/transformations/sqlmesh>
- The `sqlmesh` skill for the SQLMesh-specific patterns
- The `celtic-data-engineering-patterns` openspec change
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack." | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |