skills.rest
aminojagh
aminojaghCOMMUNITY
Explore all skills by this author →
GitHub

view-data

Query and explore data loaded by dlt pipelines using the dlt dataset API and ibis expressions.

Updated Jun 15, 2026
Search Tags:#pipeline#query#data exploration#duckdb#dlt#ibis#dataset api
One-click install
npx skills add https://github.com/aminojagh/LLMZC --skill view-data-aminojagh
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: view-data
Source: https://github.com/aminojagh/LLMZC/tree/main/05_02_dlt_workshop/.claude/skills/view-data
Command: npx skills add https://github.com/aminojagh/LLMZC --skill view-data-aminojagh

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires dlt, ibis.

What problem does it solve? After loading data with a dlt pipeline, you need a destination-agnostic way to inspect tables, check row counts, and run ad hoc queries without writing destination-specific SQL or importing database drivers directly. ## Core Features & Use Cases - Dataset API Access: Attach to any dlt pipeline and query loaded tables through pipeline.dataset(), working identically across duckdb, postgres, and bigquery. - Ibis Expressions: Build lazy, composable queries with filtering, grouping, aggregation, joins, and computed columns for complex analysis. - Parent/Child Table Joins: Join nested dlt tables using _dlt_id and _dlt_parent_id keys, plus raw SQL fallback when needed. - Use Case: You just loaded API data into duckdb and want to know total spend per user. Attach to the pipeline, build an ibis group-by aggregation, and get a pandas DataFrame in a few lines of Python. ## Quick Start Ask the AI to show the top users by spend from your dlt pipeline, optionally passing the pipeline name as an argument.

Frequently Asked Questions about view-data

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

FAQPage Schema
How do I query data loaded by a dlt pipeline?▼

Use dlt.attach with the pipeline name, then call pipeline.dataset() to get a destination-agnostic dataset object. Access tables with dataset["table_name"] and use methods like head(), select(), where(), and row_counts() to retrieve results as pandas DataFrames.

How to use ibis expressions with dlt datasets?▼

Convert a table to ibis with dataset["table"].to_ibis(), then build lazy expressions using filter, group_by, aggregate, join, and mutate. Execute the expression by passing it to the dataset object, for example dataset(expr).df().

Does the dlt dataset API work with postgres and bigquery?▼

Yes, the dlt dataset API is destination agnostic and works identically across duckdb, postgres, bigquery, and other destinations. You should never import destination libraries like duckdb directly in your query code.

How do I join dlt parent and child tables?▼

dlt creates child tables for nested data with names like my_table__results. Join them in ibis by matching the parent's _dlt_id column to the child's _dlt_parent_id column.

Can I run raw SQL against dlt pipeline data?▼

Yes, pass a SQL string directly to the dataset object, such as dataset("SELECT * FROM my_table WHERE amount > 100").df(). Use this when the ReadableRelation or ibis interfaces do not fit your query.

Related Skills

Explore More Data & Analytics Skills→
clawdataclawdata
24

dlt

Automate data ingestion pipelines from APIs, databases, and files into destinations.

Official
Advanced
Citrus-bitCitrus-bit
135

chart-visualization

Generate chart images from data and return image URLs with configurations.

Community
Advanced
dlt-hubdlt-hub
53

view-data

Query and explore dlt pipeline data using Python and ibis expressions.

Official
Intermediate
BindBind
5

psql

Run SQL queries and psql meta-commands against PostgreSQL databases from the CLI.

Community
Intermediate