validate-data

Validate schemas and data integrity after dlt pipeline loads.

53|5|Updated Feb 17, 2026
One-click install
npx skills add https://github.com/dlt-hub/dlthub-ai-workbench --skill validate-data
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: validate-data
Source: https://github.com/dlt-hub/dlthub-ai-workbench/tree/main/workbench/rest-api-pipeline/skills/validate-data
Command: npx skills add https://github.com/dlt-hub/dlthub-ai-workbench --skill validate-data

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill addresses the need to verify that data loaded into a data warehouse or lakehouse conforms to expected schemas and quality standards, catching errors early in the data pipeline.

Core Features & Use Cases

  • Schema Inspection: Visualize and understand the structure of loaded tables using Mermaid diagrams.
  • Data Preview: Access sample data and row counts via the Workspace Dashboard for quick review.
  • Data Type Correction: Refine data types and handle nested structures using processing_steps for accurate data representation.
  • Use Case: After loading customer transaction data, use this Skill to check if currency fields are correctly parsed as decimals and if nested address information is appropriately handled.

Quick Start

Validate the data loaded by the 'customer_transactions' pipeline, focusing on potential issues with currency fields.

Frequently Asked Questions about validate-data

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

FAQPage Schema
How do I validate data types and schema after loading a dlt pipeline?

You can validate data types and schema after a dlt pipeline load by inspecting table structures and applying processing_steps to correct fields. This catches errors early by verifying that loaded data conforms to expected quality standards.

What is the best way to inspect nested data structures in a data warehouse?

The best way to inspect nested data structures is by visualizing the loaded table schema with Mermaid diagrams and flattening the nested elements. This iterative refinement process ensures accurate data representation in your warehouse.

Can I preview sample data and row counts during dlt pipeline schema inspection?

Yes, you can preview sample data and row counts during schema inspection by accessing the Workspace Dashboard. This allows for a quick review of data integrity immediately after the pipeline load completes.

How do I correct incorrect data types in loaded dlt pipeline tables?

You can correct incorrect data types in loaded tables by defining processing_steps to refine the columns. This handles nested structures appropriately and ensures accurate data representation based on your specific concerns and pipeline context.

Does data validation work for iterative refinement of data shape based on user concerns?

Yes, data validation supports iterative refinement of data shape based on user-defined concerns and pipeline context. It allows you to progressively adjust schemas, correct data types, and flatten nested structures until quality standards are met.