Introducing our Snowflake Data Cloud Native Application: AI-Driven Data Quality built into SQL statements! Learn More

Step-by-Step Data Matching in the Cloud Tutorial

by Interzoid Team


Posted on February 25th, 2023


Match Report Type for Data Matching Tutorial

We have published a step-by-step tutorial demonstrating the automated identification of inconsistent company name data in a dataset. It shows our Cloud Data Connect product that connects to various data sources and runs match reports, appends similarity keys, generates SQL, and performs several other functions utilizing Interzoid APIs behind the scenes to identify matches.

The tutorial found here provides a walkthrough of the automated generation of a match report of possible duplicate data for a CSV file that is stored in the Cloud in AWS S3. The product works the same for Cloud databases such as Snowflake, AWS RDS, Google Cloud SQL, Microsoft Azure SQL, Postgres, MySQL, and several others. It also works with other data content types such as individual person data and street address data, data that is typically inconsistently represented within databases.

Database Cloud Connect for Matching Data Tutorial
See our Snowflake Native Application. Achieve Data Quality built-in to SQL statements.
Identify inconsistent and duplicate data quickly and easily in data tables and files.
More...
Connect Directly to Cloud SQL Databases and Perform Data Quality Analysis
Achieve better, more consistent, more usable data.
More...
Try our Pay-as-you-Go Option
Start increasing the usability and value of your data - start small and grow with success.
More...
Launch Our Entire Data Quality Matching System on an AWS EC2 Instance
Deploy to the instance type of your choice in any AWS data center globally. Start analyzing data and identifying matches across many databases and file types in minutes.
More...
Free Usage Credits
Register for an Interzoid API account and receive free usage credits. Improve the value and usability of your strategic data assets now.
Automate API Integration into Cloud Databases
Run live data quality exception and enhancement reports on major Cloud Data Platforms direct from your browser.
More...
Check out our APIs and SDKs
Easily integrate better data everywhere.
More...
Example API Usage Code on Github
Sample Code for invoking APIs on Interzoid in multiple programming languages
Business Case: Cloud APIs and Cloud Databases
See the business case for API-driven data enhancement - directly within your important datasets
More...
Documentation and Overview
See our documentation site.
More...
Product Newsletter
Receive Interzoid product and technology updates.
More...