Generate views

The View generator page helps flatten Address Validation result tables into a view in your own schema.

Use it after running a bulk Address Validation job. The generator scans address result tables in the app's RESULTS schema, discovers available fields, and creates CREATE OR REPLACE VIEW SQL that selects the fields you choose.

When to use it

Address results can contain nested VARIANT columns such as components, metadata, match_info, and result_json. View generator lets you turn those nested paths into columns that are easier to query, join, export, or use in downstream reporting.

Generate a view

1. Open View generator.
2. Choose Select Address Results Table.
3. Enter Target View Name (fully qualified), for example MYDB.MYSCHEMA.ADDRESS_VALIDATION_VIEW.
4. Use Select fields to include to choose the fields you want in the view.
5. Copy and run the SQL from Generated SQL in a worksheet.

Field selection is organized by these tabs:

The Core & Address tab contains Core Fields and Address Fields sections. The Error & Debug tab contains Error Fields and Debug Fields sections.

Example output

The generated SQL follows this pattern:

CREATE OR REPLACE VIEW MYDB.MYSCHEMA.ADDRESS_VALIDATION_VIEW AS
SELECT
  job_id,
  record_id,
  is_valid,
  confidence,
  address_line_1,
  locality,
  region,
  postal_code,
  metadata:dpv:indicator::STRING AS metadata_dpv_indicator
FROM EXPERIAN_DATA_VALIDATION.RESULTS.ADDRESS;

The exact fields depend on your Address Validation configuration and on which optional result data was returned for the selected result table.