DBT run Error Runtime

Help
1

What I’ve already tried

I tried to do a dbt run --select test.sql

Some example code or error messages

Running with dbt=1.5.1
Found 29 models, 0 tests, 0 snapshots, 0 analyses, 491 macros, 0 operations, 0 seed files, 0 sources, 0 exposures, 0 metrics, 0 groups

Concurrency: 8 threads (target='dev')

1 of 1 START sql table model z_aitana_test.test ................................ [RUN]
1 of 1 ERROR creating sql table model z_aitana_test.test ....................... [ERROR in 3.39s]

Finished running 1 table model in 0 hours 0 minutes and 8.60 seconds (8.60s). 

Completed with 1 error and 0 warnings:

Runtime Error in model test (models/medallion/bronze/test.sql)
TABLE_NOT_FOUND: line 32:3: Table '....' does not exist. You may need to manually clean the data at location 's3://bd-dev-athena-results/output/tables/c44a714a-0c6b-4a60-96eb-43f1d4791d2b' before retrying. Athena will not delete data in your account.

Done. PASS=0 WARN=0 ERROR=1 SKIP=0 TOTAL=1
2

can you please post the compiled sql here

3

Yes, of course. This is my first time with dbt so it’s a simple model:

{{ config(
    schema = "i_d",
    table_type='iceberg',
    format='parquet',
    materialized='table',
    s3_data_naming='schema_table_unique',
    table_properties={
    	'optimize_rewrite_delete_file_threshold': '2'
    	},
    tags=['NonSensitive'],
) }}


SELECT
    operationid,
    events_eventid,
    event_type,
    events_clienttimestamp,
    events_clienttimestamp_ts,
    source,
    events_payload_devicetype,
    events_payload_brand,
    events_payload_model,
    events_payload_osname,
    events_payload_osversion,
    events_payload_longitude,
    events_payload_latitude
FROM
    {{ ref('bronze_master') }}
WHERE
    event_type IN ('DEVICE', 'COORDINATES')