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

•

学習とドキュメンテーション

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.

主な機能

Dynamic discovery of attribute and behavior table schemas
Detailed mapping of workflow orchestration and parallel processing logic
2 GitHub stars
Standardized templates for CDP and Customer 360 documentation
Validation of documentation against live codebase files to ensure accuracy
Automated extraction of SCD types and business rules from SQL source code

ユースケース

Generating technical references for SCD Type 2 data architectures
Documenting complex Customer 360 golden layer implementations
Mapping business logic and metric calculations for data governance audits

概要

主な機能

Dynamic discovery of attribute and behavior table schemas
Detailed mapping of workflow orchestration and parallel processing logic
2 GitHub stars
Standardized templates for CDP and Customer 360 documentation
Validation of documentation against live codebase files to ensure accuracy
Automated extraction of SCD types and business rules from SQL source code

ユースケース

Generating technical references for SCD Type 2 data architectures
Documenting complex Customer 360 golden layer implementations
Mapping business logic and metric calculations for data governance audits