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.

Sign up for GitHub

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

Jump to bottom

Implement incremental models with "merge" on Snowflake #1414

Closed
drewbanin opened this issue Apr 24, 2019 · 1 comment
Closed

Implement incremental models with "merge" on Snowflake #1414

drewbanin opened this issue Apr 24, 2019 · 1 comment
Labels
enhancement New feature or request snowflake
Milestone
Wilt Chamberlain

Comments

@drewbanin
Copy link
Contributor

Feature

Feature description

dbt's incremental models should use a merge statement to incrementally load data into a table.

If no unique_key is provided, dbt should use a simple insert statement, as Snowflake doesn't like merging on a constant false predicate. More info here

This is a backfilled issue for some currently-open PRs that implement the functionality described in this issue:

See also: #1101
@drewbanin drewbanin added enhancement New feature or request snowflake labels Apr 24, 2019
@drewbanin drewbanin added this to the Wilt Chamberlain milestone Apr 24, 2019
@drewbanin drewbanin mentioned this issue Apr 24, 2019
Merged
@drewbanin
Copy link
Contributor Author

Fixed in #1409

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement New feature or request snowflake
Projects
None yet
Milestone
Wilt Chamberlain
Development

No branches or pull requests
1 participant
@drewbanin