Identify inconsistent, matching, and duplicate data across your Snowflake tables in just a few clicks.
A guided, read-only analysis tool that turns better data quality into better Snowflake ROI.
The Snowflake Matching Wizard connects directly to your Snowflake data tables in read-only analysis mode, using Snowflake's own key-pair authentication, so it works on accounts where MFA is enforced and passwords are no longer accepted. In a guided, step-by-step flow, you'll generate AI-enhanced match reports that surface inconsistent values, redundant records, and duplicate entries across any number of Snowflake data assets, see the cost before you run, and review the results in an interactive spreadsheet view. Parallel processing delivers maximum performance, even on large tables.
A quick look at the Matching Wizard experience, from connecting to Snowflake through reviewing your match report.
Select the type of matching you want to perform: company names, individuals, addresses, and more.
Generate a key pair in your browser, run one statement in Snowflake, and connect in read-only mode. No passwords, no MFA prompts.
Pick a table and the wizard pre-selects the matching columns, previews the data, and counts the rows so you know the cost before you run.
Run the job and explore the match report in a searchable, sortable spreadsheet view with each match group highlighted, then save it as a file.
A guided wizard walks you through connecting to Snowflake, choosing your data, and generating a match report. No SQL or scripting required.
The wizard operates entirely in read-only analysis mode. Your Snowflake data is never modified, making it safe to run against any of your tables.
Sign in the way Snowflake recommends for applications: key-pair authentication, with no password and nothing for MFA to block. The wizard generates the key pair in your browser and hands you the single statement to run in Snowflake. Programmatic access tokens are supported too.
Choose a table and the wizard counts its rows, shows the credit estimate against your balance, and previews the data with your match columns highlighted. No surprises on large tables.
Advanced AI-enhanced similarity algorithms cluster matching records and reveal duplicates and inconsistencies that exact-match queries miss entirely.
Cleaner data means more reliable analytics, better customer insights, and fewer wasted compute cycles processing redundant records.
A multi-threaded, distributed cloud architecture processes large Snowflake tables in parallel, delivering match reports fast, even at high data volumes.
Review results in an interactive spreadsheet view that shades each match group, with search, sorting, and paging across even the largest reports. Then save the report as a file, ready to drive deduplication and consolidation decisions.
From connection to match report in three simple steps.
Generate a key pair in the wizard, run the one-line statement it gives you in Snowflake, and connect. A dedicated read-only service user or a Snowflake Reader Account is recommended.
Choose a table; the wizard pre-selects the columns to match on, previews the data, and shows the row count and credit estimate before you commit.
Run the matching job and explore the AI-enhanced report in an interactive spreadsheet view, with each cluster of matching, duplicate, and inconsistent records highlighted.
See the Matching Wizard in action, generating similarity keys to match company and organization name data directly from within Snowflake tables.
Everything you need to get started, from a sample report to a step-by-step video walkthrough.
See an example match report for company name data, showing how matching clusters are presented.
View Sample ReportRead the complete documentation covering setup, connection, and matching options.
Read the DocsWatch a step-by-step YouTube walkthrough of the Snowflake Matching Wizard from start to finish.
Watch on YouTubeThe wizard connects with Snowflake's own key-pair authentication, so it reads from any account on any cloud, in any region, on any edition, including accounts where MFA is enforced.
No connector to install, no integration to deploy, and nothing running inside your Snowflake account. Point the wizard at a warehouse, database, schema, and table, and it reads only the columns you select.
Four data types, plus combinations that raise precision when one field alone is too broad
Resolve Acme Corp, ACME Corporation, and Acme Inc. to a single organization, across the legal suffixes, punctuation, abbreviations, and spelling variations that make company names so inconsistent.
Match James Johnston, Jim Johnston, and J. Johnston as the same person, handling nicknames, initials, middle names, and name ordering.
Reconcile 400 E Broadway St with 400 East Broadway Street, resolving directional abbreviations, street type variations, unit designations, and spacing.
Generate similarity keys for other text values, so product names, descriptions, and free-form fields cluster the same way that names and addresses do.
Require two fields to agree at once: organization with address, organization with individual name, or address with individual name. This separates the Dallas branch from the Phoenix branch while still recognizing that both spell the parent company four different ways.
Every value receives a key representing the entity behind the text rather than the characters themselves. Records sharing a key are grouped into clusters, which makes each match auditable instead of something to take on faith.
All of them. Snowflake accounts hosted on AWS, Azure, or Google Cloud are supported in any region, across every Snowflake edition, using any warehouse size. Tables, views, and shared databases can all be matched, and Reader Accounts are supported for sharing only the data you choose.
No. Processing issues SELECT statements against the table and columns you choose and nothing else. Nothing is written, updated, or deleted, and no schema objects are created. Results are returned to your browser, and you decide what to do with them.
No. Interzoid connects directly to your Snowflake account and reads the columns you select. There is no CSV export, no staging area, and no copy of your data to secure, track, or delete afterward.
Yes. The wizard uses Snowflake key-pair authentication, which is Snowflake's recommended method for
applications and service users and is unaffected by the MFA requirement. The wizard generates the RSA
key pair in your browser and shows the one ALTER USER statement to run in Snowflake to
register the public key. Programmatic access tokens are also supported.
With key-pair authentication there is no password at all. The private key is created in your browser, is sent to Interzoid over HTTPS only when a request is made, and is never stored by Interzoid. Because processing is read-only, the recommended practice is a dedicated read-only service user or a Snowflake Reader Account, either of which can be revoked at any time.
Yes. When you choose a table, the wizard counts its rows and shows the number of records and the estimated credits alongside your current balance, before you click Run.
Each record processed consumes one Interzoid API credit. Trial credits are included with a new API account, so a first table can be matched at no cost, and high volume tables are supported for production workloads.
Yes. The same processing is available as a REST API that can be called from scripts, applications, and data pipelines, which allows Snowflake matching jobs to be automated without using the browser wizard.
Generate your first match report in minutes. No installation, no code, no changes to your data.
Questions? Contact our team at support@interzoid.com