- Products
- Solutions
- Developers
- Support
- About
- Login
- Blog
Native app on the Snowflake Marketplace
Validate US addresses from Snowflake.
USPS CASS-certified address validation as a native app in your Snowflake account. No batch files, no CSV exports, no re-import. One SQL call from data in to validated data out.
USPS CASS certified
25 years in production
Sub-100ms latency
99.999% uptime
SOC 2 Type II
Zero data retention
worksheet.sql
SQL
-- Validate your member file where it lives CALL APP_CODE.AV3_GET_BEST_MATCHES( 'SELECT CONSUMER_ROW_ID, BUSINESSNAME, ADDRESS, '' '' AS ADDRESS2, CITY, STATE, POSTALCODE FROM MY_SCHEMA.MEMBERS', 'MY_SCHEMA.AV3_RESULTS' ); -- → validated rows land back in your table ADDRESS DPV IsResidential 200 N Main St 1 False 520 W Taylor St 1 True
Standardized, corrected addresses with DPV & RDI — no files to move.
Trusted by data teams at brands that can't afford bad records
The problem
Bad addresses break everything downstream.
Misspelled streets, wrong ZIP codes, missing apartment numbers, and outdated records silently break downstream workflows: undeliverable mail wastes postage, shipping errors cost returns, analytics built on dirty data produce unreliable results, and compliance reporting fails when location records cannot be verified.
The traditional fix makes it worse. Export the data, send it to an external service, wait for results, re-import the corrected file, reconcile the differences. Every step adds delay, adds a copy of your data to manage, and takes people and resources to run.
- Undeliverable mailWasted postage and lost touchpoints.
- Shipping errors & returnsReships and refunds eat the margin.
- Unreliable analyticsDirty data in means dirty insight out.
- Failed compliance reportingRecords that can't be verified fail audits.
How it works
One SQL call. Validated data back in your table.
1
Install the native app
Get the app from the Snowflake Marketplace and grant the external access integration. The app runs inside your Snowflake account. You control the access and can revoke it at any time.
2
Select the addresses to validate
Pass a SELECT query with the addresses you want to validate and specify where you want the results saved. AV3 processes the records directly from your Snowflake data.
3
Use the validated output
AV3 creates a timestamped results table in your schema, based on the table name you supply in the call, with the full validation output. Your corrected and standardized address data is ready for the next step in your workflow — no batch files, CSV exports, or re-imports.
worksheet.sqlSQL
-- Validate a SELECT of your address records -- and save the results to an output table CALL APP_CODE.AV3_GET_BEST_MATCHES( 'SELECT CONSUMER_ROW_ID, BUSINESSNAME, ADDRESS, '' '' AS ADDRESS2, CITY, STATE, POSTALCODE FROM MY_SCHEMA.MY_TABLE', 'MY_SCHEMA.AV3_RESULTS' );
Install, call, use — versus contact sales, get a script, wait.
What the output includes
DPV decisioning, not just pass or fail.
Most address validation services return a binary result: valid or invalid. That is not enough for a data engineer building a pipeline. You need to know what changed, why it changed, and what to do with records that fall in between. AV3 returns the full picture:
- Standardized Components — street, city, state, ZIP+4, formatted to the CASS standard.
- DPV Description — whether the address is a confirmed delivery point, and if not, what the postal data says about it.
- DPV Notes Description — what was found or missing at the delivery point, so a fixable address gets corrected and kept rather than dropped.
- Residential Delivery Indicator (RDI) — flags whether the address is residential or not.
- Corrections Description — what changed and why, so the record is auditable.
Before → afterCASS certified
Input · as captured
26 S Chstnut, Ventura CA
AV3 output · standardized
26 S Chestnut St
Ventura, CA 93001-2800
Ventura, CA 93001-2800
Input · undeliverable
500 Nowhere Rd, Lompoc CA
Built for data engineers who fix address problems
For the engineer who got asked to fix the addresses.
Your marketing team's direct mail has a 15–20% return rate
Validate and standardize addresses before campaign export. Catch missing apartment numbers, incorrect ZIPs, and non-deliverable addresses before they cost money.
Bad addresses in your CRM are breaking downstream reports
Run AV3 on customer tables to standardize, correct, and flag records that cannot be validated. Clean the source so analytics, segmentation, and reporting start from reliable data.
Your compliance team needs verified addresses for a regulatory submission
AV3 is USPS CASS certified, so audit trails, KYC workflows, and regulatory filings get validation that meets a recognized US postal standard.
Your ML pipeline is producing inconsistent results, traced to address fields
Normalized, validated address components eliminate the formatting noise that degrades model accuracy — consistent input for feature engineering, deduplication, and entity resolution.
Security & architecture
You control the connection. We retain nothing.
AV3 runs as a native app inside your Snowflake account. When you call AV3_GET_BEST_MATCHES, the app sends address data to the Service Objects validation API through a single external access integration that you explicitly grant at setup. The API validates the address, returns the result, and retains nothing. Your data stays private and secure because it never sits in a third-party system and nothing is kept on our side.
The external access integration is the only connection. It is fully visible in the app manifest before you install, you grant it yourself, and you can revoke it at any time. There are no batch files in transit, no data sitting in a third-party bucket, and no CSV exports leaving your environment.
USPS CASS certified
SOC 2 Type II
PCI-DSS
Your Snowflake accountAV3_GET_BEST_MATCHES runs on your data, in your warehouse
Single external access integrationYou grant it, you can revoke it — the only connection
Service Objects validation APIValidates & returns the result — stores nothing
Pricing
Transparent pricing. Pay through the Snowflake Marketplace.
Standard
$2,500 / year
100,000 validations
- Full GetBestMatches output with DPV
- Sub-100ms latency, 99.999% uptime
- 20-day trial — 1,000 records, full output
Higher volume
Enterprise
$7,500 / year
500,000 validations
- Full GetBestMatches output with DPV
- Sub-100ms latency, 99.999% uptime
- 20-day trial — 1,000 records, full output
Marketplace Capacity Drawdown (MCD) supported.
Use your existing committed Snowflake spend to purchase. No separate procurement process, no additional contract. If your team has committed Snowflake credits, this purchase can draw from that balance.
Unlike most address validation vendors, pricing is visible before you talk to anyone. No "request a quote," no sales call required to learn what it costs.
Why Service Objects
Enterprise reliability, proven since 2001.
The validation infrastructure behind AV3 has run in production for over two decades — trusted by Fortune 500 data teams and backed by billions of validated transactions.
25 Years
In production, since 2001
8 Billion+
Validations delivered
99.999%
Uptime SLA, financially backed
SOC 2 Type II
Independently audited security
Fortune 500
Clients rely on our data
Questions, answered
Frequently asked questions
What does AV3 validate?
US mailing addresses, checked against authoritative USPS data. It validates, corrects, and standardizes addresses using the
GetBestMatches operation. If you need email validation, phone validation, or international addresses, reach out to Service Objects — we have APIs for those.Does my data leave Snowflake?
Address data is sent to the Service Objects validation API through a single external access integration that you grant at setup. The API validates the address and returns the result. No data is stored, logged, or retained by Service Objects. There are no batch files, no CSV exports, and no data sitting in a third-party system.
Is the app CASS certified?
Yes. AV3 is USPS CASS certified, validated against official postal data that is updated monthly. Service Objects is also SOC 2 Type II and PCI-DSS certified.
What does the trial include?
A free 20-day trial with 1,000 address validations. The trial provides the full
GetBestMatches output including DPV codes, correction notes, and standardized fields. At the end of 20 days or 1,000 records (whichever comes first), the trial stops. No automatic charges or conversions.What is the difference between Standard and Enterprise?
Volume only. Standard includes 100,000 validations per year for $2,500. Enterprise includes 500,000 validations per year for $7,500. Both tiers provide the same full
GetBestMatches output, the same sub-100ms latency, and the same 99.999% uptime SLA.Can I pay using my existing Snowflake commitment?
Yes. AV3 supports Marketplace Capacity Drawdown (MCD). If your organization has committed Snowflake spend, this purchase can draw from that balance with no separate procurement process or contract.
How fast is it?
Sub-100ms P99 latency with a 99.999% uptime SLA. The app is built for high-volume pipeline workloads.
How is this different from exporting a CSV and using an external validation service?
No export, no file transfer, no re-import, and far fewer resources to run. You call it from SQL and results land in a Snowflake table. The traditional batch-file workflow is eliminated entirely.
What regions are supported?
The app is available in several AWS and Azure regions, and we can add more on request. Check the Marketplace listing for the current list.
Try it on your own data. Free for 20 days.
1,000 address validations with complete DPV output. Install from the Snowflake Marketplace and start validating right away. No credit card needed.
USPS CASS certified
Sub-100ms latency
Zero data retention