ETL
-
From Warehouse To Lakehouse – ELT/ETL Design Patterns With Azure Data Services
I like a good pattern. I also like a good framework. From a data perspective, nothing lends itself better to having both of these as ETL/ELT. For those not familiar…
-
Extract, Transform & Load Options In Azure
Extract, Transform & Load (ETL), or ELT, ETLT or whatever term we use nowadays, has been around for many decades. In terms of “what it is” – although I’m sure…
-
Loading Multiple Tables With Azure Data Factory
There arn’t many articles out there that discuss Azure Data Factory design patterns. One big concern I’ve encountered with customers is that there appears to be a requirement to create…
-
Incremental ETL Processing With Azure Data Factory v2
Data Factory V2 was announced at Ignite 2017 and brought with it a host of new capabilities: Lift your SSIS workloads into Data Factory and run using the new Integrated…
-
Optimizing SSIS Data Loads with Azure SQL Data Warehouse & PolyBase
To gain the best loading performance with Azure SQL Data Warehouse, you want to leverage the power of PolyBase, which allows for massively parallel data loading into the underlying storage.…
