Travailler sur le projet dbt ZLV

Guide AI agents through building, testing, and documenting dbt models in zlv_dbt_project.

6|7|Updated Sep 13, 2021
One-click install
npx skills add https://github.com/MTES-MCT/zero-logement-vacant --skill travailler-sur-le-projet-dbt-zlv
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: Travailler sur le projet dbt ZLV
Source: https://github.com/MTES-MCT/zero-logement-vacant/tree/main/analytics/dbt
Command: npx skills add https://github.com/MTES-MCT/zero-logement-vacant --skill travailler-sur-le-projet-dbt-zlv

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Automates guidance for IA agents to work on the zlv_dbt_project.

Core Features & Use Cases

  • Structured dbt guidance: Step-by-step instructions to explore, modify, and validate models across stg, int, and marts.
  • Contextual references: Quick access to project structure, macros, tests, and documentation to maintain consistency.
  • Reusable playbooks: Templates for adding models, writing tests, and validating with dbt docs to ensure reproducibility.

Quick Start

Provide IA with a concise, goal-oriented action to begin working on the zlv_dbt_project, such as adding a new marts model and validating its dependencies.

Frequently Asked Questions about Travailler sur le projet dbt ZLV

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I build and test dbt models with DuckDB and MotherDuck?

To build and test dbt models with DuckDB and MotherDuck, this Skill provides step-by-step guidance for creating, modifying, and validating models across staging, intermediate, and marts layers. It enforces reproducible steps and guardrails for safe, auditable dbt development in team settings.

What is the best way to structure a dbt project for team collaboration?

Structuring a dbt project for team collaboration involves using reusable playbooks and contextual references to maintain consistency across staging, intermediate, and marts layers. This Skill automates guidance for AI agents, providing templates for adding models, writing tests, and validating dependencies.

Can I use AI agents to automate dbt model development and documentation?

Yes, you can use AI agents to automate dbt model development and documentation. This Skill applies AI-guided workflows to explore, modify, and validate models, ensuring reproducible steps and safe, auditable development within the zlv_dbt_project.

How do I add a new marts model and validate its dependencies in dbt?

To add a new marts model and validate its dependencies in dbt, you provide the AI with a concise, goal-oriented action. The Skill supplies templates for adding models, writing tests, and validating with dbt docs to ensure reproducibility and correct dependency resolution.

Does this dbt workflow support reproducible and auditable model testing?

This dbt workflow supports reproducible and auditable model testing by enforcing guardrails and contextual references for safe development. It provides quick access to project structure, macros, and tests to validate models across stg, int, and marts layers using DuckDB and MotherDuck.

When should I not use an AI-guided workflow for dbt development?

You should not use an AI-guided workflow for dbt development if your project lacks clear guardrails or relies on unsupported platforms outside of DuckDB and MotherDuck. The Skill enforces reproducible steps specifically tailored for the zlv_dbt_project architecture and team collaboration.