Introduction

The Experian Data Quality app for Snowflake is a Snowflake Native App that validates contact data directly within your Snowflake account. It connects to Experian Data Quality APIs using Snowflake external access and OAuth client credentials, then returns standardized validation results to app-owned tables and SQL procedure responses.

The app supports the following validation services:

• Address Validation - validates and standardizes postal addresses using configured countries and datasets.
• Email Validation - assesses email address quality and deliverability confidence.
• Phone Validation - validates and formats phone numbers, with optional metadata and premium live-status checks.

How it works

1. Install the Snowflake Native App and grant access to the application role.
2. Create the OAuth secret, network rule, and external access integration objects in your Snowflake account.
3. Bind those objects to the app.
4. Configure address, email, and phone validation options in the app's Streamlit pages.
5. Run single-record validation from SQL or submit asynchronous bulk validation jobs.
6. Monitor job progress, usage metrics, and validation results from the app dashboards or SQL procedures.

What the app creates

The app creates these main schemas inside the installed application database:

Bulk output tables are created in EDQ.RESULTS when the app is installed as EDQ. If you installed the app with a different name, replace EDQ in the examples with your application name.

Processing options

Use single-record validation when you want to test a small number of records or call validation inline from SQL. Use bulk validation when you want the app to process a table asynchronously in batches and write results to EDQ.RESULTS.

Bulk jobs are queued and processed by a managed background task. Jobs are split into 10,000-record chunks. The Job dashboard provides visibility into processing progress, failed chunks, and the names of the output tables created.