Warehouse loading – tips and tricks for better performance

Microsoft Fabric offers built-in data ingestion tools that allow users to ingest data into warehouses at scale using code-free or code-rich experiences. In this session we will discover all the possible options - T-SQL features, and code free tools, and even more that some source types provide.
We will compare them according to different criteria like performance and ease of use, source volume and types, target schemas, single or cross workspaces usage. You will see them in action and understand how they work. You will get some tips on their best usage and their best combinations. But more importantly you will understand the main and the most critical factors for the design of the loading process so that you can make it fast and smooth. We will talk about how to combine the toolset we have for building elegant data loading solutions in the warehouse for the best performance. Tips and tricks on the way will help you learn, design and be prepared to start a process of loading data in your Fabric warehouse environment.

You will understand the main and the most critical factors for the design of the loading process so that you can make it fast and smooth.