the-data-base / nhl-data

Repo for version control the dbt transformations on nhl-breakouts data

5 stars 0 forks source link

Remove order by clause to improve query performance #42

Closed gavh3 closed 2 years ago

gavh3 commented 2 years ago

Overview

Remove order by clause in live_plays because it was causing BQ to run out of memory during query runtime

Changes

Details about what was changed

Other notes

Any other things that the reviewer should know about

Checks

[x] All models ran successfully
[x] Changes to models are reflected in the schema.yml Pick one:
[x] No test failures OR
[ ] No new test failures, and there is a plan in place to address existing ones