Skip links
Contact Us
Inferenz

Unify – Data Dedupe App

A Snowflake-Native app for clean and trusted healthcare data de-duplication

×

What Is Unify?

Unify is a data dedupe app that spots and clears duplicate rows inside your own Snowflake account—no exports, no extra servers.
Install it in minutes from Snowflake Marketplace and let your healthcare data work for you.

Get Unify on Snowflake Marketplace

The Unify Dashboard 

Unify uses GenAI to build match rules that flag repeated rows across different tables. Smart scoring shows you where copies hide, then scheduled jobs wipe them out on a timetable you pick.

Solution diagram

Problems Solved by Unify

  • Multiple IDs for the same patient break care paths.
  • Dirty customer masters slow onboarding and support.
  • Home-grown scripts miss edge cases and drain staff time.
  • Manual clean-ups happen once a quarter—far too late.
  • Regulations demand proof that data quality work took place.

What Unify does

1. Table Management
  • Pick the source database, schema, and table..
  • Pick a destination schema and table or rewrite in place.
  • Tell Unify which columns to compare and set the primary key
2. GenAI rule builder

Unify learns patterns from your data, writes match rules, and lists them for review. Edit a rule, approve all, or let the app run as is.

3. Dedupe & Review

See each duplicate cluster, keep the latest or oldest row, and edit if needed. One click starts the clean-up.

4. Automation Scheduler

Set jobs to run daily, weekly, monthly, or by cron. Align the timing with your ingested pipeline so tables stay clean without scripts.

5. Rich metrics
  • Daily records scanned
  • Daily duplicates detected
  • Daily duplicates removed
  • 30-day line chart of progress

Table Management

Automation scheduler

Key Features

  • GenAI rule builder
  • Data-health dashboard
  • Hands-free schedules
  • Table-level drill-downs
  • Self-service setup
  • Snowflake RBAC
GenAI rule builder

Creates fuzzy-match rules in seconds so teams do not guess which fields matter

Data-health dashboard

Tables scanned, copies found, rows kept: all in one pane.

Hands-free schedules

Daily, weekly, and monthly jobs keep data tidy with no clicks.

Table-level drill-downs

Funnel and line charts track duplicate trends by day or month.

Self-service setup

Pick a database, schema, and table, tweak columns, press run.

Snowflake RBAC

The app obeys your roles and never moves data off-platform.

How It Works

Login to the Snowflake Marketplace
Install the app from Snowflake Marketplace.
Grant select rights on the tables you need.
Configure rules and run the first scan.
Review clusters and approve clean-up.
Schedule automatic runs to keep data spotless.

Who Can Use It

Trust reports and AI models built on one true record.

Skip hand-written SQL; Unify writes and runs the logic.

Cut claim denials tied to split or mismatched IDs.

See an accurate Patient 360 for safer decisions.

Ship cleaner data sets to downstream clients.

Security & Compliance

  • Runs fully inside each customer’s Snowflake account—no data leaves your cloud.
  • Honors Snowflake role-based access; grant only the tables the app should touch.
  • Follows Snowflake Native Apps Framework security review requirements.

Sample Use Cases

  • A hospital network removed 45,000 duplicate EHR rows; matches rose by 99%.
  • A national payer cut claim re-work time by 60% with nightly jobs.
  • A digital health startup kept its CRM tidy during a 10X member surge.

Install Unify now and see duplicate counts drop today…

Talk To our Expert
Check out the user guide for more details.
Need further help? Email hello@inferenz.ai—real humans will reply.