search

GoogleCloudPlatform / bigquery-antipattern-recognition

Utility to identify and rewrite common anti patterns in BigQuery SQL syntax
Apache License 2.0
76 stars 26 forks source link

Feature Request: Add new anti-pattern detector which finds ORDER BYs without a subsequent LIMIT clause #20

Closed danieldeleo closed 1 year ago

danieldeleo commented 1 year ago

https://cloud.google.com/bigquery/docs/best-practices-performance-filter-order#use_limit_with_an_order_by_clause

franklinWhaite commented 1 year ago

Does this meet the requirements?

danieldeleo commented 1 year ago

oh nice! It was just not documented when I filed this request 👍 yes this meets the requirement