[Bug] Error macro 'dbt_macro__create_schema' takes not more than 1 argument(s) while doing snapshots

[ricardoalexanderh]

Is there an existing issue for this?

• [X] I have searched the existing issues

Current Behavior

I got this error when running dbt snapshot

03:36:00 Running with dbt=1.8.3 03:36:00 oracle adapter: Running in thin mode 03:36:01 Registered adapter: oracle=1.8.0 03:36:03 Found 1 snapshot, 1 source, 464 macros 03:36:03 03:36:04 Concurrency: 1 threads (target='dev') 03:36:04 03:36:04 1 of 1 START snapshot CUSTOMER_SNAPSHOTS.customers_snapshot_check .............. [RUN] 03:36:04 1 of 1 ERROR snapshotting CUSTOMER_SNAPSHOTS.customers_snapshot_check .......... [ERROR in 0.21s] 03:36:04 03:36:04 Finished running 1 snapshot in 0 hours 0 minutes and 0.95 seconds (0.95s). 03:36:04 03:36:04 Completed with 1 error and 0 warnings: 03:36:04 03:36:04 Compilation Error in snapshot customers_snapshot_check (snapshots\customers_snapshot_check.sql) macro 'dbt_macro__create_schema' takes not more than 1 argument(s)

in macro materialization_snapshot_oracle (macros\materializations\snapshot\snapshot.sql) called by snapshot customers_snapshot_check (snapshots\customers_snapshot_check.sql) 03:36:04 03:36:04 Done. PASS=0 WARN=0 ERROR=1 SKIP=0 TOTAL=1

Expected Behavior

Snapshot run successfully

Steps To Reproduce

1. Create a snapshot

{% snapshot customers_snapshot_check %}

{{
    config(
      target_schema='CUSTOMER_SNAPSHOTS',
      strategy='check',
      unique_key='CUSTOMER_ID',
      check_cols=['CUSTOMER_NAME'],
      invalidate_hard_deletes=True
    )
}}

select * from {{ source('dbksei', 'CUSTOMER') }}

{% endsnapshot %}

3. Run dbt snapshot

Relevant log output using --debug flag enabled

No response

Environment

- OS: Windows 10
- Python: 3.9.6
- dbt: 1.8.3

What Oracle database version are you using dbt with?

18c

Additional Context

No response