# Customize target table in incremental models

**URL:** <https://discourse.getdbt.com/t/customize-target-table-in-incremental-models/5139>\
**Category:** Help\
**Tags:** incremental\
**Created:** [October 20, 2022, 8:31am UTC](https://discourse.getdbt.com/t/customize-target-table-in-incremental-models/5139 "2022-10-20T08:31:31Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![frankmayer](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/frankmayer/32/1262_2.png) [@frankmayer](https://discourse.getdbt.com/u/frankmayer)\
**Post date:** [October 20, 2022, 8:31am UTC](https://discourse.getdbt.com/t/customize-target-table-in-incremental-models/5139/1 "2022-10-20T08:31:31Z")

</div>

Hello! I need to insert data from multiple incremental models in one table. Can I customize target table in config not to use table as file name? Of course I can do it by union all, but we have large data and it makes one big query instead several small, and in it critical for our dwh.

---

<div class="post-metadata">

**Author:** ![jeffsk](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/jeffsk/32/1250_2.png) [@jeffsk](https://discourse.getdbt.com/u/jeffsk)\
**Post date:** [October 20, 2022, 3:28pm UTC](https://discourse.getdbt.com/t/customize-target-table-in-incremental-models/5139/2 "2022-10-20T15:28:42Z")

</div>

What warehouse are you using?  
In any modern warehouse that uses column store, a union is one of the most efficient operations you can do. It would be much more efficient than looping over the ref tables and inserting them one at a time.

---

<div class="post-metadata">

**Author:** ![Surya](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/surya/32/3763_2.png) [@Surya](https://discourse.getdbt.com/u/Surya)\
**Post date:** [October 22, 2022, 4:42pm UTC](https://discourse.getdbt.com/t/customize-target-table-in-incremental-models/5139/3 "2022-10-22T16:42:50Z")

</div>

U can customise ur target table name using alias and config in the model file or yml file

```auto
Model File:
{{ config(alias= 'target_table_name') }}
Yml file:
models:
  - name: tatget_table_sql_file_name
    config:
      alias: target_table_name

```

For more info

> **[config | dbt Developer Hub](https://docs.getdbt.com/reference/dbt-jinja-functions/config)**
>
> Overview

---

<div class="post-metadata">

**Author:** ![joellabes](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/joellabes/32/3980_2.png) [@joellabes](https://discourse.getdbt.com/u/joellabes)\
**Post date:** [October 27, 2022, 9:35am UTC](https://discourse.getdbt.com/t/customize-target-table-in-incremental-models/5139/4 "2022-10-27T09:35:07Z")

</div>

dbt believes very strongly in one file ➡ one object in the database. @Surya is right that you can use alias to change the name of the created object, but you can still only have one object with that name.

I agree with @jeffsk that your best bet is to make the incremental models separately, and then create a view on top that unions them.