search

dbt-labs / dbt-external-tables

dbt macros to stage external sources
https://hub.getdbt.com/dbt-labs/dbt_external_tables/latest/
Apache License 2.0
294 stars 119 forks source link

Can't create Snowflake External Table of `table_format: delta` #198

Closed WesleyBatista closed 4 months ago

WesleyBatista commented 1 year ago

Describe the bug

Getting:

Encountered an error while running operation: Database Error
  001425 (22023): SQL compilation error:
  invalid property combination 'REFRESH_ON_CREATE'='true' and 'TABLE_FORMAT'='DELTA'

I've notice the macro doesn't account for the REFRESH_ON_CREATE field - docs.

The fix looks simple. I will come up with an PR.

Steps to reproduce

Expected results

Actual results

Screenshots and log output

System information

The contents of your packages.yml file:

Which database are you using dbt with?

The output of dbt --version:

1.3

The operating system you're using:

The output of python --version:

Additional context

Using DBT Cloud

tamasmrton commented 9 months ago

bump

aaronchao0220 commented 7 months ago

bump

WesleyBatista commented 7 months ago

More recent pr: https://github.com/dbt-labs/dbt-external-tables/pull/240