skills.rest
Soria-Inc
Soria-IncOFFICIAL
Explore all skills by this author →
GitHub

preview

Render dive manifests into markdown pivot tables via soria warehouse queries.

1|1|Updated Mar 26, 2026
Search Tags:#preview#sql#data-quality#pivot-table#motherduck#dive#soria
One-click install
npx skills add https://github.com/Soria-Inc/soria-stack --skill preview-soria-inc
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: preview
Source: https://github.com/Soria-Inc/soria-stack/tree/main/preview
Command: npx skills add https://github.com/Soria-Inc/soria-stack --skill preview-soria-inc

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides a fast, read-only way to inspect what a frontend dive will display by converting dive manifests and query results into human-friendly markdown pivot tables so stakeholders can review slices and spot data quality issues without opening a browser.

Core Features & Use Cases

  • Manifest-driven SQL: Extract table, columns, where, filters, and groupBy from dive manifests and build precise SQL that mirrors the frontend's useDiveData contract.
  • Read-only querying and rendering: Execute queries via the soria warehouse query tool, format time-series as columns and snapshots as entity rows, and render default and alternate slices as pivot tables.
  • Quality checks and drift detection: Surface missing methodology, count verification checks from verifications metadata, and report manifest/data drift or empty slices with clear remediation advice.
  • Use Case: Quickly show a product manager the default PDP slice and a segment-swapped slice for a given dive to validate presentation and surface any data anomalies before a deploy.

Quick Start

Run the preview skill to render the dive's default view and one alternate slice as a markdown pivot table using the manifest and soria warehouse query.

Frequently Asked Questions about preview

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

FAQPage Schema
How do I preview dive manifests as pivot tables for data quality review?▼

Preview dive manifests as pivot tables by rendering frontend dive manifests and marts tables into formatted markdown. The tool derives SQL from manifest fields, executes read-only queries via MotherDuck, and surfaces methodology and verification counts for quality assessment.

Can I detect manifest and data drift when previewing SQL query results?▼

Yes, you can detect manifest and data drift when previewing SQL query results. The tool surfaces drift between expected manifest fields and actual marts table data, reporting empty slices and missing methodology with clear remediation advice.

How do I generate SQL from dive manifest fields to inspect frontend slices?▼

Generate SQL from dive manifest fields by extracting table, columns, where, filters, and groupBy configurations. The tool builds precise SQL that mirrors the frontend's useDiveData contract, executes it with limits and ordering, and renders the output as markdown pivot tables.

What's the best way to validate a default PDP slice and segment-swapped slice before deployment?▼

Validate slices before deployment by running a read-only preview that renders the dive's default view and an alternate segment-swapped slice as markdown pivot tables. This surfaces presentation issues and data anomalies without opening a browser.

Does the preview tool work with MotherDuck for read-only warehouse queries?▼

Yes, the preview tool works with MotherDuck by executing read-only warehouse queries via the soria warehouse query tool. It formats time-series as columns and snapshots as entity rows to render default and alternate slices as pivot tables.

What should I do when a dive output slice is empty or missing methodology?▼

When a dive output slice is empty or missing methodology, the tool detects the issue during manifest-driven SQL execution and provides clear remediation advice alongside verification counts from the metadata for quality assessment.

Related Skills

Explore More Data & Analytics Skills→
Soria-IncSoria-Inc
1

dive

Generate dbt marts SQL, manifest, React TSX component, and verification seed rows.

Official
Advanced
Luqman-Ud-DinLuqman-Ud-Din

qa-detect-ux-table-layout

Detect table layout UX defects via DOM bounding-box comparisons.

Community
Intermediate
Soria-IncSoria-Inc
1

status

Inventory pipeline resources and summarize completeness and staleness for a named data concept in the soria environment.

Official
Advanced
sorodriguezzsorodriguezz

Using the Analyzer

Create and modify pivot tables with the InterSystems IRIS Business Intelligence Analyzer.

Community
Intermediate