How to Automate Data Engineering

I've worked some with automating data engineering in the past, and I find that it's very applicable when you're doing pretty much straight one to one type stuff. But there are also parts where, you know, you're getting that extract and there is a slight change in schema now and can automation take care of those things or do you have to go back and write that piece of code? So we put that on an aspect of applying intelligence to the metadata. It actually the roots of that come from there is so much information. We understand that the metadata is actually things like theschema or I have a price attribute in my extract but this is the behavior of that attribute this how