DBT External tables don't work with the --empty flag

[DanMawdsleyBA]

Is this a new bug in dbt-core?

• I believe this is a new bug in dbt-core
• I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

I am currently using the lastest version of the dbt_external_tables package. The external table builds successfully but does not when I run with the empty flag. I get a sql error with an incorrect bracket. I have the external table and then a view that runs after the external table.

Expected Behavior

Be able to create external tables with the --empty flag

Steps To Reproduce

Create an external table
Run the external table with the --empty flag

Relevant log output

SQL compilation error:
  syntax error line 1 at position 33 unexpected '('.
  syntax error line 1 at position 34 unexpected 'select'.

Log sql here:

create or replace external table (select * from DB_INT.EXTERNAL.e_it_integration_test_json where false limit 0)
    location = @DB_INT.landing.ba_olympus_cleaned/integration_test-empty 
    auto_refresh = True
    file_format = DB_DEV.landing.JSON_FORMAT

Environment

- OS: Windows
- Python: 3.11
- dbt: 1.8

Which database adapter are you using with dbt?

snowflake

Additional Context

No response

[dbeatty10]

Thanks for raising this issue @DanMawdsleyBA.

Could you share examples of the commands you are running?