Forum Discussion
Fabric SQL Database vs Warehouse
I am building a Metadata driven ETL Framework in Fabric and I am confused on where I should create my metadata storage and pipeline logs. As warehouse specializes in OLAP requirements, by definition I am leaning towards SQL Database which is suggested for OTLP requirements.
1 Reply
Hi VaibhavTiwari,
A SQL Database is likely the better choice, as the metadata driven framework is more of an OLTP process.
A warehouse will run into issues when you have multiple processes trying to update the same table at the same time, a SQL database will not have that problem.
