home/Integrations/Snowflake/Get started/Configure validation

Configure validation

After binding the OAuth secret and external access integration, configure each validation product from the app's Streamlit pages.

Your configuration is stored in EDQ.CONFIG.app_config and is used by both single-record validation procedures and bulk validation jobs.

Open the Configure Address Validation page to configure countries, datasets, and response detail.

The app retrieves your licensed countries and datasets from Experian. If it cannot reach the API, it shows a default list of countries as a fallback, but you may not be entitled to use every fallback option.

Setting Description
Default country The country to use when no country override is provided for single-record or bulk validation.
Dataset configuration Dataset selection for countries that support more than one dataset. Countries with a single dataset are configured automatically.
Return components Returns parsed address elements as structured fields.
Return metadata Returns additional address metadata, such as deliverability and quality indicators.
Return extra match info Returns additional detail about how the address matched the selected dataset.

For bulk validation jobs, you can override these settings on a per-row basis using the optional country_column and datasets_column parameters.

Country ISO mappings

Address Validation accepts three-letter ISO country codes directly. It can also resolve configured country names and aliases, such as United States, US, United Kingdom or UK.

View the effective mapping:

SELECT country_name, country_iso, source
FROM EDQ.CONFIG.country_iso_mapping
ORDER BY country_name;

Add or update a customer mapping:

CALL EDQ.CONFIG.UpsertCountryIsoMapping('Republic of Ireland', 'IRL');

Delete a customer mapping:

CALL EDQ.CONFIG.DeleteCountryIsoMapping('Republic of Ireland');

Customer mappings override the app defaults.

Save and test

Select Save configuration after making changes. Then use Test and scale your app to run a single-record validation test before submitting larger bulk jobs.

Open Configure Email Validation to choose whether to return metadata.

Setting Description
Return metadata Returns additional information such as normalized email details, domain classification, and additional validation attributes when available.

Save and test

Select Save configuration after making changes. Then use Test and scale your app to run a single-record validation test before submitting larger bulk jobs.

Open Configure Phone Validation to configure phone output and optional checks.

Setting Description
Default country Used when phone numbers do not include an international dialing code. Leave this set to auto-detect data containing numbers from multiple countries.
Output format E164, PLUS_E164 or NATIONAL.
Return metadata Returns additional phone metadata, such as current and original operator details when available.
Include number porting information Returns porting information where supported.
Enable checking live status for US mobile numbers Adds supplementary live status checks for US mobile numbers.
Enable checking live status for GB landline numbers Adds supplementary live status checks for Great Britain landline numbers.

Save and test

Select Save configuration after making changes. Then use Test and scale your app to run a single-record validation test before submitting larger bulk jobs.