Skip to main content

Product summary

The following table summarizes Validata features and capabilities.

Feature

Notes

Version

1.1.5

Deployment

Supported data systems

  • Databases: MySQL, Oracle, PostgreSQL, SQL Server.

  • Data warehouses: BigQuery, Databricks, Snowflake.

Supported data types

  • Standard scalar types (numeric, string, temporal, boolean).

  • Data types such as binary are not supported. See Supported data systems for details.

Validation methods

  • Built-in methods include:

    • Full-dataset validation: Vector Validation, Fast Record Validation, Full Record Validation

    • Partial-dataset validation: Key Validation, Interval Validation

  • Additional methods include Custom Validation.

Validation pair comparison outcomes

  • Data comparison outcomes:

    • In-Sync

    • Out-of-Sync (Content Mismatch, Extra in Source, Extra in Target)

    • Halted

  • Other outcomes:

    • Canceled

    • Skipped

Validation schedule

  • One-time (manually triggered)

  • Recurring schedule (hourly, daily, weekly).

Reconciliation

  • SQL-based reconciliation scripts generated for a validation pair if the comparison outcome is Out-of-Sync or Halted.

  • You can download the reconciliation script from the Validation Pair Report.

Report store

  • You can view comparison reports in the Validata UI or download the JSON reports.

  • Validation reports are persisted in the Validata Historian, a fully managed data store hosted by the Validata service. The historian is automatically provisioned, installed, and configured during Validata service deployment.

Observability

  • Receive alerts via email, Slack, or Microsoft Teams when a validation starts, completes, or fails to complete, and at other major events.

  • Monitor the CPU and memory resources consumed by the Validata server.