DBT Snapshot- The existing table '' is in another format than 'delta' or 'iceberg' or 'hudi'

Help
1

As mentioned in [ADAP-803] The existing table '' is in another format than 'delta' or 'iceberg' or 'hudi' · Issue #870 · dbt-labs/dbt-spark · GitHub, I am facing the issue where dbt snapshot works fine the 1st time and the second time it occurs with this error.

2

Hey all, looking for some help on this if someone already faced and resolved it before.

Note: @mkhan12 originally posted this reply in Slack. It might not have transferred perfectly.

3

When I use spark_catalog in target_schema, it works but it uses create or replace instead of merge functionality so I don’t get the benefits of snapshot.
target_schema='spark_catalog.schema'

Note: @muntaser.khan originally posted this reply in Slack. It might not have transferred perfectly.