# BigQuery pre-processing scripts

This directory contains standalone Python scripts that prepare BigQuery tables
consumed by the Go service.

## `monthly_cloud_billing_revrec.py`

Prepares the monthly cloud billing revenue recognition inputs used by
`internal/dataplatform/service/bigquery.go`.

The script reads:

- `gcp-digital-bi.dwh_finance.salesforce_org_monthly_revrec`
- `gcp-digital-bi.dwh_finance.salesforce_order_daily_view`

For production-mode runs it writes:

- `gcp-digital-bi-dev.sandbox_dwh_ywang.monthly_revrec_collections`
- `gcp-digital-bi-dev.sandbox_dwh_ywang.monthly_revrec_orders`
- month-suffixed backup tables in `gcp-digital-bi-dev.sandbox_dwh_ywang`

Runtime dependencies are not vendored in this repository. Run it from an
environment that has BigQuery credentials plus:

- `google-cloud-bigquery`
- `pandas`
- `numpy`