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

Consider implementing run locking #248

Closed
jthandy opened this issue Dec 13, 2016 · 2 comments
Closed

Consider implementing run locking #248

jthandy opened this issue Dec 13, 2016 · 2 comments
Labels
enhancement New feature or request

Comments

@jthandy
Copy link
Member

jthandy commented Dec 13, 2016

Could be a useful feature, although we haven't heard the need for it directly from users yet. Check out how Snowplow implemented here:

snowplow/sql-runner#75

@jthandy jthandy added the enhancement New feature or request label Dec 13, 2016
@drewbanin
Copy link
Contributor

yeah -- this is interesting. We'd probably want to lock at the schema level. That way multiple users can run dbt in their own schemas, but the analytics schema (for instance) can only have one writer at a time. let me think a little more about that

@cmcarthur
Copy link
Member

this relies on consul which is not really easily included into an analytics stack. the most interesting approach for this IMO is to use SQL to implement run-locking. on that topic, it'd be interesting to talk about keeping a record of dbt runs in the warehouse.

yu-iskw pushed a commit to yu-iskw/dbt that referenced this issue Aug 17, 2021
…ct-pivot

Add distinct argument to pivot macro. fka dbt-labs#213
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

3 participants