# Change in Intermediate Table Type for Python Incremental Models (dbt-snowflake 1.9.2 → 1.10.0)

**URL:** <https://discourse.getdbt.com/t/change-in-intermediate-table-type-for-python-incremental-models-dbt-snowflake-1-9-2-1-10-0/20778>\
**Category:** Help\
**Created:** [May 8, 2026, 11:03am UTC](https://discourse.getdbt.com/t/change-in-intermediate-table-type-for-python-incremental-models-dbt-snowflake-1-9-2-1-10-0/20778 "2026-05-08T11:03:10Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![shijic](https://avatars.discourse-cdn.com/v4/letter/s/dec6dc/32.png) [@shijic](https://discourse.getdbt.com/u/shijic)\
**Post date:** [May 8, 2026, 11:03am UTC](https://discourse.getdbt.com/t/change-in-intermediate-table-type-for-python-incremental-models-dbt-snowflake-1-9-2-1-10-0/20778/1 "2026-05-08T11:03:10Z")

</div>

## The problem I’m having:

I have a **dbt Python model** configured with `strategy = 'incremental'`.

- In **dbt-snowflake v1.9.2** , the intermediate table was being created as a **temporary table**.

- After upgrading to **dbt-snowflake v1.10.0** , the Python model (via the stored procedure `__dbt_sp`) now saves the DataFrame as **type = ‘TRANSIENT’** instead.

At the same time, I observed that **SQL models do not create transient intermediate tables** (`dbt__temp` or views) and continue to behave as before without any issues.

## The context of why I’m trying to do this:

I would like to understand whether this change in behavior for Python models is **intentional in dbt-snowflake 1.10.0 / higher versions** , and if there is any **configuration or flag available to control it**.

My requirement is to have the stored procedure (`__dbt_sp`) create **temporary tables or views** , instead of transient tables.

## What I’ve already tried:

1. Tried setting `transient = False`, which results in the table being created as a **permanent table**
2. Tried `tmp_relation_type = 'view'`, which failed with the error:  
`"python model supports only 'table'"`

[base] Python models currently only support ‘table’ for tmp\_relation\_type but view was specified.  
[base] \> in macro dbt\_snowflake\_get\_tmp\_relation\_type (macros/materializations/incremental.sql)  
called by macro materialization\_incremental\_snowflake (macros/materializations/incremental.sql)  
[base] \> called by model DIGT\_ALRT\_DETC\_MICR\_BTCH\_OTBG (resources/DIGT\_ALRT\_DETC\_MICR\_BTCH\_OTBG.py)

## Some example code or error messages

```auto
dbt config in python model :
        dbt.config(
            packages=["pandas", "numpy"],
            materialized="incremental",
        )
    

```