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

[Stephen Girard] Incorrect alter table statement on Snowflake #1316

Closed
drewbanin opened this issue Feb 24, 2019 · 0 comments
Closed

[Stephen Girard] Incorrect alter table statement on Snowflake #1316

drewbanin opened this issue Feb 24, 2019 · 0 comments
Assignees
Labels
bug Something isn't working

Comments

@drewbanin
Copy link
Contributor

drewbanin commented Feb 24, 2019

Issue

Issue description

The 0.13.0-a2 release of dbt has a regression which causes Snowflake alter table statements to be built incorrectly.

Previously:

alter table db.schema.table__dbt_tmp rename to db.schema.table

In 0.13.0-a2:

alter table db.schema.table__dbt_tmp rename to table

As such, Snowflake tables/views defined to be built in custom schemas will instead be built in the target database/schema defined in the user's profile. Downstream models that select from these models will not find the relation, as it was built into a different schema than the one specified.

System information

The output of dbt --version:

0.13.0-a2

EDIT: This didn't appear to be an 0.13.0 alpha regression, and instead has lived inside of dbt for quite some time! Fixed in 0.13.0

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

1 participant