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
297 stars 119 forks source link

Fix/snowflake refresh commit #98

Closed jasonzondor closed 3 years ago

jasonzondor commented 3 years ago

Description & motivation

For Snowflake, the "alter external table

refresh" statement is not being committed. I've just wrapped the statement with begin; and commit; and this seems to fix the issue.

Checklist

jasonzondor commented 3 years ago

Related Issue: https://github.com/fishtown-analytics/dbt-external-tables/issues/95

jasonzondor commented 3 years ago

@jtcohen6, I agree. There has to be a better way. But thank you! When I get some more time to work on it, I'll try and dig into it further.

  • © Githubissues.
  • Githubissues is a development platform for aggregating issues.