GoogleCloudPlatform / bigquery-antipattern-recognition

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

Query hash workflow terraform #55

Open afleisc opened 7 months ago

afleisc commented 7 months ago

Optionally, a Cloud Workflow can be deployed obtain query hashes, run the antipattern tool, and join the recommendation back on to the hashes. This is useful to run the antipattern tool across queries that may be repeated many times. Read more about query hashes here. When you want to run the Cloud Workflow, set apply_workflow = true and specify an input table name that will be used for intermediary extraction of query hashes.

franklinWhaite commented 7 months ago

can you please document the steps to running the workflow