SP_6721
Honored Contributor II

Hi @ChristianRRL ,

When loading raw data into bronze tables with Auto Loader, it’s usually best to keep the original structure rather than flattening it right away. You can use schema inference for convenience, but to avoid mistakes, add schema hints or rescue columns.
In the raw layer, stick to light checks. Save heavier work such as flattening, deduplication, detailed validations for your silver tables. This keeps your data traceable, and better aligned with lakehouse best practices.

View solution in original post