Reduce noise in PR diffs

[scholtzan]

Reduce noise in PR diffs

[BenWu]

Another cause for noise is non-deterministic sql generation and schema updates which sometimes causes the order of things in a query or schema to change compared to the generated-sql branch. This causes the stage deploy to deploy and dry run queries that are unrelated to the changes.

The diff here is one example: #5790 (comment)

The common ones I've seen are contextual_services/event_aggregates/schema.yaml and the generated event_monitoring_live_v1 materialized views. event_monitoring_live_v1 should be improved with #5799 but it still creates some superfluous diffs because it uses the current date in the template.

bigquery-etl/sql_generators/glean_usage/templates/event_monitoring_live_v1.materialized_view.sql

Line 84 in fe03b84

DATE(submission_timestamp) >= "{{ current_date }}"

[BenWu]

#5592 may have also reduced some noise by ordering the sql generators