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

Cache introspective queries during parsing #1306

Closed
drewbanin opened this issue Feb 20, 2019 · 1 comment
Closed

Cache introspective queries during parsing #1306

drewbanin opened this issue Feb 20, 2019 · 1 comment
Labels
enhancement New feature or request
Milestone
Wilt Chamberlain

Comments

@drewbanin
Copy link
Contributor

Feature

Feature description

dbt v0.12.0 added caching for introspective queries to the compilation step of a dbt invocation. dbt should also cache introspective query results during parsing. This will reduce project runtimes and database load (compelling in its own right) and should hopefully also reduce the incidence of #1305.

Who will this benefit?

Snowflake users: introspective queries can be really slow
Redshift users: Redshift quirks cause some introspective queries to fail, so the fewer we run the better!
@drewbanin drewbanin added the enhancement New feature or request label Feb 20, 2019
@drewbanin drewbanin mentioned this issue Feb 27, 2019
Closed
@drewbanin drewbanin added this to the Wilt Chamberlain milestone Mar 25, 2019
@drewbanin
Copy link
Contributor Author

Fixed in #1413

We stub out these calls, rather than caching them

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
Projects
None yet
Milestone
Wilt Chamberlain
Development

No branches or pull requests
1 participant
@drewbanin