snowflake delta format - Githubissues

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

288 stars 116 forks source link

snowflake delta format #240

Closed danielefrigo closed 3 months ago

danielefrigo commented 8 months ago

Description & motivation

resolves: #198

Snowflake supports external tables on Delta format external stages, but they do not support automatic refresh. When creating them, it's mandatory to specify refresh_on_create = false.

Checklist

[x] I have verified that these changes work locally
[x] I have updated the README.md (if applicable)
[x] I have added an integration test for my fix/feature (if applicable)

rolandlaaper commented 4 months ago

It would be great if this PR is completed @jeremyyeo because at this moment external tables in delta can't be created using the package.