Vexdata.io Documentation
  • Vexdata Overview
  • Installation
    • System Requirements
    • Windows Installation
    • Linux Installation
    • Cloud Installation
      • GCP
      • Azure
      • AWS Cloud Deployment Architecture Diagram
        • Pre-requisites
        • Manual Install on ec2
        • Cloud Formation Scripts (command line)
    • Admin Post Installation Setup
    • User Post Installation Setup
    • Server Improvement (Optional)
  • Getting Started
    • Roles and Permissions
    • Managing Groups and Projects
      • Folders
      • Projects
    • Settings
      • Slack Integration
      • Integrations
      • Rules
      • Properties
      • Integrations
      • Email Template
      • Report Template
      • Create Data Connections
        • Databases/Warehouses
        • Run On
  • Creating and Executing Test Cases
    • Test Case
      • Create Test Cases
        • Define Data Source and Target
          • Configure Table/s from Database
          • Input SQL Data
          • Input Files
            • Excel/CSV
            • XML
            • JSON
            • Parquet/AVRO
          • API Input
          • Table Filter
          • Advance - Input
        • Data Compare
          • ETL Testing/Cell By Cell Compare
            • Data Compare Mapping
            • Data Compare Options
          • Schema Compare
          • Counts Compare
        • Schema Monitoring
        • Data Quality
          • SQL Rules
          • Column Level Rules
          • Duplicates
      • Executing Test Cases
      • Defining Test Case Settings
    • Test Runs
    • Variables
    • Note
    • Label
  • Reports
    • User Reports
    • Admin Report or Manager Reports
  • Current Limitations
Powered by GitBook
On this page
  1. Creating and Executing Test Cases
  2. Test Case
  3. Create Test Cases

Data Compare

PreviousAdvance - InputNextETL Testing/Cell By Cell Compare

Last updated 5 months ago

Compare two data sources (Tables/SQL/files/API output)

The Data Compare shape can be used to compare the following four options of two or more data sources/targets:

  • ETL Testing/Cell by Cell Compare : Compares every cell from the configured source with the corresponding cell of the configured target.

  • Table Counts Compare : Compares the counts of source and target tables.

  • Schema Compare : Compares the schema of source and target.

  • Data Profile Compare : Compares the data profile of the source and target.

  • Data Migration Validation : Compares same type of schema.

To create a new compare flow:

  • Drag a Source component from the palette to the canvas and configure it as explained in the Define Data Source and Target section.

  • Drag a _Target _component from the palette to the canvas and configure it as explained in the Define Data Source and Target section.

  • Drag a Data Compare component from the palette to the canvas. Join the connections by clicking on the dark circles next to each component and dragging your pointer to the other component's circle.

\