# Problems of table names conversion by dbt

**URL:** <https://discourse.getdbt.com/t/problems-of-table-names-conversion-by-dbt/2633>\
**Category:** Archive\
**Created:** [June 10, 2021, 6:16pm UTC](https://discourse.getdbt.com/t/problems-of-table-names-conversion-by-dbt/2633 "2021-06-10T18:16:03Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![cyang110](https://avatars.discourse-cdn.com/v4/letter/c/f19dbf/32.png) [@cyang110](https://discourse.getdbt.com/u/cyang110)\
**Post date:** [June 10, 2021, 6:16pm UTC](https://discourse.getdbt.com/t/problems-of-table-names-conversion-by-dbt/2633/1 "2021-06-10T18:16:03Z")

</div>

I use dbt snapshot and dbt models to create tables, and use tableau to visualize the data. The problem is after some hours, the table name will automatically change to schema.tablename\_dbt\_backup and schema.tablename\_ dbt\_tmp. snapshots and models run normally and create tables with no problem. But every day at some point dbt renames tables and appends “dbt\_temp” or “dbt\_backup” at the end of the table name,and that messes up our BI because it is looking for a table that no longer exists. Anyone knows why this happens and how to solve it? Thank you very much for your help.

for example, after running dbt, I can get cyang110.student table. After several hours, it becomes cyang110.student\_dbt\_backup and cyang110.student\_dbt\_tmp.

the config of my model is  
{{ config(  
materialized=“table”  
) }}