list out your columns instead of doing a select *
cast your columns to explicit types instead of allowing DBT/Databricks to interpret