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: Synapse
This is the third blog in a series looking at the need for DW Automation focusing on Synapse SQL Pools (dedicated). In the first blog we looked at why we need DW Automation tools and what they look like:https://prodata.ie/2021/09/14/the-need-for-dw-automation-1-3/In the second blog we looked at a maturity model for DW automation with six levels of … Continue reading DW Automation demo for Synapse SQL Pools (3/3)