# dbt {materialized = "view"} creates a table in the database

**URL:** <https://discourse.getdbt.com/t/dbt-materialized-view-creates-a-table-in-the-database/7876>\
**Category:** Help\
**Tags:** materialization, views\
**Created:** [April 17, 2023, 9:22am UTC](https://discourse.getdbt.com/t/dbt-materialized-view-creates-a-table-in-the-database/7876 "2023-04-17T09:22:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![EranK](https://avatars.discourse-cdn.com/v4/letter/e/8baadc/32.png) [@EranK](https://discourse.getdbt.com/u/EranK)\
**Post date:** [April 17, 2023, 9:22am UTC](https://discourse.getdbt.com/t/dbt-materialized-view-creates-a-table-in-the-database/7876/1 "2023-04-17T09:22:10Z")

</div>

Trying to understand dbt Materialization strategies -

Some of our models are using the {materialized = “view”} option, and still I see that an underlying table is created in the database (We are using AWS Redshift)

dbt [documentation](https://docs.getdbt.com/docs/build/materializations) says that:  
“When using the **view materialization** , your model is **rebuilt as a view** on each run, via a create view as statement…”  
And that: “When using the **table materialization** , your model is **rebuilt as a table** on each run, via a create table as statement”

Still I see a table with the name as the model under “Tables” and no such view under “Views”.

Can someone please explain this?

Thanks!

---

<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:** [April 19, 2023, 7:58am UTC](https://discourse.getdbt.com/t/dbt-materialized-view-creates-a-table-in-the-database/7876/2 "2023-04-19T07:58:45Z")

</div>

if u could share ur config details present in the dbt\_project.yml , schema.yml , config block in the model files would be easy to provide the solution

---

<div class="post-metadata">

**Author:** ![mehdi](https://avatars.discourse-cdn.com/v4/letter/m/d07c76/32.png) [@mehdi](https://discourse.getdbt.com/u/mehdi)\
**Post date:** [April 19, 2023, 12:32pm UTC](https://discourse.getdbt.com/t/dbt-materialized-view-creates-a-table-in-the-database/7876/3 "2023-04-19T12:32:17Z")

</div>

It happened to me to update the model in the run folder as it has the same structure as the model’s. You may take a look there