Data Quality user documentation
home/Integrations/Snowflake/Overview/Introduction

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. Open Getting started to create the OAuth secret, network rule, and external access integration objects in your Snowflake account.
  3. Bind those objects to the app.
  4. Configure validation options in Address Validation configuration, Email Validation configuration, and Phone Validation configuration.
  5. Use Country mappings if your address source data contains country names, abbreviations, or aliases that should resolve to ISO3 country codes.
  6. Use Test, then scale to test single records, submit asynchronous bulk validation jobs, and create reusable views.
  7. Monitor job progress in Job dashboard, operational capacity in Monitoring, and usage metrics in Usage dashboard.

What the app creates

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

Schema Purpose
CONTACT Validation procedures for address, email, phone, country lookup, and bulk job submission.
JOBS Procedures for monitoring capacity, listing, inspecting, cancelling, and retrying bulk validation jobs.
CONFIG App configuration, usage statistics, job state, and country mapping tables.
APP Streamlit app entry point.
RESULTS Bulk output tables created when validation jobs are submitted.

Most examples use EXPERIAN_DATA_VALIDATION as the installed application name. If you installed the app with a different name, replace EXPERIAN_DATA_VALIDATION in the examples with your application name.

Processing options

Use Test single records in Test, then scale when you want to verify configuration or inspect the JSON returned by the CONTACT.Address, CONTACT.Email, and CONTACT.Phone procedures.

Use Run bulk validation in Test, then scale when you want the app to process a source table asynchronously in 10,000-record chunks and write results to the app's RESULTS schema.

Bulk jobs are queued and processed by a serverless background task. The Job dashboard page provides visibility into processing progress, failed chunks, and the names of the output tables created. The Monitoring page shows service slot usage, queue depth, and waiting chunks by validation type.

Snowflake

Overview

Related services