View Generator

The View Generator 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 EDQ.RESULTS, discovers available fields, and creates 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. The 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. Select an address result table from EDQ.RESULTS.
3. Enter the view name you want to create.
4. Select the fields to include.
5. Copy and run the generated SQL in a worksheet.

Field groups include:

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 EDQ.RESULTS.ADDRESS_RESULTS;

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