Ajay-Pandey
Databricks MVP

Hi @anonymous_567 

With the help of autoloader, you can not do it as autoloader work at the file level, not the data level, to achieve this you can go with SCD or CDF approach.

Ajay Kumar Pandey