gh-gtmagents-gtm-agents-plugins-data-enrichment-master/commands/clean-database.md

name, description, usage

name	description	usage
clean-database	Normalize, deduplicate, and validate enriched datasets to maintain accuracy and compliance.	/data-enrichment:clean-database --input enriched.csv --rules rules.yaml

Clean Database Command

Purpose

Run data quality workflows (formatting, deduplication, validation, suppression) before syncing enriched records into downstream systems.

Syntax

/data-enrichment:clean-database \
  --input enriched.csv \
  --rules rules.yaml \
  --output clean.csv \
  --gdpr true

Parameters

• --input: Source CSV/JSON/Parquet file.
• --rules: YAML/JSON config defining normalization rules, required fields, dedupe logic.
• --output: File path or system destination (Salesforce, HubSpot, Snowflake).
• --gdpr: Apply regional compliance filters (default true).
• --suppress-list: Path to opt-out or customer suppression list.
• --format: Output format (csv, json, parquet, api-sync).

Features

• Email/phone format correction, country normalization, timezone calculation.
• Deduping via fuzzy matching and configurable keys.
• Confidence scoring and rejection report for records failing validation.
• Audit log of transformations for compliance.

---