DBT auto generate data type column

Hi all,

I’m looking into adding dbt to utilize its auto documentation feature. When generating, I run into the issue where the column type will just be “TEXT” instead of a varchar. I am aware that you can specify it, but I was more curious if there is a way around it as there is 1000s of columns and I’d prefer the dynamic way

thanks!