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

Enable "recursive" detection in GCS #50

Closed afleisc closed 6 months ago

afleisc commented 6 months ago

Removing the current directory parameter allows this function to return all SQL files in the bucket rather than only the ones in one directory.

See this link for an example

franklinWhaite commented 6 months ago

Ran a test and noticed:

A quick fix would be to add a filter for file names with ending with .sql