data engineering apis

The Cloud Data Connect Matching Wizard is built on top of our APIs, which in turn is built upon our SmartMatchAI matching technology. This state-of-the-art matching technology utilizes Generative AI, Machine Learning, specialized algorithms, and extensive knowledge bases to identify and discover inconsistent, matching, and otherwise redundant data either within or across datasets.

You can point it to popular databases such as PostgreSQL, MySQL, AWS RDS/Aurora, Google Cloud SQL, Azure SQL, Snowflake, Databricks, and many more. With text files or Excel files, you can access them over the Cloud (stored in AWS S3 for example), or they can be accessed from your local machine.

Here are the easy steps you can take using the Interzoid Cloud Data Connect Wizard to access, match, and otherwise discover data quality issues practically anywhere. Stop spending weeks and months trying to do it manually or with outdated, expensive, and unwieldy tools.

Step 1 - Provide your API key.

Your API key is essentially a license key. It is how we track usage. Log in to your Interzoid account to get your unique key, or register for free to get one.

Provide your API key to track your usage

Step 2 - Choose your data source, either a database or file type.

Select the data source type of the data that you want to analyze.

Choose your data source to improve its data quality

Step 3 (Database) - Set up Cloud database connection information.

If you are connecting to a database in the Cloud to analyze a SQL table, provide your database connection information here. You also have the option of providing a connection string.

Connect to a Cloud SQL database and identify inconsistent, matching data

Step 3 (File) - Browse for your file to process.

If instead of a database, your data is in a text file (CSV, TSV), Parquet file, or Excel file, either locally, or stored somewhere on the Cloud, provide the filename here. You can browse for it if it is on your local machine, otherwise provide the URL of the file's location (such as in AWS S3, for example):

Connect to a CSV file, TSV file, or Excel Workbook and identify inconsistent, matching data

Step 4 - Choose your report type (more options are available for databases than files).

In this example, these are the choices for a CSV text file. A Match Report analyzes all the data in the file. The Wizard then provides a report clustering all organization names or individual names that are similar as determined by having the same generated similarity key:

Choose your match report type

Step 5 - Verify settings and run:

Confirm your matching settings

Step 6 - View the results:

There are multiple ways to view the results. Here, match clusters from the analyzed CSV file are shown in a downloadable text file, along with the similarity keys used to algorithmically cluster them. These keys are generated using our SmartMatchAI technology as described above. These results can also be provided in JSON for programmatic purposes, as well as HTML.

Using Generative AI your match report is provided showing the data quality issues

It's really that simple! Ready to try?

All content (c) 2018-2023 Interzoid Incorporated. Questions? Contact

201 Spear Street, Suite 1100, San Francisco, CA 94105-6164

Interested in Data Cleansing Services?

Start Here
Terms of Service
Privacy Policy

Use the Interzoid Cloud Connect Data Platform and Start to Supercharge your Cloud Data Now:
API Integration Code Examples and SDKs:
Documentation and Overview: Docs site
Interzoid Product and Technology Newsletter: Subscribe
Partnership Interest? Inquire