Generates Snowflake Task DAGs and execution scripts for vault loading.
npx skills add https://github.com/PatrickCuba/the_data_must_flow --skill dv-load
Please help me install this Agent Skill. Skill: dv-load Source: https://github.com/PatrickCuba/the_data_must_flow/tree/main/dvos-skills/skills/dv-load Command: npx skills add https://github.com/PatrickCuba/the_data_must_flow --skill dv-load
Vault loading orchestration is complex and error-prone; this skill automates the generation of Snowflake Task DAGs and execution scripts to enforce deterministic load order and ghost record deployment.
Provide your vault loading requirements and run the dv-load skill to generate the Snowflake task DAGs.
High-intent search queries and answers about installing and using this skill.
You can orchestrate Data Vault loads in Snowflake by generating task DAGs and execution scripts that enforce deterministic load order for hubs, links, and satellites. This automates batch vault loading and handles Kappa Vault event-driven modes.
To enforce sequential loading for same-hub dependencies in a Snowflake ETL DAG, you generate per-hub loader DAGs with dedicated tasks and proper AFTER dependencies. This parallelizes independent hubs while maintaining strict order for same-hub tasks.
You deploy idempotent ghost records for initial Data Vault deployments by generating execution scripts that include ghost-record deployment. This ensures safe, deterministic initial loading and prevents duplicate records during vault initialization.
Yes, you can use Snowflake tasks to orchestrate PIT and Bridge table loading alongside standard Data Vault hubs and links. The orchestration pattern provides reusable DAG structures that automatically handle dependencies for Point-in-Time and Bridge tables when necessary.
Standard batch Data Vault loading and Kappa Vault event-driven modes are both supported in Snowflake. The orchestration generates specific task DAGs and execution scripts tailored to either standard batch processing or event-driven Kappa Vault architectures.
rnavarychDesign database schemas across relational, document, graph, time-series, dimensional, and Data Vault paradigms.
ivanshamaevConstruct Data Vault 2.0 hubs, links, satellites, and PIT tables.
PatrickCubaAutomate Data Vault integrity testing with ad-hoc queries or Snowflake DMFs.
personamanagmentlayerDesign Apache Airflow DAGs and orchestrate complex data pipelines in Python.
