maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
Cleaned mirror of `raw_gcs.whse_sites`. Coerces the CSV's `Nullable(String)` columns into typed equivalents. The raw column is `region`; the mart/metric/ontology dimension `site_region` is a coalesced alias of it. Certification state is the three UInt8 flags (cert_gdp / cert_iso27001 / cert_hazmat) — no `certifications` string or `temp_capabilities` column exists.
15 of 15
Column
Description
Tests · PII
site_id
UUID5 from the source CSV. Primary key.
6 tests
site_code
Short human site code, e.g. `DE-HAM-01`. Free-text.
1 test
site_name
Human-readable site name. Free-text.
country
ISO-3166 alpha-2 country code of the site.
1 test
region
Site region. RAW name is `region`; aliased to `site_region` downstream.
2 tests
site_type
Site type.
2 tests
capacity_m2
Gross floor area in m². Coerced from String → Int32.
1 test
automation
Automation level.
2 tests
cert_gdp
1 if GDP (pharma cold-chain) certified, 0 otherwise. Coerced from the CSV's "true"/"false" strings.
2 tests
cert_iso27001
1 if ISO 27001 certified, 0 otherwise. Coerced from the CSV's "true"/"false" strings.
2 tests
cert_hazmat
1 if ADR/hazmat-licensed, 0 otherwise. Coerced from the CSV's "true"/"false" strings.
2 tests
opened_date
Date the site opened. Coerced from String → Date.
source_file_url
Airbyte-supplied `_ab_source_file_url` — the gs:// URI the row came from.
source_file_modified_at
Airbyte-supplied `_ab_source_file_last_modified` — object mtime of the source file.
airbyte_extracted_at
When Airbyte extracted this row from GCS.