I appreciate the detailed explanation as my goal is to gain a clear understanding 🙂
As the delta loag of target table already captures the table metadata so the target dataframe schema is validated against this metadata correct?

I also have two follow up questions:
In case of Autoloader it throws an error on column addition due to the default schema evolution mode right whereas in delta streaming tables as source errors occur in case of non-additive schema changes could you please confirm if my understanding is correct?
And In case of message bus like kafka the offset is the consumer group offset right? can you please share any documentation on this
Thanks for being so patient with me 🙂