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

General enhancements #61

Closed franklinWhaite closed 3 months ago

afleisc commented 4 months ago

maybe its just my configuration but I ran the rewrite example from the README:

docker run \
    -v ~/.config:/root/.config \
    -i bigquery-antipattern-recognition \
    --query "select col1 from table1 where col2 like '%abc%' and col3=1" \
    --rewrite_sql \
    --processing_project_id <my-project>

and I got an error for rewrite

Screenshot 2024-03-11 at 11 44 37 AM
franklinWhaite commented 3 months ago

@afleisc nice catch! just fixed the bug, feel free to test again

afleisc commented 3 months ago

LGTM

Screenshot 2024-03-12 at 10 39 44 AM