GCP Enterprise Posture
Status: DOCUMENTATION ONLY — No Active Implementation ChangesPurpose: Document current and future GCP utilization.
1. BigQuery Utilization
Load Jobs (GCS → BQ)
- Hybrid GCS → BQ load for big data ingestion.
- Schema-on-bridge: STRING ingestion with typed casts applied later.
Partitioning (As-Built)
- stage1_bridge_rows:
PARTITION BY DATE(created_at) - ingestion_batches:
PARTITION BY DATE(uploaded_at) - ingestion_batch_businesses:
PARTITION BY period_label
Clustering
- tenant_id first (mandatory)
- batch_id for batch-scoped queries
- row_index for deterministic ordering
2. Cloud Logging
- System-of-record for forensic replay.
- No PHI in logs.
- Trace correlation via request_id, trace_id.
3. Future Posture (Not Implemented)
| Component | Status |
|---|---|
| Dataplex | Future governance; policy tags |
| BQML | Future anomaly detection |
| Log Analytics | Future forensic search |
| Composer | Optional future orchestration |
4. Tenant Isolation
- All queries MUST filter by tenant_id first.
- org_id scoping for ORG_SCOPED entities.
- No cross-tenant joins.