# DBT auto generate data type column

**URL:** <https://discourse.getdbt.com/t/dbt-auto-generate-data-type-column/14594>\
**Category:** Help\
**Created:** [July 30, 2024, 8:40pm UTC](https://discourse.getdbt.com/t/dbt-auto-generate-data-type-column/14594 "2024-07-30T20:40:09Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![edtomlins](https://avatars.discourse-cdn.com/v4/letter/e/e56c9b/32.png) [@edtomlins](https://discourse.getdbt.com/u/edtomlins)\
**Post date:** [July 30, 2024, 8:40pm UTC](https://discourse.getdbt.com/t/dbt-auto-generate-data-type-column/14594/1 "2024-07-30T20:40:09Z")

</div>

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!