Problem in handling CLOB columns in dbt Model Contracts

Help
1

When enforcing the contract configuration in dbt Core 1.7, we encounter an error related to a column with a CLOB data type: ORA-00932: inconsistent datatypes: expected - got CLOB

image

Is there any idea that can solve this problem?

Running with dbt=1.7.4
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0

Example

_models.yml

models:
  - name: test_name
    description: test_description
    config:
      materialized: incremental
      incremental_strategy: append
      on_schema_change: fail
      full_refresh: false
      contract:
        enforced: true
    
     columns:
      - name: KAFKA_MESSAGE
        description: Kafka message
        data_type: CLOB
2

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