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

Help
,
1

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 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!

2

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

1 Like
3

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