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

when rebuilding tables, dbt should use table renaming to minimize amount of time the table is unavailable #68

Closed
jthandy opened this issue Jul 21, 2016 · 2 comments
Assignees
Labels
enhancement New feature or request
Milestone

Comments

@jthandy
Copy link
Member

jthandy commented Jul 21, 2016

rather than dropping the table and then rebuilding it from a query, it would be better to create a new table with a temporary name, wait for the query to finish, then drop the old table, then rename the new table to the correct name. this would result in a significantly smaller window in which the table was unavailable for querying.

@jthandy jthandy added the enhancement New feature or request label Jul 21, 2016
@jthandy jthandy modified the milestone: 0.2.5.0 Jul 25, 2016
@drewbanin drewbanin self-assigned this Jul 25, 2016
@doncorrea-vroom
Copy link

doncorrea-vroom commented Jun 10, 2020

Was this enhancement request ever addressed? We're encountering issues with timing of our dbt model runs coinciding with looker queries or scheduled reports which ultimately errors out with "table does not exist". Using v 0.16.1

@drewbanin
Copy link
Contributor

hey @doncorrea-vroom - can you create a new issue if you're having an issue with dbt v0.16.1? Thanks!

yu-iskw pushed a commit to yu-iskw/dbt that referenced this issue Aug 17, 2021
short circuit parsing for introspective macros
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