Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
1 of 3 tasks
WesleyBatista opened this issue Apr 20, 2023 · 3 comments · Fixed by #240
Closed
1 of 3 tasks

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

WesleyBatista opened this issue Apr 20, 2023 · 3 comments · Fixed by #240
Labels
bug Something isn't working snowflake triage
Milestone

Comments

@WesleyBatista
Copy link

WesleyBatista commented Apr 20, 2023

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?

  • redshift
  • snowflake
  • other (specify: ____________)

The output of dbt --version:

1.3

The operating system you're using:

The output of python --version:

Additional context

Using DBT Cloud

@tamasmrton
Copy link

bump

1 similar comment
@aaronchao0220
Copy link

bump

@WesleyBatista
Copy link
Author

More recent pr: #240

@dataders dataders mentioned this issue Apr 4, 2024
3 tasks
@dataders dataders added this to the 0.9.0 milestone Apr 12, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working snowflake triage
Projects
None yet
4 participants