Name: Fabric Notebook Scaffold
Author: Anand-Reddy1253

Fabric Notebook Scaffold Skill

When to Use This Skill

Use this skill whenever a new notebook needs to be created for any layer of the medallion architecture. This skill ensures consistency across all notebooks.

Steps

Step 1: Determine Layer

Identify the target layer based on the notebook's purpose:

Bronze — reads raw source files, adds metadata columns, no transforms
Silver — reads Bronze Delta, cleans and transforms data
Gold — reads Silver Delta, builds aggregates and star schema

Step 2: Select Template

Choose the appropriate template:

Bronze → templates/bronze_ingestion.py.tmpl
Silver → templates/silver_transform.py.tmpl

Placeholder	Description	Example
`{{ENTITY}}`	Entity/table name in snake_case	`pos_transactions`
`{{ENTITY_UPPER}}`	Entity name in UPPER_CASE	`POS_TRANSACTIONS`
`{{SOURCE_PATH}}`	Input data path	`lakehouse/bronze/raw/pos_transactions/`
`{{TARGET_PATH}}`	Output Delta table path	`lakehouse/bronze/pos_transactions/`
`{{DESCRIPTION}}`	One-line description	`Ingest POS transactions from raw CSV`
`{{MERGE_KEY}}`	Business key column(s)	`transaction_id`
`{{LAYER}}`	Layer name	`bronze`

Fabric Notebook Scaffold

Fabric Notebook Scaffold Skill

When to Use This Skill

Steps

Step 1: Determine Layer

Step 2: Select Template

Fabric Notebook Scaffold

Fabric Notebook Scaffold Skill

When to Use This Skill

Steps

Step 1: Determine Layer

Step 2: Select Template

Step 3: Fill Placeholders

Step 4: Register Schema

Step 5: Create Test Stub

Step 6: Validate

Step 7: Report

Bluebubbles

Add Tracing

Analytics Events

Add Expert

Arthas

Arthas Eagleeye Traceid