Before you start

You need:

• A table containing the US addresses you want to validate (or use the sample data below).
• A Snowflake account in a supported region — AWS: US East (N. Virginia), US East (Ohio), US West (Oregon); Azure: Central US (Iowa), and others listed on the Marketplace.

Get the app from the Snowflake Marketplace

Already installed the AV3 app and started your trial? Skip to Step 2.

If not: open the AV3 listing on the Snowflake Marketplace and select Try Now to start the free 20-day trial.

The trial includes 1,000 address validations with full GetBestMatches output including DPV codes, correction notes, and standardized fields. No credit card required.

Grant the external access integration

After installation, AV3 needs permission to connect to the Service Objects address validation API. This is the only external connection the app requires.

The external access integration connects the AV3 Native Application to the Service Objects Address Validation API. You grant it explicitly, you can see exactly what it accesses in the app manifest, and you can revoke it at any time.

Prepare your address data

You can validate any table containing US addresses. The input should include the following columns — if your table uses different names, create a VIEW that maps your columns to these names.

CONSUMER_ROW_ID is a unique identifier for each record. It is carried through to the output so you can join validated results back to your source table.

Sample data to test with

If you want to test before using your own data, create a sample table:

CREATE OR REPLACE TABLE MY_SCHEMA.TEST_ADDRESSES (
  CONSUMER_ROW_ID INT,
  BUSINESSNAME    VARCHAR,
  ADDRESS         VARCHAR,
  ADDRESS2        VARCHAR,
  CITY            VARCHAR,
  STATE           VARCHAR,
  POSTALCODE      VARCHAR
);

INSERT INTO MY_SCHEMA.TEST_ADDRESSES VALUES
  (1, '',          '123 Main Stret',   '',        'Los Angelos', 'CA', '90012'),
  (2, 'Acme Corp', '456 Oake Ave',     'Suite 200','San Fran',   'CA', '94102'),
  (3, '',          '789 Broadwy',      '',        'New Yrok',    'NY', '10003'),
  (4, '',          '321 Elm Stret',    'Apt 5B',  'Chicgo',      'IL', '60601'),
  (5, '',          '555 Invalid Blvd', '',        'Faketown',    'ZZ', '00000');

Run your first validation

There are three ways to call AV3_VALIDATE. Start with Option B or C using the sample data — once you see the results, run it on your own table.

Option A — Validate an entire table

Bind your table and call AV3_VALIDATE. Results are saved to APP_CODE.AV3_ADDRESS_RESULTS.

CALL APP_CODE.AV3_VALIDATE();

Option B — Validate from a SELECT query

Pass a query directly to validate any subset of records without creating a separate table.

CALL APP_CODE.AV3_VALIDATE(
  'SELECT CONSUMER_ROW_ID, BUSINESSNAME, ADDRESS,
          ADDRESS2, CITY, STATE, POSTALCODE
   FROM MY_SCHEMA.TEST_ADDRESSES'
);

Option C — Validate and save to a custom output table

Pass a query and an output table path. A timestamped table is created in your schema with full validation results.

CALL APP_CODE.AV3_VALIDATE(
  'SELECT CONSUMER_ROW_ID, BUSINESSNAME, ADDRESS,
          ADDRESS2, CITY, STATE, POSTALCODE
   FROM MY_SCHEMA.TEST_ADDRESSES',
  'MY_SCHEMA.AV3_RESULTS'
);

Read the results

Query the output table to see the validated addresses:

SELECT * FROM MY_SCHEMA.AV3_RESULTS;

Or return only the records where AV3 confirmed a valid, deliverable address:

SELECT * FROM MY_SCHEMA.AV3_RESULTS
WHERE DPV = 1;

What the results include

Sample input → output

Use the output in your workflows

With validated results in a Snowflake table, you can:

• Join validated addresses back to your source table by row ID.
• Filter by DPV to separate confirmed addresses from bad or partially correct ones.
• Route records based on DPV Notes: correct and proceed, flag for manual review, or suppress.
• Feed standardized addresses into downstream pipelines, ML models, or CRM syncs.
• Schedule recurring validation by wrapping the CALL in a Snowflake task.

Trial & pricing

The free trial includes 1,000 address validations over 20 days with full GetBestMatches output. At the end of 20 days or 1,000 records (whichever comes first), the trial stops — with no automatic charges.

Need help?

Our team is here to get you from trial to production.