Can it document Slowly Changing Dimensions (SCD)?

Yes, the skill is designed to detect and document SCD implementations, including identifying SCD types and the logic used to manage historical data changes.

What documentation format does it produce?

It generates structured Markdown documentation that follows a professional template suitable for Confluence, GitHub, or other documentation platforms.

Does this skill require live database access?

No, it works by analyzing your codebase—specifically .sql and .dig files—to understand the logic and structure of your data transformations.

What is a 'golden layer' in the context of this skill?

A golden layer refers to the final, cleaned, and unified data layer in a data warehouse (like a CDP) that is ready for analytics and business intelligence applications.

APS Golden Documentation Expert

Name: APS Golden Documentation Expert
Author: treasure-data

bytreasure-data

•

Learning & Documentation

Generates comprehensive, production-ready documentation for golden layer data tables by analyzing SQL logic and workflow orchestration.

The APS Golden Documentation Expert is a specialized skill designed to automate the creation of technical documentation for final, analytics-ready data layers. By directly analyzing your .sql and .dig files, it extracts real-world business rules, SCD (Slowly Changing Dimension) logic, and metric definitions to build detailed documentation. It eliminates manual entry errors by mapping actual data lineage, source priorities, and atomic replacement patterns, ensuring your data governance records perfectly match your codebase implementation.

Key Features

01Dynamic discovery of attribute and behavior table schemas

02Detailed mapping of workflow orchestration and parallel processing logic

032 GitHub stars

04Standardized templates for CDP and Customer 360 documentation

05Validation of documentation against live codebase files to ensure accuracy

06Automated extraction of SCD types and business rules from SQL source code

Use Cases

01Generating technical references for SCD Type 2 data architectures

02Documenting complex Customer 360 golden layer implementations

03Mapping business logic and metric calculations for data governance audits

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add treasure-data/td-skills golden

For use in Claude.ai and ChatGPT

Download Skill