Central Data Repository City of Sugar Land, Office of Data and Innovation
PRODUCTION
Kevin Tran, Data Engineer (Data Engineer)
View as Administrator Data engineer Utilities steward Police steward
Data catalog / raw / perfdb_metric_value

raw.perfdb_metric_value

Legacy performance metric values. 168 rows.
LayerRaw
Source systemPerformance metrics database (PostgreSQL)
Data ownerData and Innovation Administrator
Data stewardKevin Tran
ClassificationInternal
RefreshNightly
RetentionAll versions, 7 years
AccessRoles R1 to R5, row policy P-01

Lineage

SourcePerformance metrics database (PostgreSQL)

Columns

ColumnTypeClassification
metric_codetext
period_monthdate
valuedouble precision
computed_attimestamp without time zone
modified_attimestamp without time zone
_run_idtext Load metadata
_extracted_attimestamp without time zone Load metadata

Quality rules

DQ-801 Block One value per metric and month
Uniqueness

Sample rows

metric_codeperiod_monthvaluecomputed_atmodified_at_run_id_extracted_at
CS-012025-11-0183.72026-11-01 00:00:002026-11-01 00:00:00L-20261101-01002026-11-01 01:08:31
CS-012025-12-0182.82026-11-01 00:00:002026-11-01 00:00:00L-20261101-01002026-11-01 01:08:31
CS-012026-01-0183.42026-11-01 00:00:002026-11-01 00:00:00L-20261101-01002026-11-01 01:08:31
CS-012026-02-0185.22026-11-01 00:00:002026-11-01 00:00:00L-20261101-01002026-11-01 01:08:31
CS-012025-10-0185.42026-11-01 00:00:002026-11-01 00:00:00L-20261101-01002026-11-01 01:08:31

Data as of run R-20261111-0200, finished 11/11/2026 02:13 Central. Curated layer: curated schema.