Considering Autoloader for Bronze to Silver transformations

[yit]

I’m currently implementing Auto Loader to ingest data from the source into the Bronze layer—essentially mapping the raw data into Delta tables. Now, I’ve also been considering using Auto Loader for Bronze-to-Silver transformations.

Are there any pros and cons I should consider before moving forward with this approach?

[cgrant · Accepted solution]

Auto Loader is for loading raw files, not loading Delta Lake or Apache Iceberg tables, see more here.

Instead, stream from a Delta Lake table.