The absolute key to getting agility and extensibility in a data warehouse project is a good meta data based automation framework and tools, regardless of whether you are using TSQL, Pool, Databricks and/or Python. If you are coming to SqlBits 2022, then there are a few sessions touching on this subjects. Full Schedule on this … Continue reading Meta data Automation at SqlBits 2022
Tag: EDW
This blog explores a universal architecture for EDW automation. I'm, attempting to be technology agnostic, so little mention of specifics here. Albeit those who know me, know I am a SQL centric fan boy with a software engineering and Finance background. There are many different technologies for building data warehouses. Currently I see three emerging … Continue reading EDW Automation Architecture