[Bug] Problem with materializing my models

### Is there an existing issue for this?

- [ ] I have searched the existing issues

### Current Behavior

Hello guys,

I am currently trying to setup dbt with a locally hosted oracle, but have problems materializing my models. As far as I understand you can set this option either in the sql, the model or the dbt_project itself. The problem is, that neither of these configurations work for me. For my models it always just creates a view in the database. On the other hand seeds are created as tables, so I assume there is no problem with the privileges of the database user.

@aosingh recommended me to create an issue here. I have attached the [dbt.log](https://github.com/user-attachments/files/20774673/dbt.log) and here is the model [property_data_product.sql.txt](https://github.com/user-attachments/files/20774829/property_data_product.sql.txt)
, the [schema.yml.txt](https://github.com/user-attachments/files/20774810/schema.yml.txt) and the project settings
[dbt_project.yml.txt](https://github.com/user-attachments/files/20774842/dbt_project.yml.txt) .

Do you have any idea of why my models are always created views? Is there a problem with the adapter/ adapter settings?

### Expected Behavior

I would expect the model "property_data_product" to be created as a table and not a view. 

### Steps To Reproduce

_No response_

### Relevant log output using `--debug` flag enabled

```shell
[0m13:41:29.299222 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'start', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000001BAB19B9610>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000001BAB4810A70>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000001BAB2A04FE0>]}


============================== 13:41:29.306225 | 0bb9e712-4cf6-4677-8a0a-118b45fba01b ==============================
[0m13:41:29.306225 [info ] [MainThread]: Running with dbt=1.9.4
[0m13:41:29.308222 [debug] [MainThread]: running dbt with arguments {'printer_width': '80', 'indirect_selection': 'eager', 'write_json': 'True', 'log_cache_events': 'False', 'partial_parse': 'True', 'cache_selected_only': 'False', 'profiles_dir': 'C:\\dev\\data_contract_showcase\\producer_project', 'fail_fast': 'False', 'version_check': 'True', 'log_path': 'C:\\dev\\data_contract_showcase\\producer_project\\logs', 'warn_error': 'None', 'debug': 'True', 'use_colors': 'True', 'use_experimental_parser': 'False', 'empty': 'False', 'quiet': 'False', 'no_print': 'None', 'log_format': 'default', 'invocation_command': 'dbt build --debug', 'introspect': 'True', 'static_parser': 'True', 'target_path': 'None', 'warn_error_options': 'WarnErrorOptions(include=[], exclude=[])', 'send_anonymous_usage_stats': 'True'}
[0m13:41:29.501252 [info ] [MainThread]: oracle adapter: Running in thin mode
[0m13:41:29.845276 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'project_id', 'label': '0bb9e712-4cf6-4677-8a0a-118b45fba01b', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000001BAB5A8F290>]}
[0m13:41:29.925275 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'adapter_info', 'label': '0bb9e712-4cf6-4677-8a0a-118b45fba01b', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000001BAB528E0F0>]}
[0m13:41:29.928273 [info ] [MainThread]: Registered adapter: oracle=1.9.1
[0m13:41:30.292264 [debug] [MainThread]: checksum: b5597158181700c50f5bc1c71fe28b37a6fb85633dc5323885263678b6bc782c, vars: {}, profile: , target: , version: 1.9.4
[0m13:41:30.561742 [debug] [MainThread]: Partial parsing enabled: 0 files deleted, 0 files added, 0 files changed.
[0m13:41:30.562742 [debug] [MainThread]: Partial parsing enabled, no changes found, skipping parsing
[0m13:41:30.608743 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'load_project', 'label': '0bb9e712-4cf6-4677-8a0a-118b45fba01b', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000001BAB5BFE510>]}
[0m13:41:30.707785 [debug] [MainThread]: Wrote artifact WritableManifest to C:\dev\data_contract_showcase\producer_project\target\manifest.json
[0m13:41:30.713745 [debug] [MainThread]: Wrote artifact SemanticManifest to C:\dev\data_contract_showcase\producer_project\target\semantic_manifest.json
[0m13:41:30.768745 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'resource_counts', 'label': '0bb9e712-4cf6-4677-8a0a-118b45fba01b', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000001BAB70C2210>]}
[0m13:41:30.769745 [info ] [MainThread]: Found 2 seeds, 1 model, 2 data tests, 757 macros
[0m13:41:30.772744 [info ] [MainThread]: 
[0m13:41:30.773744 [info ] [MainThread]: Concurrency: 4 threads (target='dev')
[0m13:41:30.773744 [info ] [MainThread]: 
[0m13:41:30.774744 [debug] [MainThread]: Acquiring new oracle connection 'master'
[0m13:41:30.780745 [debug] [ThreadPool]: Acquiring new oracle connection 'list_FREE'
[0m13:41:30.874764 [debug] [ThreadPool]: Using oracle connection "list_FREE"
[0m13:41:30.875760 [debug] [ThreadPool]: On list_FREE: /* {"app": "dbt", "dbt_version": "1.9.4", "profile_name": "producer_project", "target_name": "dev", "connection_name": "list_FREE"} */
select username as "name"
      from sys.all_users
      order by username
  
[0m13:41:30.876754 [debug] [ThreadPool]: Opening a new connection, currently in state init
[0m13:41:30.877759 [debug] [ThreadPool]: oracle adapter: Attempting to connect using Oracle method: 'OracleConnectionMethod.HOST' and dsn: 'tcp://localhost:1521/free?retry_count=1&retry_delay=3'
[0m13:41:33.011768 [debug] [ThreadPool]: oracle adapter: Session info :{"action": "DBT RUN", "client_identifier": "dbt-oracle-client-5fb5b13c-9e2e-495f-a380-facb6caecdaf", "clientinfo": "9SL7HW3_AMD64", "module": "dbt-1.9.4"}
[0m13:41:33.014791 [debug] [ThreadPool]: SQL status: OK in 2.000 seconds
[0m13:41:33.016839 [debug] [ThreadPool]: On list_FREE: Close
[0m13:41:33.020766 [debug] [ThreadPool]: Acquiring new oracle connection 'list_FREE_C##DBTUSER'
[0m13:41:33.025764 [debug] [ThreadPool]: Opening a new connection, currently in state init
[0m13:41:33.025764 [debug] [ThreadPool]: oracle adapter: Attempting to connect using Oracle method: 'OracleConnectionMethod.HOST' and dsn: 'tcp://localhost:1521/free?retry_count=1&retry_delay=3'
[0m13:41:35.089728 [debug] [ThreadPool]: oracle adapter: Session info :{"action": "DBT RUN", "client_identifier": "dbt-oracle-client-a907bf34-cec6-4604-a1cc-ca0f539604c1", "clientinfo": "9SL7HW3_AMD64", "module": "dbt-1.9.4"}
[0m13:41:35.090785 [debug] [ThreadPool]: Using oracle connection "list_FREE_C##DBTUSER"
[0m13:41:35.091729 [debug] [ThreadPool]: On list_FREE_C##DBTUSER: /* {"app": "dbt", "dbt_version": "1.9.4", "profile_name": "producer_project", "target_name": "dev", "connection_name": "list_FREE_C##DBTUSER"} */
with tables as
      (select SYS_CONTEXT('userenv', 'DB_NAME') table_catalog,
         owner table_schema,
         table_name,
         case
           when iot_type = 'Y'
           then 'IOT'
           when temporary = 'Y'
           then 'TEMP'
           else 'BASE TABLE'
         end table_type
       from sys.all_tables
       where upper(table_name) not in (
       select upper(mview_name)
       from sys.all_mviews
       where upper(owner) = upper('C##DBTUSER')
       )
       union all
       select SYS_CONTEXT('userenv', 'DB_NAME'),
         owner,
         view_name,
         'VIEW'
       from sys.all_views
       union all
       select SYS_CONTEXT('userenv', 'DB_NAME'),
        owner,
        mview_name,
        'MATERIALIZED VIEW'
        from sys.all_mviews
  )
  select table_catalog as "database_name"
    ,table_name as "name"
    ,table_schema as "schema_name"
    ,case table_type
      when 'BASE TABLE' then 'table'
      when 'VIEW' then 'view'
      when 'MATERIALIZED VIEW' then 'materialized_view'
    end as "kind"
  from tables
  where table_type in ('BASE TABLE', 'VIEW', 'MATERIALIZED VIEW')
    and upper(table_schema) = upper('C##DBTUSER')
  
[0m13:41:35.107765 [debug] [ThreadPool]: SQL status: OK in 0.000 seconds
[0m13:41:35.109782 [debug] [ThreadPool]: On list_FREE_C##DBTUSER: ROLLBACK
[0m13:41:35.111762 [debug] [ThreadPool]: On list_FREE_C##DBTUSER: Close
[0m13:41:35.114728 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'runnable_timing', 'label': '0bb9e712-4cf6-4677-8a0a-118b45fba01b', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000001BAB5BC8CB0>]}
[0m13:41:35.115763 [debug] [MainThread]: Opening a new connection, currently in state init
[0m13:41:35.115763 [debug] [MainThread]: oracle adapter: Attempting to connect using Oracle method: 'OracleConnectionMethod.HOST' and dsn: 'tcp://localhost:1521/free?retry_count=1&retry_delay=3'
[0m13:41:37.197446 [debug] [MainThread]: oracle adapter: Session info :{"action": "DBT RUN", "client_identifier": "dbt-oracle-client-f276ad6f-299a-45cd-a13d-1e1dd1aa7d54", "clientinfo": "9SL7HW3_AMD64", "module": "dbt-1.9.4"}
[0m13:41:37.198412 [debug] [MainThread]: On master: COMMIT
[0m13:41:37.198412 [debug] [MainThread]: Using oracle connection "master"
[0m13:41:37.199417 [debug] [MainThread]: On master: COMMIT
[0m13:41:37.201460 [debug] [MainThread]: SQL status: OK in 0.000 seconds
[0m13:41:37.202413 [debug] [MainThread]: On master: Close
[0m13:41:37.211414 [debug] [Thread-1 (]: Began running node seed.producer_project.mortgage_application_seed
[0m13:41:37.212411 [debug] [Thread-2 (]: Began running node seed.producer_project.property_data_seed
[0m13:41:37.213412 [info ] [Thread-1 (]: 1 of 5 START seed file C##DBTUSER.mortgage_application_seed .................... [RUN]
[0m13:41:37.214413 [info ] [Thread-2 (]: 2 of 5 START seed file C##DBTUSER.property_data_seed ........................... [RUN]
[0m13:41:37.215412 [debug] [Thread-1 (]: Acquiring new oracle connection 'seed.producer_project.mortgage_application_seed'
[0m13:41:37.216412 [debug] [Thread-2 (]: Acquiring new oracle connection 'seed.producer_project.property_data_seed'
[0m13:41:37.217413 [debug] [Thread-1 (]: Began compiling node seed.producer_project.mortgage_application_seed
[0m13:41:37.218412 [debug] [Thread-2 (]: Began compiling node seed.producer_project.property_data_seed
[0m13:41:37.219413 [debug] [Thread-1 (]: Began executing node seed.producer_project.mortgage_application_seed
[0m13:41:37.220414 [debug] [Thread-2 (]: Began executing node seed.producer_project.property_data_seed
[0m13:41:37.263454 [debug] [Thread-1 (]: Opening a new connection, currently in state init
[0m13:41:37.266415 [debug] [Thread-2 (]: Opening a new connection, currently in state init
[0m13:41:37.267413 [debug] [Thread-1 (]: oracle adapter: Attempting to connect using Oracle method: 'OracleConnectionMethod.HOST' and dsn: 'tcp://localhost:1521/free?retry_count=1&retry_delay=3'
[0m13:41:37.267413 [debug] [Thread-2 (]: oracle adapter: Attempting to connect using Oracle method: 'OracleConnectionMethod.HOST' and dsn: 'tcp://localhost:1521/free?retry_count=1&retry_delay=3'
[0m13:41:39.349662 [debug] [Thread-1 (]: oracle adapter: Session info :{"action": "DBT RUN", "client_identifier": "dbt-oracle-client-74e5adb3-65d1-4fc5-b169-7c9ced23fde7", "clientinfo": "9SL7HW3_AMD64", "module": "dbt-1.9.4"}
[0m13:41:39.354710 [debug] [Thread-1 (]: Using oracle connection "seed.producer_project.mortgage_application_seed"
[0m13:41:39.355709 [debug] [Thread-1 (]: On seed.producer_project.mortgage_application_seed: /* {"app": "dbt", "dbt_version": "1.9.4", "profile_name": "producer_project", "target_name": "dev", "node_id": "seed.producer_project.mortgage_application_seed"} */

    create table C##DBTUSER.mortgage_application_seed (property_id number,mortgage_id number,create_date timestamp)
  
[0m13:41:39.359663 [debug] [Thread-2 (]: oracle adapter: Session info :{"action": "DBT RUN", "client_identifier": "dbt-oracle-client-4b20d82e-db1f-47af-b838-bc37be80a985", "clientinfo": "9SL7HW3_AMD64", "module": "dbt-1.9.4"}
[0m13:41:39.360661 [debug] [Thread-2 (]: Using oracle connection "seed.producer_project.property_data_seed"
[0m13:41:39.361708 [debug] [Thread-2 (]: On seed.producer_project.property_data_seed: /* {"app": "dbt", "dbt_version": "1.9.4", "profile_name": "producer_project", "target_name": "dev", "node_id": "seed.producer_project.property_data_seed"} */

    create table C##DBTUSER.property_data_seed (property_id number,property_type varchar2(4000),living_area number)
  
[0m13:41:39.364787 [debug] [Thread-1 (]: SQL status: OK in 0.000 seconds
[0m13:41:39.386076 [debug] [Thread-2 (]: SQL status: OK in 0.000 seconds
[0m13:41:39.385036 [debug] [Thread-1 (]: Using oracle connection "seed.producer_project.mortgage_application_seed"
[0m13:41:39.389070 [debug] [Thread-2 (]: Using oracle connection "seed.producer_project.property_data_seed"
[0m13:41:39.390098 [debug] [Thread-1 (]: On seed.producer_project.mortgage_application_seed: 
            insert all
            into C##DBTUSER.mortgage_application_seed (property_id, mortgage_id, create_date) values(:p1,:p2,:p3)
            into C##DBTUSER.mortgage_application_seed (property_id, mortgage_id, create_date) values(:p1,:p2,:p3)
            into C##DBTUSER.mortgage_application_seed (property_id, mortgage_id, create_date) values(:p1,:p2,:p3)
            into C##DBTUSER.mortgage_application_seed (property_id, mortgage_id, create_date) values(:p1,:p2,:p3)
            into C##DBTUSER.mort...
[0m13:41:39.391036 [debug] [Thread-2 (]: On seed.producer_project.property_data_seed: 
            insert all
            into C##DBTUSER.property_data_seed (property_id, property_type, living_area) values(:p1,:p2,:p3)
            into C##DBTUSER.property_data_seed (property_id, property_type, living_area) values(:p1,:p2,:p3)
            into C##DBTUSER.property_data_seed (property_id, property_type, living_area) values(:p1,:p2,:p3)
            into C##DBTUSER.property_data_seed (property_id, property_type, living_area) values(:p1,:p2,:p3)
            into C##DBTUSER.property_data_seed (prop...
[0m13:41:39.407034 [debug] [Thread-1 (]: SQL status: OK in 0.000 seconds
[0m13:41:39.415073 [debug] [Thread-1 (]: Writing runtime SQL for node "seed.producer_project.mortgage_application_seed"
[0m13:41:39.444073 [debug] [Thread-1 (]: On seed.producer_project.mortgage_application_seed: COMMIT
[0m13:41:39.444073 [debug] [Thread-2 (]: SQL status: OK in 0.000 seconds
[0m13:41:39.445076 [debug] [Thread-1 (]: Using oracle connection "seed.producer_project.mortgage_application_seed"
[0m13:41:39.446034 [debug] [Thread-2 (]: Writing runtime SQL for node "seed.producer_project.property_data_seed"
[0m13:41:39.447144 [debug] [Thread-1 (]: On seed.producer_project.mortgage_application_seed: COMMIT
[0m13:41:39.451071 [debug] [Thread-2 (]: On seed.producer_project.property_data_seed: COMMIT
[0m13:41:39.451071 [debug] [Thread-1 (]: SQL status: OK in 0.000 seconds
[0m13:41:39.452035 [debug] [Thread-2 (]: Using oracle connection "seed.producer_project.property_data_seed"
[0m13:41:39.455078 [debug] [Thread-1 (]: On seed.producer_project.mortgage_application_seed: Close
[0m13:41:39.455078 [debug] [Thread-2 (]: On seed.producer_project.property_data_seed: COMMIT
[0m13:41:39.459072 [debug] [Thread-2 (]: SQL status: OK in 0.000 seconds
[0m13:41:39.461068 [debug] [Thread-2 (]: On seed.producer_project.property_data_seed: Close
[0m13:41:39.462092 [debug] [Thread-1 (]: Sending event: {'category': 'dbt', 'action': 'run_model', 'label': '0bb9e712-4cf6-4677-8a0a-118b45fba01b', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000001BAB47505F0>]}
[0m13:41:39.463073 [info ] [Thread-1 (]: 1 of 5 OK loaded seed file C##DBTUSER.mortgage_application_seed ................ [[32mINSERT 20[0m in 2.24s]
[0m13:41:39.464073 [debug] [Thread-2 (]: Sending event: {'category': 'dbt', 'action': 'run_model', 'label': '0bb9e712-4cf6-4677-8a0a-118b45fba01b', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000001BAB74A86E0>]}
[0m13:41:39.465086 [debug] [Thread-1 (]: Finished running node seed.producer_project.mortgage_application_seed
[0m13:41:39.466087 [info ] [Thread-2 (]: 2 of 5 OK loaded seed file C##DBTUSER.property_data_seed ....................... [[32mINSERT 20[0m in 2.25s]
[0m13:41:39.468036 [debug] [Thread-2 (]: Finished running node seed.producer_project.property_data_seed
[0m13:41:39.469034 [debug] [Thread-4 (]: Began running node model.producer_project.property_data_product
[0m13:41:39.470035 [info ] [Thread-4 (]: 3 of 5 START sql view model C##DBTUSER.property_data_product ................... [RUN]
[0m13:41:39.471035 [debug] [Thread-4 (]: Acquiring new oracle connection 'model.producer_project.property_data_product'
[0m13:41:39.472034 [debug] [Thread-4 (]: Began compiling node model.producer_project.property_data_product
[0m13:41:39.483077 [debug] [Thread-4 (]: Writing injected SQL for node "model.producer_project.property_data_product"
[0m13:41:39.485034 [debug] [Thread-4 (]: Began executing node model.producer_project.property_data_product
[0m13:41:39.525070 [debug] [Thread-4 (]: Using oracle connection "model.producer_project.property_data_product"
[0m13:41:39.526079 [debug] [Thread-4 (]: On model.producer_project.property_data_product: /* {"app": "dbt", "dbt_version": "1.9.4", "profile_name": "producer_project", "target_name": "dev", "node_id": "model.producer_project.property_data_product"} */

    select * from (
        
--

  SELECT 
    Cast (prop_data.property_id as int) property_id,
    mort_data.mortgage_id,
    prop_data.property_type,
    prop_data.living_area,
    --mort_data.create_date --zum zeigen von Enforce Model (contract sagt Date, aber ohne Spezification wird es Timestamp) (Null/Fehler bei Testdaten wird auch erkannt)
    Cast( mort_data.create_date as date) create_date
FROM 
    C##DBTUSER.mortgage_application_seed  mort_data
LEFT JOIN 
    C##DBTUSER.property_data_seed  prop_data
ON 
    prop_data.property_id = mort_data.property_id
    ) dbt_sbq_tmp
    where 1 = 0 and rownum < 1

[0m13:41:39.529089 [debug] [Thread-4 (]: Opening a new connection, currently in state init
[0m13:41:39.530035 [debug] [Thread-4 (]: oracle adapter: Attempting to connect using Oracle method: 'OracleConnectionMethod.HOST' and dsn: 'tcp://localhost:1521/free?retry_count=1&retry_delay=3'
[0m13:41:41.616349 [debug] [Thread-4 (]: oracle adapter: Session info :{"action": "DBT RUN", "client_identifier": "dbt-oracle-client-34f6cdb3-be1a-4e37-9d4b-007821f6c6ba", "clientinfo": "9SL7HW3_AMD64", "module": "dbt-1.9.4"}
[0m13:41:41.628363 [debug] [Thread-4 (]: SQL status: OK in 2.000 seconds
[0m13:41:41.643323 [debug] [Thread-4 (]: Using oracle connection "model.producer_project.property_data_product"
[0m13:41:41.644349 [debug] [Thread-4 (]: On model.producer_project.property_data_product: /* {"app": "dbt", "dbt_version": "1.9.4", "profile_name": "producer_project", "target_name": "dev", "node_id": "model.producer_project.property_data_product"} */

    select * from (
        select
    cast(null as NUMBER) as property_id, cast(null as NUMBER) as mortgage_id, cast(null as VARCHAR2(4000)) as property_type, cast(null as NUMBER) as living_area, cast(null as DATE) as create_date
     from dual
    ) dbt_sbq_tmp
    where 1 = 0 and rownum < 1

[0m13:41:41.647291 [debug] [Thread-4 (]: SQL status: OK in 0.000 seconds
[0m13:41:41.658343 [debug] [Thread-4 (]: Writing runtime sql for node "model.producer_project.property_data_product"
[0m13:41:41.660293 [debug] [Thread-4 (]: Using oracle connection "model.producer_project.property_data_product"
[0m13:41:41.661294 [debug] [Thread-4 (]: On model.producer_project.property_data_product: /* {"app": "dbt", "dbt_version": "1.9.4", "profile_name": "producer_project", "target_name": "dev", "node_id": "model.producer_project.property_data_product"} */

  
  create or replace view C##DBTUSER.property_data_product as
    
--

  SELECT 
    Cast (prop_data.property_id as int) property_id,
    mort_data.mortgage_id,
    prop_data.property_type,
    prop_data.living_area,
    --mort_data.create_date --zum zeigen von Enforce Model (contract sagt Date, aber ohne Spezification wird es Timestamp) (Null/Fehler bei Testdaten wird auch erkannt)
    Cast( mort_data.create_date as date) create_date
FROM 
    C##DBTUSER.mortgage_application_seed  mort_data
LEFT JOIN 
    C##DBTUSER.property_data_seed  prop_data
ON 
    prop_data.property_id = mort_data.property_id


[0m13:41:41.669358 [debug] [Thread-4 (]: SQL status: OK in 0.000 seconds
[0m13:41:41.671324 [debug] [Thread-4 (]: On model.producer_project.property_data_product: COMMIT
[0m13:41:41.672327 [debug] [Thread-4 (]: Using oracle connection "model.producer_project.property_data_product"
[0m13:41:41.673321 [debug] [Thread-4 (]: On model.producer_project.property_data_product: COMMIT
[0m13:41:41.675350 [debug] [Thread-4 (]: SQL status: OK in 0.000 seconds
[0m13:41:41.684292 [debug] [Thread-4 (]: Using oracle connection "model.producer_project.property_data_product"
[0m13:41:41.685293 [debug] [Thread-4 (]: On model.producer_project.property_data_product: /* {"app": "dbt", "dbt_version": "1.9.4", "profile_name": "producer_project", "target_name": "dev", "node_id": "model.producer_project.property_data_product"} */
DECLARE
     dne_942    EXCEPTION;
     PRAGMA EXCEPTION_INIT(dne_942, -942);
     attempted_ddl_on_in_use_GTT EXCEPTION;
     pragma EXCEPTION_INIT(attempted_ddl_on_in_use_GTT, -14452);
     mv_dne_12003 EXCEPTION;
     PRAGMA EXCEPTION_INIT(mv_dne_12003, -12003);
  BEGIN
     SAVEPOINT start_transaction;EXECUTE IMMEDIATE 'DROP view C##DBTUSER.property_data_product__dbt_backup cascade constraints';COMMIT;
  EXCEPTION
     WHEN attempted_ddl_on_in_use_GTT THEN
        NULL; -- if it its a global temporary table, leave it alone.
     WHEN dne_942 THEN
        NULL;
     WHEN mv_dne_12003 THEN
        NULL;
  END;
[0m13:41:41.689346 [debug] [Thread-4 (]: SQL status: OK in 0.000 seconds
[0m13:41:41.692333 [debug] [Thread-4 (]: On model.producer_project.property_data_product: Close
[0m13:41:41.694395 [debug] [Thread-4 (]: Sending event: {'category': 'dbt', 'action': 'run_model', 'label': '0bb9e712-4cf6-4677-8a0a-118b45fba01b', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000001BAB74396D0>]}
[0m13:41:41.695331 [info ] [Thread-4 (]: 3 of 5 OK created sql view model C##DBTUSER.property_data_product .............. [[32mOK[0m in 2.22s]
[0m13:41:41.697330 [debug] [Thread-4 (]: Finished running node model.producer_project.property_data_product
[0m13:41:41.698331 [debug] [Thread-1 (]: Began running node test.producer_project.dbt_expectations_expect_column_values_to_be_between_property_data_product_mortgage_id__0.db8dcf8b92
[0m13:41:41.699349 [debug] [Thread-2 (]: Began running node test.producer_project.dbt_expectations_expect_column_values_to_be_between_property_data_product_property_id__0.8ca909c8ac
[0m13:41:41.700291 [info ] [Thread-1 (]: 4 of 5 START test dbt_expectations_expect_column_values_to_be_between_property_data_product_mortgage_id__0  [RUN]
[0m13:41:41.701292 [info ] [Thread-2 (]: 5 of 5 START test dbt_expectations_expect_column_values_to_be_between_property_data_product_property_id__0  [RUN]
[0m13:41:41.702348 [debug] [Thread-1 (]: Re-using an available connection from the pool (formerly seed.producer_project.mortgage_application_seed, now test.producer_project.dbt_expectations_expect_column_values_to_be_between_property_data_product_mortgage_id__0.db8dcf8b92)
[0m13:41:41.703336 [debug] [Thread-2 (]: Re-using an available connection from the pool (formerly seed.producer_project.property_data_seed, now test.producer_project.dbt_expectations_expect_column_values_to_be_between_property_data_product_property_id__0.8ca909c8ac)
[0m13:41:41.704290 [debug] [Thread-1 (]: Began compiling node test.producer_project.dbt_expectations_expect_column_values_to_be_between_property_data_product_mortgage_id__0.db8dcf8b92
[0m13:41:41.705290 [debug] [Thread-2 (]: Began compiling node test.producer_project.dbt_expectations_expect_column_values_to_be_between_property_data_product_property_id__0.8ca909c8ac
[0m13:41:41.732398 [debug] [Thread-1 (]: Writing injected SQL for node "test.producer_project.dbt_expectations_expect_column_values_to_be_between_property_data_product_mortgage_id__0.db8dcf8b92"
[0m13:41:41.738389 [debug] [Thread-2 (]: Writing injected SQL for node "test.producer_project.dbt_expectations_expect_column_values_to_be_between_property_data_product_property_id__0.8ca909c8ac"
[0m13:41:41.740291 [debug] [Thread-1 (]: Began executing node test.producer_project.dbt_expectations_expect_column_values_to_be_between_property_data_product_mortgage_id__0.db8dcf8b92
[0m13:41:41.741331 [debug] [Thread-2 (]: Began executing node test.producer_project.dbt_expectations_expect_column_values_to_be_between_property_data_product_property_id__0.8ca909c8ac
[0m13:41:41.767297 [debug] [Thread-1 (]: Writing runtime sql for node "test.producer_project.dbt_expectations_expect_column_values_to_be_between_property_data_product_mortgage_id__0.db8dcf8b92"
[0m13:41:41.770390 [debug] [Thread-2 (]: Writing runtime sql for node "test.producer_project.dbt_expectations_expect_column_values_to_be_between_property_data_product_property_id__0.8ca909c8ac"
[0m13:41:41.773293 [debug] [Thread-1 (]: Opening a new connection, currently in state closed
[0m13:41:41.773293 [debug] [Thread-2 (]: Opening a new connection, currently in state closed
[0m13:41:41.774290 [debug] [Thread-1 (]: oracle adapter: Attempting to connect using Oracle method: 'OracleConnectionMethod.HOST' and dsn: 'tcp://localhost:1521/free?retry_count=1&retry_delay=3'
[0m13:41:41.775291 [debug] [Thread-2 (]: oracle adapter: Attempting to connect using Oracle method: 'OracleConnectionMethod.HOST' and dsn: 'tcp://localhost:1521/free?retry_count=1&retry_delay=3'
[0m13:41:43.849330 [debug] [Thread-2 (]: oracle adapter: Session info :{"action": "DBT RUN", "client_identifier": "dbt-oracle-client-892a74c4-a18d-488b-8570-f5b8e1912608", "clientinfo": "9SL7HW3_AMD64", "module": "dbt-1.9.4"}
[0m13:41:43.850290 [debug] [Thread-2 (]: Using oracle connection "test.producer_project.dbt_expectations_expect_column_values_to_be_between_property_data_product_property_id__0.8ca909c8ac"
[0m13:41:43.851344 [debug] [Thread-2 (]: On test.producer_project.dbt_expectations_expect_column_values_to_be_between_property_data_product_property_id__0.8ca909c8ac: /* {"app": "dbt", "dbt_version": "1.9.4", "profile_name": "producer_project", "target_name": "dev", "node_id": "test.producer_project.dbt_expectations_expect_column_values_to_be_between_property_data_product_property_id__0.8ca909c8ac"} */

    select
      count(*) as failures,
      case when count(*) != 0 then 1 else 0 end as should_warn,
      case when count(*) != 0 then 1 else 0 end as should_error
    from (
      
    
  






    with grouped_expression as (
    select
        
        
    
  
( 1=1 and property_id >= 0
)
 as expression


    from C##DBTUSER.property_data_product
    

),
validation_errors as (

    select
        *
    from
        grouped_expression
    where
        not(expression = true)

)

select *
from validation_errors








  
  
      
    ) dbt_internal_test
[0m13:41:43.862218 [debug] [Thread-1 (]: oracle adapter: Session info :{"action": "DBT RUN", "client_identifier": "dbt-oracle-client-d2b1be52-06bd-465d-a04d-8df71eb6b683", "clientinfo": "9SL7HW3_AMD64", "module": "dbt-1.9.4"}
[0m13:41:43.862218 [debug] [Thread-2 (]: SQL status: OK in 0.000 seconds
[0m13:41:43.863218 [debug] [Thread-1 (]: Using oracle connection "test.producer_project.dbt_expectations_expect_column_values_to_be_between_property_data_product_mortgage_id__0.db8dcf8b92"
[0m13:41:43.867241 [debug] [Thread-2 (]: On test.producer_project.dbt_expectations_expect_column_values_to_be_between_property_data_product_property_id__0.8ca909c8ac: ROLLBACK
[0m13:41:43.868222 [debug] [Thread-1 (]: On test.producer_project.dbt_expectations_expect_column_values_to_be_between_property_data_product_mortgage_id__0.db8dcf8b92: /* {"app": "dbt", "dbt_version": "1.9.4", "profile_name": "producer_project", "target_name": "dev", "node_id": "test.producer_project.dbt_expectations_expect_column_values_to_be_between_property_data_product_mortgage_id__0.db8dcf8b92"} */

    select
      count(*) as failures,
      case when count(*) != 0 then 1 else 0 end as should_warn,
      case when count(*) != 0 then 1 else 0 end as should_error
    from (
      
    
  






    with grouped_expression as (
    select
        
        
    
  
( 1=1 and mortgage_id >= 0
)
 as expression


    from C##DBTUSER.property_data_product
    

),
validation_errors as (

    select
        *
    from
        grouped_expression
    where
        not(expression = true)

)

select *
from validation_errors








  
  
      
    ) dbt_internal_test
[0m13:41:43.870221 [debug] [Thread-2 (]: On test.producer_project.dbt_expectations_expect_column_values_to_be_between_property_data_product_property_id__0.8ca909c8ac: Close
[0m13:41:43.875263 [info ] [Thread-2 (]: 5 of 5 PASS dbt_expectations_expect_column_values_to_be_between_property_data_product_property_id__0  [[32mPASS[0m in 2.17s]
[0m13:41:43.876193 [debug] [Thread-2 (]: Finished running node test.producer_project.dbt_expectations_expect_column_values_to_be_between_property_data_product_property_id__0.8ca909c8ac
[0m13:41:43.880186 [debug] [Thread-1 (]: SQL status: OK in 0.000 seconds
[0m13:41:43.882219 [debug] [Thread-1 (]: On test.producer_project.dbt_expectations_expect_column_values_to_be_between_property_data_product_mortgage_id__0.db8dcf8b92: ROLLBACK
[0m13:41:43.884218 [debug] [Thread-1 (]: On test.producer_project.dbt_expectations_expect_column_values_to_be_between_property_data_product_mortgage_id__0.db8dcf8b92: Close
[0m13:41:43.886226 [info ] [Thread-1 (]: 4 of 5 PASS dbt_expectations_expect_column_values_to_be_between_property_data_product_mortgage_id__0  [[32mPASS[0m in 2.18s]
[0m13:41:43.888185 [debug] [Thread-1 (]: Finished running node test.producer_project.dbt_expectations_expect_column_values_to_be_between_property_data_product_mortgage_id__0.db8dcf8b92
[0m13:41:43.890187 [debug] [MainThread]: Opening a new connection, currently in state closed
[0m13:41:43.891229 [debug] [MainThread]: oracle adapter: Attempting to connect using Oracle method: 'OracleConnectionMethod.HOST' and dsn: 'tcp://localhost:1521/free?retry_count=1&retry_delay=3'
[0m13:41:45.979313 [debug] [MainThread]: oracle adapter: Session info :{"action": "DBT RUN", "client_identifier": "dbt-oracle-client-aea4c8c4-31b1-4520-910d-fb578db9a41e", "clientinfo": "9SL7HW3_AMD64", "module": "dbt-1.9.4"}
[0m13:41:45.980375 [debug] [MainThread]: On master: COMMIT
[0m13:41:45.981354 [debug] [MainThread]: Using oracle connection "master"
[0m13:41:45.981354 [debug] [MainThread]: On master: COMMIT
[0m13:41:45.983427 [debug] [MainThread]: SQL status: OK in 0.000 seconds
[0m13:41:45.984360 [debug] [MainThread]: On master: Close
[0m13:41:45.986313 [debug] [MainThread]: Connection 'master' was properly closed.
[0m13:41:45.987318 [debug] [MainThread]: Connection 'list_FREE' was properly closed.
[0m13:41:45.988350 [debug] [MainThread]: Connection 'list_FREE_C##DBTUSER' was properly closed.
[0m13:41:45.989313 [debug] [MainThread]: Connection 'test.producer_project.dbt_expectations_expect_column_values_to_be_between_property_data_product_mortgage_id__0.db8dcf8b92' was properly closed.
[0m13:41:45.990312 [debug] [MainThread]: Connection 'test.producer_project.dbt_expectations_expect_column_values_to_be_between_property_data_product_property_id__0.8ca909c8ac' was properly closed.
[0m13:41:45.991376 [debug] [MainThread]: Connection 'model.producer_project.property_data_product' was properly closed.
[0m13:41:45.993355 [info ] [MainThread]: 
[0m13:41:45.994361 [info ] [MainThread]: Finished running 2 seeds, 2 data tests, 1 view model in 0 hours 0 minutes and 15.22 seconds (15.22s).
[0m13:41:45.996313 [debug] [MainThread]: Command end result
[0m13:41:46.085356 [debug] [MainThread]: Wrote artifact WritableManifest to C:\dev\data_contract_showcase\producer_project\target\manifest.json
[0m13:41:46.089348 [debug] [MainThread]: Wrote artifact SemanticManifest to C:\dev\data_contract_showcase\producer_project\target\semantic_manifest.json
[0m13:41:46.096406 [debug] [MainThread]: Wrote artifact RunExecutionResult to C:\dev\data_contract_showcase\producer_project\target\run_results.json
[0m13:41:46.097350 [info ] [MainThread]: 
[0m13:41:46.098348 [info ] [MainThread]: [32mCompleted successfully[0m
[0m13:41:46.099348 [info ] [MainThread]: 
[0m13:41:46.100314 [info ] [MainThread]: Done. PASS=5 WARN=0 ERROR=0 SKIP=0 TOTAL=5
[0m13:41:46.101315 [debug] [MainThread]: Command `dbt build` succeeded at 13:41:46.101315 after 17.01 seconds
[0m13:41:46.102401 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'end', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000001BAB502D910>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000001BAB502CE30>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000001BAB502DE80>]}
[0m13:41:46.103368 [debug] [MainThread]: Flushing usage events
[0m13:41:47.814596 [debug] [MainThread]: An error was encountered while trying to flush usage events
```

### Environment

```markdown
- OS: Windows 10
- Python: 3.12.10
- dbt: 1.9.4
- dbt.oracle adapter: 1.9.1
- Oracle Docker: container-registry.oracle.com/database/free:latest
```

### What Oracle database version are you using dbt with?

_No response_

### Additional Context

_No response_

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

[Bug] Problem with materializing my models #178

Is there an existing issue for this?

Current Behavior

Expected Behavior

Steps To Reproduce

Relevant log output using `--debug` flag enabled

Environment

What Oracle database version are you using dbt with?

Additional Context

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

[Bug] Problem with materializing my models #178

Description

Is there an existing issue for this?

Current Behavior

Expected Behavior

Steps To Reproduce

Relevant log output using --debug flag enabled

Environment

What Oracle database version are you using dbt with?

Additional Context

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions

Relevant log output using `--debug` flag enabled