If you have an existing hub and spoke architecture, moving your architecture to Fabric may not be as difficult as you might initially think. One of the coolest features in Fabric is shortcuts. Shortcuts allow you to access your data that is stored in delta format (in a data lake on ADLS, S3, or OneLake)…
Year: 2023
Synapse Fundamentals for Tuning – Replicated Tables
I covered some of the basics of table geometry in this post: Synapse Fundamentals for Performance Tuning – Distribution; however, it’s critical to dive deeper into the performance impact of having the correct table distribution defined. Sometimes we think we have the correct distribution chosen for a table but are painfully mistaken as performance suffers. Generally, that…