# How to change default 'Transient' materialization with Snowflake

**URL:** <https://discourse.getdbt.com/t/how-to-change-default-transient-materialization-with-snowflake/7197>\
**Category:** Help\
**Tags:** materialization\
**Created:** [March 9, 2023, 1:30am UTC](https://discourse.getdbt.com/t/how-to-change-default-transient-materialization-with-snowflake/7197 "2023-03-09T01:30:46Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![rsnt2010](https://avatars.discourse-cdn.com/v4/letter/r/4af34b/32.png) [@rsnt2010](https://discourse.getdbt.com/u/rsnt2010)\
**Post date:** [March 9, 2023, 1:30am UTC](https://discourse.getdbt.com/t/how-to-change-default-transient-materialization-with-snowflake/7197/1 "2023-03-09T01:30:46Z")

</div>

Hi Team,

It looks like dbt is creating a ‘Transient’ table by default when connected with Snowflake. ‘Transient’ table in Snowflake will only have a data retention period of 1 day. When i see final target sql queries generated for each model starts with “create or replace TRANSIENT TABLE”.

Instead of ‘Transient’, I would like to create a ‘Permanent’ table in Snowflake which will have a data retention period of 90 days. Please help how can i change this default behavior. What I want dbt to generate SQLs is with “create or replace TABLE” which will create a ‘Permanent’ table by default in Snowflake.

Thanks in advance for all your suggestions.

---

<div class="post-metadata">

**Author:** ![a\_slack\_user](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/a_slack_user/32/1629_2.png) [@a\_slack\_user](https://discourse.getdbt.com/u/a_slack_user)\
**Post date:** [March 9, 2023, 1:35am UTC](https://discourse.getdbt.com/t/how-to-change-default-transient-materialization-with-snowflake/7197/2 "2023-03-09T01:35:19Z")

</div>

See this section of the documentation: [https://docs.getdbt.com/reference/resource-configs/snowflake-configs#transient-tables](https://docs.getdbt.com/reference/resource-configs/snowflake-configs#transient-tables)

Note: `@Josh Devlin (he)` originally [posted this reply in Slack](https://getdbt.slack.com/archives/CBSQTAPLG/p1678325711707449?thread_ts=1678325486.946219&cid=CBSQTAPLG). It might not have transferred perfectly.

---

<div class="post-metadata">

**Author:** ![rsnt2010](https://avatars.discourse-cdn.com/v4/letter/r/4af34b/32.png) [@rsnt2010](https://discourse.getdbt.com/u/rsnt2010)\
**Post date:** [March 9, 2023, 4:46am UTC](https://discourse.getdbt.com/t/how-to-change-default-transient-materialization-with-snowflake/7197/3 "2023-03-09T04:46:03Z")

</div>

Thank you. It helped.

---

<div class="post-metadata">

**Author:** ![akashsolanke22](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/akashsolanke22/32/2676_2.png) [@akashsolanke22](https://discourse.getdbt.com/u/akashsolanke22)\
**Post date:** [July 5, 2023, 8:13am UTC](https://discourse.getdbt.com/t/how-to-change-default-transient-materialization-with-snowflake/7197/4 "2023-07-05T08:13:45Z")

</div>

Hi @rsnt2010 , You can simply use the config here to make the permeant tables.

{{ config(materialized=“table”) }}

if you simple mention the materialized=“table” it will create the permeant table or else if you want to create transient for particular model only there you can simply mention the

{{ config(materialized=“table”, transient=true) }}

Hope this helps.

---

<div class="post-metadata">

**Author:** ![jaypeedevlin](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/jaypeedevlin/32/638_2.png) [@jaypeedevlin](https://discourse.getdbt.com/u/jaypeedevlin)\
**Post date:** [July 5, 2023, 8:15am UTC](https://discourse.getdbt.com/t/how-to-change-default-transient-materialization-with-snowflake/7197/5 "2023-07-05T08:15:30Z")

</div>

@akashsolanke22 this is not actually correct, dbt-snowflake defaults to transient tables.