How would you work with Cloud SQL, Cloud Spanner, or Cloud Bigtable?
For this hands-on SQL task, use the provided service and metric records to produce a current view of active services across these platforms. Include services without a metric and ignore metrics that do not belong to a listed service.
service_name, platform, region, latest_latency_ms, latest_error_rate, and health_statushealth_status to NO_DATA when no metric exists, ATTENTION when latency is null or error rate exceeds 0.05, otherwise HEALTHYplatform, then service_name| Column | Type | Description |
|---|---|---|
| service_idPK | INT | Unique service identifier |
| service_name | VARCHAR(100) | Name of the configured service |
| platform | VARCHAR(30) | Cloud database platform |
| region | VARCHAR(50) | Deployment region |
| is_active | BOOLEAN | Whether the service is currently active |
| Column | Type | Description |
|---|---|---|
| metric_idPK | INT | Unique metric record identifier |
| service_id | INT | Referenced cloud service |
| measured_at | TIMESTAMP | Time when the metric was captured |
| latency_ms | DECIMAL(10,2) | Observed latency in milliseconds |
| error_rate | DECIMAL(5,4) | Observed request error rate |