This guide discusses combining tables from the same workbook only, not external sources or multiple workbooks. Make sure all the datasets you want to append are formatted as Excel ...

The original issue occurred with explicit check_cols lists, but this reproduction shows it also affects check_cols: all. The root cause seems to be that dbt generates SQL that references the new ...