Pre-flight check
Dry run against last successful job — no data is promoted.
| Sources reachable | SCB BE0101N1 · 200 OK · 820 ms |
| Field mapping resolves | 5 of 5 dimensions mapped to Schema Catalog v3 |
| Transform chain runs | 11,486 rows in / 11,486 rows out · 6 s |
| Validation | 4 rows would quarantine, 11,482 would pass |
- Name
- SE · Total population
- Country
- SE
- Indicator
- Total population →
population
- Kind
- external_source
- Description
- Total resident population per municipality, sourced from SCB BE0101N1. R1 totals only — sex/age breakdowns ship in R2.
Sources & field mapping
Edit
Data Source
| Source | Year-range predicate | Query filter |
|---|
| SCB BE0101N1 pxweb_api |
1990 – present |
{"Region":"agg:Kommun","Kon":"1+2","Alder":"tot"} |
Field mapping (5)
| Source | → | Schema dimension |
|---|
| Region | → | muncod_nordregio |
| Tid | → | year |
| Kon | → | sex |
| Alder | → | age_group |
| value | → | population |
Transform chain · 3 steps
Edit
| # | Step | Config |
|---|
| 1 | NormaliseCodes | prefix=SE · pad_length=4 · use_overrides_from=SCB BE0101N1 |
| 2 | HarmoniseRefDate | source=Dec-31 · target=Jan-1 · shift=+1y |
| 3 | ComputeOutput | column=population · expression=value |
Validation rules · 4
Edit
| # | Rule | Severity | Config |
|---|
| 1 | NotNull | error | column=population |
| 2 | NonNegative | error | column=population |
| 3 | YearOnYearSwing | warn → quarantine | max_pct_delta=15 |
| 4 | CompletenessPerCountry | warn | expected=290 · tolerance=0 |
- Frequency
- daily
- Time
- 06:00 Europe/Stockholm · ± 5 min jitter
- Active
- ● enabled
- Retry
- 3 attempts · exponential 1m / 5m / 15m
- Dependencies
- none
- Subscribers
- per.holm · anna.lindqvist · superusers (group)
- Approval
- requires_approval_on_quarantine (R1 default)
Create this pipeline
A new Pipeline at version v1 will be saved.