How to structure a data engineering pipeline in Microsoft Fabric?
asked a month ago301 viewsen
Starting a new project in Microsoft Fabric. Should I use a Lakehouse or a Warehouse for the silver layer? How do notebooks and pipelines fit together for orchestration?
🤖 AI diagnosis
AI-generated. Not an answer — the community below confirms or corrects it. Always verify before relying on it.
2 Answers
Lakehouse for the silver layer if you want Spark notebooks and Delta; Warehouse if your team is SQL-first. Pipelines orchestrate, notebooks transform. Keep bronze as raw files, silver as cleaned Delta tables, gold as a star schema.
Sign in to tell others whether this worked.
Use interface for object shapes you might extend or that represent a public API; use type for unions, intersections, mapped and conditional types. Performance is identical for simple cases; interface error messages are sometimes cleaner.
Sign in to tell others whether this worked.
Sign in and verify your email to post an answer.