0530c1dc81
* Verify the format of the original SQL, not the generated SQL. The generated SQL gets reformatted by `bqetl query render`. * Format all SQL. * Quote column names containing Jinja expressions to prevent `bqetl format` causing invalid SQL. * Adjust indentation of some comments to align with the formatted SQL. * Refactor final `SELECT` in `telemetry_derived.clients_first_seen_v2` to work better with `bqetl format` SQL formatting. * Fix trailing line comments breaking inline block formatting. * Fix leading whitespace before Jinja comments not being preserved. * Add `schema.yaml` for `firefox_ios_derived.baseline_clients_yearly_v1`. So the `deploy-changes-to-stage` CI can work for the downstream `firefox_ios.baseline_clients_yearly` view. * Add `schema.yaml` for `firefox_accounts_derived/fxa_users_services_daily_v1`. So the `dry-run-sql` CI can work for the downstream `firefox_accounts_derived.fxa_users_services_last_seen_v1` ETL. * Correct `schema.yaml` and `init.sql` for `firefox_accounts_derived.fxa_users_last_seen_v1`. So the `dry-run-sql` CI can work for the downstream `firefox_accounts_derived.fxa_users_last_seen_v1` ETL. * Fully qualify table reference in `init.sql` for `firefox_accounts_derived.fxa_users_last_seen_v1`. So the table dependency will get detected by the `deploy-changes-to-stage` CI to deploy it so the `dry-run-sql` CI can work for the `init.sql` file. * Improve `JinjaComment` inheritance and docstring. * Implement `Line.ends_with_line_comment` property and refactor `inline_block_format()`. |
||
|---|---|---|
| .. | ||
| capitalize_builtin_functions | ||
| capitalize_keywords | ||
| case_statements | ||
| jinja_example | ||
| scripting_example | ||
| conftest.py | ||