# DBT with Unity Catalog - Failing to perform Incremental Materialization

**URL:** <https://discourse.getdbt.com/t/dbt-with-unity-catalog-failing-to-perform-incremental-materialization/6083>\
**Category:** Help\
**Tags:** materialization, databricks\
**Created:** [January 13, 2023, 1:41pm UTC](https://discourse.getdbt.com/t/dbt-with-unity-catalog-failing-to-perform-incremental-materialization/6083 "2023-01-13T13:41:57Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![sudhirnune](https://avatars.discourse-cdn.com/v4/letter/s/9de0a6/32.png) [@sudhirnune](https://discourse.getdbt.com/u/sudhirnune)\
**Post date:** [January 13, 2023, 1:41pm UTC](https://discourse.getdbt.com/t/dbt-with-unity-catalog-failing-to-perform-incremental-materialization/6083/1 "2023-01-13T13:41:57Z")

</div>

HI all,

We are using DataBricks with Unity Catalog and we observe a peculiar issue with the Incremental Materailization. This Materialization is not working as expected, it behaves as table Materialization rather than Append, we tried all the options mentioned as per the documentation [Apache Spark configurations | dbt Developer Hub](https://docs.getdbt.com/reference/resource-configs/spark-configs). can you please check let us know if this a know issue or a config gap I am doing ?

**dbt Versions:**  
Core: 1.3.2  
databricks: 1.3.2  
Spark: 1.3.0

**Profile:**

```auto
dbt_databricks:
  outputs:
    dev:
      catalog: 'hive_metastore'
      host: adb-99999999999999.azuredatabricks.net
      http_path: sql/protocolv1/o/99999999999999/9999-999999
      schema: 'jaffle_shop'
      threads: 1
      token: XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
      type: databricks
  target: dev

```

**Model Config:**

```auto
1. {{ config(
    materialized='incremental',
    incremental_strategy='append',
) }}

2. {{ config(
    materialized='incremental',
    file_format='delta',
    unique_key='copa_unique_key',
    incremental_strategy='merge'
) }}

```