Data Export & Validation

Exports Today

1,847

↑ 12.4% from yesterday

Validation Pass Rate

98.7%

↑ 0.3% improvement

Active Schemas

284

↑ 15 new this week

Failed Validations

↓ 8 from yesterday

⚙️ Export Settings

Data Source

Date Range Start

Date Range End

Record Filter (Optional)

Export Options

Include metadata headers Compress output (gzip) Include soft-deleted records PII data masking enabled

📁 Export Format

JSON

Human-readable, API-ready

CSV

Spreadsheet compatible

XML

Enterprise integration

PARQ

Parquet

Columnar, big data

AVRO

Avro

Schema evolution

SQL

SQL Dump

Database restore

📋 Recent Exports

Export ID	Source	Format	Records	Size	Status	Completed
EXP-2026-00847	Aevum Energy	JSON	2,451,893	847 MB	Completed	2 min ago
EXP-2026-00846	Zenth Health	CSV	892,104	312 MB	Completed	18 min ago
EXP-2026-00845	Aevum Capital	Parquet	5,102,340	1.2 GB	Processing	—
EXP-2026-00844	Zenth Digital	JSON	12,445,678	3.8 GB	Completed	1 hr ago
EXP-2026-00843	Aevum Aerospace	Avro	334,210	89 MB	Failed	3 hrs ago

🔍 Latest Validation Run

Overall Score

98.7%

Rules Checked

✅

Schema Compliance — All Fields Validated

All 284 active schemas passed structural validation. No breaking changes detected in the last 24 hours.

✅

Type Integrity — Data Types Match Schema

99.2% of records have correct data types. 0.8% type coercion warnings logged for numeric-to-string conversions.

⚠️

Completeness — Missing Optional Fields

312 records from Zenth Health missing optional field lab_reference_id. Not critical but recommended for completeness.

❌

Duplicate Detection — 23 Duplicate Records Found

23 duplicate entries detected in Aevum Capital transaction ledger. Duplicate keys on txn_id field. Requires manual review.

✅

Referential Integrity — Foreign Keys Valid

All foreign key references resolved successfully across 14 data sources. Zero orphaned records detected.

📐 Active Validation Rules

Filter by Rule Type

email_address regex REQUIRED /^[^\s@]+@[^\s@]+\.[^\s@]+$/

transaction_amt range REQUIRED 0 ≤ x ≤ 99,999,999.99

created_at date REQUIRED ISO 8601 / UTC

employee_id pattern REQUIRED AZ-[A-Z]{2}-\d{6}

ip_address ip OPTIONAL IPv4 or IPv6

custom_payload json OPTIONAL Valid JSON object

📋 Schema Editor — energy_production.json

Schema Name

Schema Version

Division

Namespace

Schema Fields

plant_id string REQUIRED Unique identifier for the energy plant

timestamp datetime REQUIRED UTC timestamp of measurement

output_mw float REQUIRED Power output in megawatts

efficiency_pct float REQUIRED Plant efficiency percentage (0-100)

fuel_type enum REQUIRED solar | wind | nuclear | fusion | hydro

maintenance_flag boolean OPTIONAL Active maintenance indicator

📝 Validation Event Log

14:32:07 Error Duplicate key txn_id=TXN-884721 detected in Aevum Capital ledger. Record quarantined.

14:31:55 Error Duplicate key txn_id=TXN-884699 detected in Aevum Capital ledger. Record quarantined.

14:31:42 Warn Missing optional field lab_reference_id in 312 records from Zenth Health source. Batch: ZH-2026-0127.

14:31:30 Warn Type coercion: 4,200 string → float conversions in Zenth Digital analytics batch. Expected numeric type.

14:31:18 Pass Referential integrity check passed for all 14 data sources. Zero orphaned records.

14:31:05 Pass Schema compliance validated for 284 active schemas. No breaking changes.

14:30:58 Pass Type integrity check passed. 99.2% data type accuracy across all sources.

14:30:44 Info Validation run VR-2026-0312 initiated. 47 rules queued for 6 data sources.

14:28:12 Info Schema version energy_production_v3 updated from 3.2.0 → 3.2.1 by user admin@zenth.com.

14:15:03 Info Export EXP-2026-00846 completed: Zenth Health → CSV, 892,104 records, 312 MB.

13:52:41 Error Export EXP-2026-00843 failed: Aevum Aerospace Avro serialization error on field orbit_parameters. Invalid JSON payload.

13:40:18 Pass Scheduled validation completed for Aevum Energy production metrics. All 3,200 records valid.

📊 Validation Summary by Source

Aevum Energy 100% pass rate

Zenth Digital 99.2% pass rate

Zenth Health 99.1% — warnings

Aevum Capital 98.4% — errors

Aevum Aerospace 100% pass rate

Aevum Properties 100% pass rate

Export & Validation