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

dbt fails without create schema permissions #66

Closed
jthandy opened this issue Jul 21, 2016 · 0 comments
Closed

dbt fails without create schema permissions #66

jthandy opened this issue Jul 21, 2016 · 0 comments
Assignees
Labels
bug Something isn't working
Milestone

Comments

@jthandy
Copy link
Member

jthandy commented Jul 21, 2016

dbt is trying to run the following during dbt run:

cursor.execute('create schema if not exists "{}"'.format(target_cfg['schema']))

this is a convenient way to create the schema if it doesn't exist, but it requires the user to have create schema privileges. it's reasonable to assume the user will not have create schema privileges, and in this case dbt will just need to verify that the requested schema does, in fact, exist--and it will need to do so in a way that does not require admin privileges (aka does not use system tables).

@jthandy jthandy added the bug Something isn't working label Jul 21, 2016
@jthandy jthandy changed the title dbt fails without admin permissions dbt fails without create schema permissions Jul 21, 2016
@jthandy jthandy modified the milestone: 0.2.5.0 Jul 25, 2016
@drewbanin drewbanin assigned drewbanin and unassigned drewbanin Jul 25, 2016
yu-iskw pushed a commit to yu-iskw/dbt that referenced this issue Aug 17, 2021
…t-timestamp-in-utc

Feature/current timestamp in utc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants