{"id":12720,"date":"2026-07-29T22:19:12","date_gmt":"2026-07-30T05:19:12","guid":{"rendered":"https:\/\/www.serviceobjects.com\/docs\/?page_id=12720"},"modified":"2026-07-30T23:54:08","modified_gmt":"2026-07-31T06:54:08","slug":"av3-snowflake-guide","status":"publish","type":"page","link":"https:\/\/www.serviceobjects.com\/docs\/snowflake\/av3-snowflake-guide\/","title":{"rendered":"Address Validation &#8211; Quick-Start guide"},"content":{"rendered":"<style>\n\/* Fonts + enhancements only. All core styling is inline (survives WP sanitizing). *\/<br \/>@font-face{font-family:\"Museo sans\";font-style:normal;font-weight:300;font-display:swap;src:url(\"https:\/\/www.serviceobjects.com\/wp-content\/uploads\/2021\/05\/MuseoSans-300.woff\") format(\"woff\");}<br \/>@font-face{font-family:\"Museo sans\";font-style:normal;font-weight:500;font-display:swap;src:url(\"https:\/\/www.serviceobjects.com\/wp-content\/uploads\/2021\/05\/MuseoSans_500.woff\") format(\"woff\");}<br \/>@font-face{font-family:\"Museo sans\";font-style:normal;font-weight:700;font-display:swap;src:url(\"https:\/\/www.serviceobjects.com\/wp-content\/uploads\/2021\/05\/MuseoSans_700.woff\") format(\"woff\");}<br \/>.av3docs-page code{font-family:\"SFMono-Regular\",Consolas,\"Liberation Mono\",Menlo,monospace;font-size:.92em;background:#eef1f8;color:#1b2a63;padding:2px 6px;border-radius:6px;}<br \/>.av3docs-page pre code{background:none;color:#e7ecff;padding:0;border-radius:0;}<br \/>.av3docs-page a.av3docs-link{color:#004E95;}<br \/>.av3docs-copy:hover{background:rgba(255,255,255,.18) !important;color:#fff !important;}<br \/>.av3docs-faq summary{list-style:none;}<br \/>.av3docs-faq summary::-webkit-details-marker{display:none;}<br \/>.av3docs-faq summary:after{content:\"+\";float:right;font-size:22px;line-height:1;color:#377dff;font-weight:700;}<br \/>.av3docs-faq details[open] summary:after{content:\"\\2212\";}\nmain header h1{display:none}<\/style>\n<div class=\"av3docs-page\" style=\"padding: 34px 20px 76px; font-family: 'Museo sans','museoSans',-apple-system,BlinkMacSystemFont,'Segoe UI',Roboto,Helvetica,Arial,sans-serif; color: #17072b; line-height: 1.65; -webkit-font-smoothing: antialiased;\">\n<p><!-- ===================== TITLE (replaces hero) ===================== --><\/p>\n<p style=\"display: inline-block; font-size: 13px; font-weight: bold; letter-spacing: .12em; text-transform: uppercase; color: #064ea2; margin: 0 0 12px;\">Quick-Start Guide<\/p>\n<h1 style=\"font-size: clamp(28px,4.4vw,42px); font-weight: 800; line-height: 1.15; letter-spacing: -.02em; color: #17072b; margin: 0 0 14px;\">Address Validation 3 (AV3) for Snowflake: Quick-Start Guide<\/h1>\n<p style=\"font-size: clamp(16px,1.6vw,19px); color: #5c6077; margin: 0 0 20px; max-width: 720px;\">From install to your first validated address in under 10 minutes \u2014 validate, correct, and standardize US addresses directly in SQL, inside your Snowflake account.<\/p>\n<div style=\"display: flex; flex-wrap: wrap; gap: 8px 18px; font-size: 13.5px; color: #5c6077; margin: 0 0 22px;\"><span style=\"display: inline-flex; align-items: center; gap: 7px;\">\ud83d\udd51 Time to first validated address: &lt; 10 minutes<\/span><br \/>\n<span style=\"display: inline-flex; align-items: center; gap: 7px;\">\ud83d\udcdd 6 steps \u00b7 SQL only<\/span><br \/>\n<span style=\"display: inline-flex; align-items: center; gap: 7px;\">\u2705 No credit card required<\/span><\/div>\n<p><!-- Replace MARKETPLACE_URL with the live listing URL + UTM string --><br \/>\n<a style=\"display: inline-flex; align-items: center; gap: 10px; background: #377dff; color: #fff; font-weight: bold; font-size: 16px; padding: 14px 24px; border-radius: 12px; text-decoration: none; box-shadow: 0 10px 24px rgba(55,125,255,.35);\" href=\"https:\/\/app.snowflake.com\/marketplace\/listing\/GZ1MJZ4VGDFVX\/service-objects-inc-service-objects\" target=\"_blank\">Get AV3 on the Snowflake Marketplace \u2192<\/a><\/p>\n<p><!-- ===================== SUMMARY ===================== --><\/p>\n<div style=\"border: 1px solid #E6E6E6; border-radius: 16px; background: #F7FAFD; padding: 22px 24px; margin: 28px 0;\">\n<h3 style=\"font-size: 19px; font-weight: bold; color: #17072b; margin: 0 0 10px;\">What this guide covers<\/h3>\n<p style=\"color: #5c6077; margin: 0 0 12px;\">Address Validation 3 (AV3) is a Snowflake Native App from Service Objects that validates, corrects, and standardizes US addresses to the USPS standard \u2014 without moving your data out of Snowflake. In this quick start you will:<\/p>\n<ul style=\"color: #5c6077; margin: 0; padding-left: 22px;\">\n<li style=\"margin: 6px 0;\">Install AV3 from the Snowflake Marketplace and start a free 20-day trial (1,000 validations, full <code>GetBestMatches<\/code> output).<\/li>\n<li style=\"margin: 6px 0;\">Grant the one external access integration AV3 needs.<\/li>\n<li style=\"margin: 6px 0;\">Run <code>AV3_VALIDATE<\/code> on a table or a <code>SELECT<\/code> query.<\/li>\n<li style=\"margin: 6px 0;\">Read standardized addresses, DPV confirmation, ZIP+4, RDI, and correction notes back in SQL.<\/li>\n<\/ul>\n<\/div>\n<p><!-- ===================== BEFORE YOU START ===================== --><\/p>\n<section id=\"before-you-start\" style=\"margin-top: 34px;\">\n<h2 style=\"font-size: clamp(23px,2.6vw,29px); font-weight: bold; color: #17072b; letter-spacing: -.02em; margin: 0 0 14px;\">Before you start<\/h2>\n<p style=\"margin: 0 0 12px;\">You need:<\/p>\n<ul style=\"margin: 0 0 12px; padding-left: 22px;\">\n<li style=\"margin: 6px 0;\">A table containing the US addresses you want to validate (or use the <a class=\"av3docs-link\" style=\"color: #004e95;\" href=\"#sample-data\">sample data<\/a> below).<\/li>\n<li style=\"margin: 6px 0;\">A Snowflake account in a supported region \u2014 <strong>AWS:<\/strong> US East (N. Virginia), US East (Ohio), US West (Oregon); <strong>Azure:<\/strong> Central US (Iowa), and others listed on the Marketplace.<\/li>\n<\/ul>\n<div style=\"border-left: 4px solid #377dff; background: #f4f8ff; border-radius: 0 10px 10px 0; padding: 14px 18px; margin: 18px 0; font-size: 15px;\"><strong>Time to first validated address:<\/strong> less than 10 minutes.<\/div>\n<\/section>\n<p><!-- ===================== STEP 1 ===================== --><\/p>\n<section id=\"step-1\" style=\"border-top: 1px solid #eef1f6; margin-top: 34px; padding-top: 30px;\"><span style=\"display: inline-flex; align-items: center; justify-content: center; width: 34px; height: 34px; border-radius: 10px; background: linear-gradient(150deg,#377dff,#004E95); color: #fff; font-weight: 800; font-size: 15px; box-shadow: 0 8px 18px rgba(55,125,255,.3);\">1<\/span><\/p>\n<h2 style=\"font-size: clamp(23px,2.6vw,29px); font-weight: bold; color: #17072b; letter-spacing: -.02em; margin: 12px 0 14px;\">Get the app from the Snowflake Marketplace<\/h2>\n<p style=\"margin: 0 0 16px;\">Already installed the AV3 app and started your trial? Skip to Step 2. <\/p>\n<p>If not: open the <a href=\"https:\/\/app.snowflake.com\/marketplace\/listing\/GZ1MJZ4VGDFVX\/service-objects-inc-service-objects\" target=\"_blank\">AV3 listing on the Snowflake Marketplace<\/a> and select <strong>Try Now<\/strong> to start the free 20-day trial. <\/p>\n<p>The trial includes 1,000 address validations with full GetBestMatches output including DPV codes, correction notes, and standardized fields. No credit card required.<\/p>\n<\/section>\n<p><!-- ===================== STEP 2 ===================== --><\/p>\n<section id=\"step-2\" style=\"border-top: 1px solid #eef1f6; margin-top: 34px; padding-top: 30px;\"><span style=\"display: inline-flex; align-items: center; justify-content: center; width: 34px; height: 34px; border-radius: 10px; background: linear-gradient(150deg,#377dff,#004E95); color: #fff; font-weight: 800; font-size: 15px; box-shadow: 0 8px 18px rgba(55,125,255,.3);\">2<\/span><\/p>\n<h2 style=\"font-size: clamp(23px,2.6vw,29px); font-weight: bold; color: #17072b; letter-spacing: -.02em; margin: 12px 0 14px;\">Grant the external access integration<\/h2>\n<p style=\"margin: 0 0 16px;\">After installation, AV3 needs permission to connect to the Service Objects address validation API. This is the <strong>only<\/strong> external connection the app requires.<\/p>\n<p style=\"margin: 0 0 16px;\">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.<\/p>\n<div style=\"border-left: 4px solid #377dff; background: #f4f8ff; border-radius: 0 10px 10px 0; padding: 14px 18px; margin: 18px 0; font-size: 15px;\"><strong>Privacy:<\/strong> no data is stored, logged, or retained by Service Objects.<\/div>\n<\/section>\n<p><!-- ===================== STEP 3 ===================== --><\/p>\n<section id=\"step-3\" style=\"border-top: 1px solid #eef1f6; margin-top: 34px; padding-top: 30px;\"><span style=\"display: inline-flex; align-items: center; justify-content: center; width: 34px; height: 34px; border-radius: 10px; background: linear-gradient(150deg,#377dff,#004E95); color: #fff; font-weight: 800; font-size: 15px; box-shadow: 0 8px 18px rgba(55,125,255,.3);\">3<\/span><\/p>\n<h2 style=\"font-size: clamp(23px,2.6vw,29px); font-weight: bold; color: #17072b; letter-spacing: -.02em; margin: 12px 0 14px;\">Prepare your address data<\/h2>\n<p style=\"margin: 0 0 16px;\">You can validate any table containing US addresses. The input should include the following columns \u2014 if your table uses different names, create a <code>VIEW<\/code> that maps your columns to these names.<\/p>\n<div style=\"overflow-x: auto; border: 1px solid #E6E6E6; border-radius: 10px; margin: 16px 0 20px;\">\n<table style=\"width: 100%; border-collapse: collapse; font-size: 14.5px; min-width: 520px;\" cellspacing=\"0\" cellpadding=\"0\">\n<thead>\n<tr>\n<th style=\"text-align: left; padding: 12px 16px; background: #F7FAFD; color: #17072b; font-weight: bold; font-size: 13px; border-bottom: 1px solid #eef1f6;\">Column<\/th>\n<th style=\"text-align: left; padding: 12px 16px; background: #F7FAFD; color: #17072b; font-weight: bold; font-size: 13px; border-bottom: 1px solid #eef1f6;\">Required?<\/th>\n<th style=\"text-align: left; padding: 12px 16px; background: #F7FAFD; color: #17072b; font-weight: bold; font-size: 13px; border-bottom: 1px solid #eef1f6;\">Example<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\"><code>CONSUMER_ROW_ID<\/code><\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\"><span style=\"display: inline-block; font-size: 11px; font-weight: bold; padding: 2px 9px; border-radius: 999px; text-transform: uppercase; background: #e7f6ee; color: #087443;\">Recommended<\/span><\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">1<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\"><code>BUSINESSNAME<\/code><\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\"><span style=\"display: inline-block; font-size: 11px; font-weight: bold; padding: 2px 9px; border-radius: 999px; text-transform: uppercase; background: #eef1f8; color: #3538cd;\">Optional<\/span><\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">Acme Corp<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\"><code>ADDRESS<\/code><\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\"><span style=\"display: inline-block; font-size: 11px; font-weight: bold; padding: 2px 9px; border-radius: 999px; text-transform: uppercase; background: #fdecec; color: #b42318;\">Required<\/span><\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">123 Main Stret<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\"><code>ADDRESS2<\/code><\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\"><span style=\"display: inline-block; font-size: 11px; font-weight: bold; padding: 2px 9px; border-radius: 999px; text-transform: uppercase; background: #eef1f8; color: #3538cd;\">Optional<\/span><\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">Suite 400<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\"><code>CITY<\/code><\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\"><span style=\"display: inline-block; font-size: 11px; font-weight: bold; padding: 2px 9px; border-radius: 999px; text-transform: uppercase; background: #fef3e2; color: #b54708;\">Conditional<\/span><\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">Los Angelos<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\"><code>STATE<\/code><\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\"><span style=\"display: inline-block; font-size: 11px; font-weight: bold; padding: 2px 9px; border-radius: 999px; text-transform: uppercase; background: #fef3e2; color: #b54708;\">Conditional<\/span><\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">CA<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 12px 16px; vertical-align: top;\"><code>POSTALCODE<\/code><\/td>\n<td style=\"padding: 12px 16px; vertical-align: top;\"><span style=\"display: inline-block; font-size: 11px; font-weight: bold; padding: 2px 9px; border-radius: 999px; text-transform: uppercase; background: #fef3e2; color: #b54708;\">Conditional<\/span><\/td>\n<td style=\"padding: 12px 16px; vertical-align: top;\">90012<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"margin: 0 0 16px;\"><code>CONSUMER_ROW_ID<\/code> 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.<\/p>\n<div style=\"border-left: 4px solid #377dff; background: #f4f8ff; border-radius: 0 10px 10px 0; padding: 14px 18px; margin: 18px 0; font-size: 15px;\"><strong>Notice the deliberate errors above<\/strong> (\u201cStret\u201d instead of \u201cStreet,\u201d \u201cAngelos\u201d instead of \u201cAngeles\u201d). AV3 corrects these and returns the standardized versions.<\/div>\n<h3 id=\"sample-data\" style=\"font-size: 19px; font-weight: bold; color: #17072b; margin: 24px 0 10px;\">Sample data to test with<\/h3>\n<p style=\"margin: 0 0 16px;\">If you want to test before using your own data, create a sample table:<\/p>\n<div style=\"background: #0e1530; border: 1px solid #243056; border-radius: 10px; margin: 16px 0 22px; overflow: hidden;\">\n<div style=\"display: flex; align-items: center; justify-content: space-between; padding: 9px 14px; border-bottom: 1px solid #243056; background: rgba(255,255,255,.03);\"><span style=\"font-size: 11px; letter-spacing: .14em; text-transform: uppercase; color: #8ea0d6; font-weight: bold;\">SQL<\/span><br \/>\n<button class=\"av3docs-copy\" style=\"background: rgba(255,255,255,.08); border: 1px solid #243056; color: #cdd8ff; font-size: 12px; font-weight: bold; padding: 5px 11px; border-radius: 7px; cursor: pointer;\" type=\"button\">Copy<\/button><\/div>\n<pre style=\"margin: 0; padding: 16px; overflow-x: auto;\"><code style=\"color: #e7ecff; font-family: Consolas,Menlo,monospace; font-size: 13.5px; line-height: 1.7; white-space: pre;\">CREATE OR REPLACE TABLE MY_SCHEMA.TEST_ADDRESSES (\n  CONSUMER_ROW_ID INT,\n  BUSINESSNAME    VARCHAR,\n  ADDRESS         VARCHAR,\n  ADDRESS2        VARCHAR,\n  CITY            VARCHAR,\n  STATE           VARCHAR,\n  POSTALCODE      VARCHAR\n);\n\nINSERT INTO MY_SCHEMA.TEST_ADDRESSES VALUES\n  (1, '',          '123 Main Stret',   '',        'Los Angelos', 'CA', '90012'),\n  (2, 'Acme Corp', '456 Oake Ave',     'Suite 200','San Fran',   'CA', '94102'),\n  (3, '',          '789 Broadwy',      '',        'New Yrok',    'NY', '10003'),\n  (4, '',          '321 Elm Stret',    'Apt 5B',  'Chicgo',      'IL', '60601'),\n  (5, '',          '555 Invalid Blvd', '',        'Faketown',    'ZZ', '00000');<\/code><\/pre>\n<\/div>\n<\/section>\n<p><!-- ===================== STEP 4 ===================== --><\/p>\n<section id=\"step-4\" style=\"border-top: 1px solid #eef1f6; margin-top: 34px; padding-top: 30px;\"><span style=\"display: inline-flex; align-items: center; justify-content: center; width: 34px; height: 34px; border-radius: 10px; background: linear-gradient(150deg,#377dff,#004E95); color: #fff; font-weight: 800; font-size: 15px; box-shadow: 0 8px 18px rgba(55,125,255,.3);\">4<\/span><\/p>\n<h2 style=\"font-size: clamp(23px,2.6vw,29px); font-weight: bold; color: #17072b; letter-spacing: -.02em; margin: 12px 0 14px;\">Run your first validation<\/h2>\n<p style=\"margin: 0 0 16px;\">There are three ways to call <code>AV3_VALIDATE<\/code>. Start with Option B or C using the sample data \u2014 once you see the results, run it on your own table.<\/p>\n<h3 style=\"font-size: 19px; font-weight: bold; color: #17072b; margin: 24px 0 10px;\">Option A \u2014 Validate an entire table<\/h3>\n<p style=\"margin: 0 0 16px;\">Bind your table and call <code>AV3_VALIDATE<\/code>. Results are saved to <code>APP_CODE.AV3_ADDRESS_RESULTS<\/code>.<\/p>\n<div style=\"background: #0e1530; border: 1px solid #243056; border-radius: 10px; margin: 16px 0 22px; overflow: hidden;\">\n<div style=\"display: flex; align-items: center; justify-content: space-between; padding: 9px 14px; border-bottom: 1px solid #243056; background: rgba(255,255,255,.03);\"><span style=\"font-size: 11px; letter-spacing: .14em; text-transform: uppercase; color: #8ea0d6; font-weight: bold;\">SQL<\/span><br \/>\n<button class=\"av3docs-copy\" style=\"background: rgba(255,255,255,.08); border: 1px solid #243056; color: #cdd8ff; font-size: 12px; font-weight: bold; padding: 5px 11px; border-radius: 7px; cursor: pointer;\" type=\"button\">Copy<\/button><\/div>\n<pre style=\"margin: 0; padding: 16px; overflow-x: auto;\"><code style=\"color: #e7ecff; font-family: Consolas,Menlo,monospace; font-size: 13.5px; line-height: 1.7; white-space: pre;\">CALL APP_CODE.AV3_VALIDATE();<\/code><\/pre>\n<\/div>\n<h3 style=\"font-size: 19px; font-weight: bold; color: #17072b; margin: 24px 0 10px;\">Option B \u2014 Validate from a SELECT query<\/h3>\n<p style=\"margin: 0 0 16px;\">Pass a query directly to validate any subset of records without creating a separate table.<\/p>\n<div style=\"background: #0e1530; border: 1px solid #243056; border-radius: 10px; margin: 16px 0 22px; overflow: hidden;\">\n<div style=\"display: flex; align-items: center; justify-content: space-between; padding: 9px 14px; border-bottom: 1px solid #243056; background: rgba(255,255,255,.03);\"><span style=\"font-size: 11px; letter-spacing: .14em; text-transform: uppercase; color: #8ea0d6; font-weight: bold;\">SQL<\/span><br \/>\n<button class=\"av3docs-copy\" style=\"background: rgba(255,255,255,.08); border: 1px solid #243056; color: #cdd8ff; font-size: 12px; font-weight: bold; padding: 5px 11px; border-radius: 7px; cursor: pointer;\" type=\"button\">Copy<\/button><\/div>\n<pre style=\"margin: 0; padding: 16px; overflow-x: auto;\"><code style=\"color: #e7ecff; font-family: Consolas,Menlo,monospace; font-size: 13.5px; line-height: 1.7; white-space: pre;\">CALL APP_CODE.AV3_VALIDATE(\n  'SELECT CONSUMER_ROW_ID, BUSINESSNAME, ADDRESS,\n          ADDRESS2, CITY, STATE, POSTALCODE\n   FROM MY_SCHEMA.TEST_ADDRESSES'\n);<\/code><\/pre>\n<\/div>\n<h3 style=\"font-size: 19px; font-weight: bold; color: #17072b; margin: 24px 0 10px;\">Option C \u2014 Validate and save to a custom output table<\/h3>\n<p style=\"margin: 0 0 16px;\">Pass a query and an output table path. A timestamped table is created in your schema with full validation results.<\/p>\n<div style=\"background: #0e1530; border: 1px solid #243056; border-radius: 10px; margin: 16px 0 22px; overflow: hidden;\">\n<div style=\"display: flex; align-items: center; justify-content: space-between; padding: 9px 14px; border-bottom: 1px solid #243056; background: rgba(255,255,255,.03);\"><span style=\"font-size: 11px; letter-spacing: .14em; text-transform: uppercase; color: #8ea0d6; font-weight: bold;\">SQL<\/span><br \/>\n<button class=\"av3docs-copy\" style=\"background: rgba(255,255,255,.08); border: 1px solid #243056; color: #cdd8ff; font-size: 12px; font-weight: bold; padding: 5px 11px; border-radius: 7px; cursor: pointer;\" type=\"button\">Copy<\/button><\/div>\n<pre style=\"margin: 0; padding: 16px; overflow-x: auto;\"><code style=\"color: #e7ecff; font-family: Consolas,Menlo,monospace; font-size: 13.5px; line-height: 1.7; white-space: pre;\">CALL APP_CODE.AV3_VALIDATE(\n  'SELECT CONSUMER_ROW_ID, BUSINESSNAME, ADDRESS,\n          ADDRESS2, CITY, STATE, POSTALCODE\n   FROM MY_SCHEMA.TEST_ADDRESSES',\n  'MY_SCHEMA.AV3_RESULTS'\n);<\/code><\/pre>\n<\/div>\n<\/section>\n<p><!-- ===================== STEP 5 ===================== --><\/p>\n<section id=\"step-5\" style=\"border-top: 1px solid #eef1f6; margin-top: 34px; padding-top: 30px;\"><span style=\"display: inline-flex; align-items: center; justify-content: center; width: 34px; height: 34px; border-radius: 10px; background: linear-gradient(150deg,#377dff,#004E95); color: #fff; font-weight: 800; font-size: 15px; box-shadow: 0 8px 18px rgba(55,125,255,.3);\">5<\/span><\/p>\n<h2 style=\"font-size: clamp(23px,2.6vw,29px); font-weight: bold; color: #17072b; letter-spacing: -.02em; margin: 12px 0 14px;\">Read the results<\/h2>\n<p style=\"margin: 0 0 16px;\">Query the output table to see the validated addresses:<\/p>\n<div style=\"background: #0e1530; border: 1px solid #243056; border-radius: 10px; margin: 16px 0 22px; overflow: hidden;\">\n<div style=\"display: flex; align-items: center; justify-content: space-between; padding: 9px 14px; border-bottom: 1px solid #243056; background: rgba(255,255,255,.03);\"><span style=\"font-size: 11px; letter-spacing: .14em; text-transform: uppercase; color: #8ea0d6; font-weight: bold;\">SQL<\/span><br \/>\n<button class=\"av3docs-copy\" style=\"background: rgba(255,255,255,.08); border: 1px solid #243056; color: #cdd8ff; font-size: 12px; font-weight: bold; padding: 5px 11px; border-radius: 7px; cursor: pointer;\" type=\"button\">Copy<\/button><\/div>\n<pre style=\"margin: 0; padding: 16px; overflow-x: auto;\"><code style=\"color: #e7ecff; font-family: Consolas,Menlo,monospace; font-size: 13.5px; line-height: 1.7; white-space: pre;\">SELECT * FROM MY_SCHEMA.AV3_RESULTS;<\/code><\/pre>\n<\/div>\n<p style=\"margin: 0 0 16px;\">Or return only the records where AV3 confirmed a valid, deliverable address:<\/p>\n<div style=\"background: #0e1530; border: 1px solid #243056; border-radius: 10px; margin: 16px 0 22px; overflow: hidden;\">\n<div style=\"display: flex; align-items: center; justify-content: space-between; padding: 9px 14px; border-bottom: 1px solid #243056; background: rgba(255,255,255,.03);\"><span style=\"font-size: 11px; letter-spacing: .14em; text-transform: uppercase; color: #8ea0d6; font-weight: bold;\">SQL<\/span><br \/>\n<button class=\"av3docs-copy\" style=\"background: rgba(255,255,255,.08); border: 1px solid #243056; color: #cdd8ff; font-size: 12px; font-weight: bold; padding: 5px 11px; border-radius: 7px; cursor: pointer;\" type=\"button\">Copy<\/button><\/div>\n<pre style=\"margin: 0; padding: 16px; overflow-x: auto;\"><code style=\"color: #e7ecff; font-family: Consolas,Menlo,monospace; font-size: 13.5px; line-height: 1.7; white-space: pre;\">SELECT * FROM MY_SCHEMA.AV3_RESULTS\nWHERE DPV = 1;<\/code><\/pre>\n<\/div>\n<h3 style=\"font-size: 19px; font-weight: bold; color: #17072b; margin: 24px 0 10px;\">What the results include<\/h3>\n<div style=\"overflow-x: auto; border: 1px solid #E6E6E6; border-radius: 10px; margin: 16px 0 24px;\">\n<table style=\"width: 100%; border-collapse: collapse; font-size: 14.5px; min-width: 480px;\" cellspacing=\"0\" cellpadding=\"0\">\n<thead>\n<tr>\n<th style=\"text-align: left; padding: 12px 16px; background: #F7FAFD; color: #17072b; font-weight: bold; font-size: 13px; border-bottom: 1px solid #eef1f6;\">Field<\/th>\n<th style=\"text-align: left; padding: 12px 16px; background: #F7FAFD; color: #17072b; font-weight: bold; font-size: 13px; border-bottom: 1px solid #eef1f6;\">What it tells you<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\"><strong>Standardized address<\/strong><\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">The corrected, formatted address components, standardized to the USPS standard for mailing addresses.<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\"><strong>DPV<\/strong><\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">Whether the address is a confirmed USPS delivery point.<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\"><strong>DPV Notes<\/strong><\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">Codes explaining what was found or corrected at the delivery-point level.<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\"><strong>ZIP+4<\/strong><\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">The full nine-digit ZIP code.<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\"><strong>RDI<\/strong><\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">Residential vs. commercial classification.<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\"><strong>Correction notes<\/strong><\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">What AV3 changed and why.<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 12px 16px; vertical-align: top;\"><strong>Address fragments<\/strong><\/td>\n<td style=\"padding: 12px 16px; vertical-align: top;\">The address broken down into its smallest parts.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<h3 style=\"font-size: 19px; font-weight: bold; color: #17072b; margin: 24px 0 10px;\">Sample input \u2192 output<\/h3>\n<div style=\"overflow-x: auto; border: 1px solid #E6E6E6; border-radius: 10px; margin: 16px 0 24px;\">\n<table style=\"width: 100%; border-collapse: collapse; font-size: 14.5px; min-width: 520px;\" cellspacing=\"0\" cellpadding=\"0\">\n<thead>\n<tr>\n<th style=\"text-align: left; padding: 12px 16px; background: #F7FAFD; color: #17072b; font-weight: bold; font-size: 13px; border-bottom: 1px solid #eef1f6;\">Field<\/th>\n<th style=\"text-align: left; padding: 12px 16px; background: #F7FAFD; color: #17072b; font-weight: bold; font-size: 13px; border-bottom: 1px solid #eef1f6;\">Input<\/th>\n<th style=\"text-align: left; padding: 12px 16px; background: #F7FAFD; color: #17072b; font-weight: bold; font-size: 13px; border-bottom: 1px solid #eef1f6;\">Output<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">Address<\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">26 S Chestnut<\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">26 S Chestnut St<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">Address 2<\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">\u2014<\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">\u2014<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">City<\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">Ventura<\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">Ventura<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">State<\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">CA<\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">CA<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">ZIP Code<\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">93033<\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">93001-2800<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">DPV<\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">\u2014<\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">1<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">DPV Desc<\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">\u2014<\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">Yes, the input record is a valid mailing address<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">Is Residential<\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">\u2014<\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">FALSE<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">Barcode digits<\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">\u2014<\/td>\n<td style=\"padding: 12px 16px; border-bottom: 1px solid #eef1f6; vertical-align: top;\">930012800269<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 12px 16px; vertical-align: top;\">Corrections Desc<\/td>\n<td style=\"padding: 12px 16px; vertical-align: top;\">\u2014<\/td>\n<td style=\"padding: 12px 16px; vertical-align: top;\">Directional or Suffix change, ZIP code change<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div style=\"border-left: 4px solid #377dff; background: #f4f8ff; border-radius: 0 10px 10px 0; padding: 14px 18px; margin: 18px 0; font-size: 15px;\"><strong>Illustrative output only.<\/strong> The complete response includes additional details such as parsed address fragments, carrier route, congressional district code, delivery indicators, and other address intelligence fields.<\/div>\n<\/section>\n<p><!-- ===================== STEP 6 ===================== --><\/p>\n<section id=\"step-6\" style=\"border-top: 1px solid #eef1f6; margin-top: 34px; padding-top: 30px;\"><span style=\"display: inline-flex; align-items: center; justify-content: center; width: 34px; height: 34px; border-radius: 10px; background: linear-gradient(150deg,#377dff,#004E95); color: #fff; font-weight: 800; font-size: 15px; box-shadow: 0 8px 18px rgba(55,125,255,.3);\">6<\/span><\/p>\n<h2 style=\"font-size: clamp(23px,2.6vw,29px); font-weight: bold; color: #17072b; letter-spacing: -.02em; margin: 12px 0 14px;\">Use the output in your workflows<\/h2>\n<p style=\"margin: 0 0 16px;\">With validated results in a Snowflake table, you can:<\/p>\n<ul style=\"margin: 0 0 16px; padding-left: 22px;\">\n<li style=\"margin: 6px 0;\">Join validated addresses back to your source table by row ID.<\/li>\n<li style=\"margin: 6px 0;\">Filter by <code>DPV<\/code> to separate confirmed addresses from bad or partially correct ones.<\/li>\n<li style=\"margin: 6px 0;\">Route records based on DPV Notes: correct and proceed, flag for manual review, or suppress.<\/li>\n<li style=\"margin: 6px 0;\">Feed standardized addresses into downstream pipelines, ML models, or CRM syncs.<\/li>\n<li style=\"margin: 6px 0;\">Schedule recurring validation by wrapping the <code>CALL<\/code> in a Snowflake task.<\/li>\n<\/ul>\n<\/section>\n<p><!-- ===================== PRICING ===================== --><\/p>\n<section id=\"pricing\" style=\"border-top: 1px solid #eef1f6; margin-top: 34px; padding-top: 30px;\">\n<h2 style=\"font-size: clamp(23px,2.6vw,29px); font-weight: bold; color: #17072b; letter-spacing: -.02em; margin: 0 0 14px;\">Trial &amp; pricing<\/h2>\n<p style=\"margin: 0 0 16px;\">The free trial includes <strong>1,000 address validations over 20 days<\/strong> with full <code>GetBestMatches<\/code> output. At the end of 20 days or 1,000 records (whichever comes first), the trial stops \u2014 with no automatic charges.<\/p>\n<div style=\"display: flex; flex-wrap: wrap; gap: 20px; margin: 20px 0 8px;\">\n<div style=\"flex: 1 1 260px; border: 1px solid #E6E6E6; border-radius: 16px; padding: 26px 24px; background: #fff;\">\n<h3 style=\"margin: 0 0 4px; font-size: 15px; letter-spacing: .1em; text-transform: uppercase; color: #7a8199;\">Standard<\/h3>\n<div style=\"font-size: 38px; font-weight: 800; color: #17072b; letter-spacing: -.02em;\">$2,500<span style=\"font-size: 15px; font-weight: 600; color: #5c6077;\"> \/ year<\/span><\/div>\n<ul style=\"margin: 16px 0 0; padding-left: 20px; color: #5c6077;\">\n<li style=\"margin: 6px 0;\">100,000 validations included<\/li>\n<li style=\"margin: 6px 0;\">Full <code>GetBestMatches<\/code> output<\/li>\n<li style=\"margin: 6px 0;\">Marketplace Capacity Drawdown (MCD) supported<\/li>\n<\/ul>\n<\/div>\n<div style=\"flex: 1 1 260px; border: 2px solid #377dff; border-radius: 16px; padding: 26px 24px; background: #fff; box-shadow: 0 18px 40px rgba(55,125,255,.14);\">\n<h3 style=\"margin: 0 0 4px; font-size: 15px; letter-spacing: .1em; text-transform: uppercase; color: #7a8199;\">Enterprise<\/h3>\n<div style=\"font-size: 38px; font-weight: 800; color: #17072b; letter-spacing: -.02em;\">$7,500<span style=\"font-size: 15px; font-weight: 600; color: #5c6077;\"> \/ year<\/span><\/div>\n<ul style=\"margin: 16px 0 0; padding-left: 20px; color: #5c6077;\">\n<li style=\"margin: 6px 0;\">500,000 validations included<\/li>\n<li style=\"margin: 6px 0;\">Full <code>GetBestMatches<\/code> output<\/li>\n<li style=\"margin: 6px 0;\">Marketplace Capacity Drawdown (MCD) supported<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div style=\"border-left: 4px solid #377dff; background: #f4f8ff; border-radius: 0 10px 10px 0; padding: 14px 18px; margin: 18px 0; font-size: 15px;\"><strong>Marketplace Capacity Drawdown (MCD) supported:<\/strong> pay from your existing committed Snowflake spend.<\/div>\n<div style=\"border-left: 4px solid #f79009; background: #fff8ee; border-radius: 0 10px 10px 0; padding: 14px 18px; margin: 18px 0; font-size: 15px;\"><strong>Trial limit reached?<\/strong> The trial stops at 1,000 records or 20 days, whichever comes first. To continue, upgrade to a paid plan from the Marketplace listing.<\/div>\n<\/section>\n<p><!-- ===================== FAQ ===================== --><\/p>\n<section id=\"faq\" class=\"av3docs-faq\" style=\"border-top: 1px solid #eef1f6; margin-top: 34px; padding-top: 30px;\">\n<h2 style=\"font-size: clamp(23px,2.6vw,29px); font-weight: bold; color: #17072b; letter-spacing: -.02em; margin: 0 0 14px;\">Frequently asked questions<\/h2>\n<details style=\"border: 1px solid #E6E6E6; border-radius: 10px; margin: 12px 0; background: #fff; overflow: hidden;\">\n<summary style=\"cursor: pointer; padding: 16px 20px; font-weight: bold; color: #17072b;\">What does the AV3 free trial include?<\/summary>\n<div style=\"padding: 0 20px 18px; color: #5c6077;\">1,000 address validations over 20 days with full <code>GetBestMatches<\/code> output, including DPV codes, correction notes, and standardized fields. No credit card is required, and there are no automatic charges when the trial ends.<\/div>\n<\/details>\n<details style=\"border: 1px solid #E6E6E6; border-radius: 10px; margin: 12px 0; background: #fff; overflow: hidden;\">\n<summary style=\"cursor: pointer; padding: 16px 20px; font-weight: bold; color: #17072b;\">Which Snowflake regions are supported?<\/summary>\n<div style=\"padding: 0 20px 18px; color: #5c6077;\">AWS US East (N. Virginia), AWS US East (Ohio), AWS US West (Oregon), and Azure Central US (Iowa), among others listed on the Marketplace.<\/div>\n<\/details>\n<details style=\"border: 1px solid #E6E6E6; border-radius: 10px; margin: 12px 0; background: #fff; overflow: hidden;\">\n<summary style=\"cursor: pointer; padding: 16px 20px; font-weight: bold; color: #17072b;\">Does Service Objects store or retain my address data?<\/summary>\n<div style=\"padding: 0 20px 18px; color: #5c6077;\">No. AV3 uses a single external access integration to reach the Service Objects Address Validation API, and no data is stored, logged, or retained by Service Objects. You grant the integration explicitly and can revoke it at any time.<\/div>\n<\/details>\n<details style=\"border: 1px solid #E6E6E6; border-radius: 10px; margin: 12px 0; background: #fff; overflow: hidden;\">\n<summary style=\"cursor: pointer; padding: 16px 20px; font-weight: bold; color: #17072b;\">What if my table columns are named differently?<\/summary>\n<div style=\"padding: 0 20px 18px; color: #5c6077;\">Create a <code>VIEW<\/code> that maps your columns to the expected names (<code>CONSUMER_ROW_ID<\/code>, <code>BUSINESSNAME<\/code>, <code>ADDRESS<\/code>, <code>ADDRESS2<\/code>, <code>CITY<\/code>, <code>STATE<\/code>, <code>POSTALCODE<\/code>) and pass that view to <code>AV3_VALIDATE<\/code>.<\/div>\n<\/details>\n<details style=\"border: 1px solid #E6E6E6; border-radius: 10px; margin: 12px 0; background: #fff; overflow: hidden;\">\n<summary style=\"cursor: pointer; padding: 16px 20px; font-weight: bold; color: #17072b;\">How do I know an address is deliverable?<\/summary>\n<div style=\"padding: 0 20px 18px; color: #5c6077;\">Check the <code>DPV<\/code> field \u2014 a value of <code>1<\/code> means the address is a confirmed USPS delivery point. Filter with <code>WHERE DPV = 1<\/code> to return only confirmed, deliverable addresses.<\/div>\n<\/details>\n<details style=\"border: 1px solid #E6E6E6; border-radius: 10px; margin: 12px 0; background: #fff; overflow: hidden;\">\n<summary style=\"cursor: pointer; padding: 16px 20px; font-weight: bold; color: #17072b;\">Can I schedule validation to run automatically?<\/summary>\n<div style=\"padding: 0 20px 18px; color: #5c6077;\">Yes. Wrap the <code>CALL APP_CODE.AV3_VALIDATE(...)<\/code> statement in a Snowflake task to run recurring validation on a schedule.<\/div>\n<\/details>\n<\/section>\n<p><!-- ===================== HELP ===================== --><\/p>\n<section id=\"help\" style=\"margin-top: 44px; border-radius: 22px; color: #fff; padding: 34px 32px; background: radial-gradient(at top right,#8B4EBA 0%,#050829 83%);\">\n<h2 style=\"font-size: clamp(23px,2.6vw,29px); font-weight: bold; color: #fff; letter-spacing: -.02em; margin: 0 0 8px;\">Need help?<\/h2>\n<p style=\"color: #d7ddf3; margin: 0 0 18px;\">Our team is here to get you from trial to production.<\/p>\n<div style=\"display: flex; flex-wrap: wrap; gap: 14px;\">\n<div style=\"flex: 1 1 220px; background: rgba(255,255,255,.08); border: 1px solid rgba(255,255,255,.16); border-radius: 16px; padding: 16px 20px;\"><b style=\"display: block; color: #fff; margin-bottom: 4px;\">Technical support<\/b><br \/>\n<a style=\"color: #8fd6ff; font-weight: bold; text-decoration: none;\" href=\"mailto:support@serviceobjects.com\">support@serviceobjects.com<\/a><\/div>\n<div style=\"flex: 1 1 220px; background: rgba(255,255,255,.08); border: 1px solid rgba(255,255,255,.16); border-radius: 16px; padding: 16px 20px;\"><b style=\"display: block; color: #fff; margin-bottom: 4px;\">Sales &amp; Marketplace inquiries<\/b><br \/>\n<a style=\"color: #8fd6ff; font-weight: bold; text-decoration: none;\" href=\"mailto:ae@serviceobjects.com\">ae@serviceobjects.com<\/a><\/div>\n<\/div>\n<\/section>\n<\/div>\n<p><!-- ================= JSON-LD: HowTo + FAQPage + Breadcrumb (SEO \/ LLM) ================= --><br \/>\n<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@graph\": [\n    {\n      \"@type\": \"HowTo\",\n      \"name\": \"Validate US addresses in Snowflake with Service Objects AV3\",\n      \"description\": \"Install Address Validation 3 (AV3) from the Snowflake Marketplace, grant external access, run AV3_VALIDATE, and read standardized DPV results - your first validated address in under 10 minutes.\",\n      \"totalTime\": \"PT10M\",\n      \"tool\": [{ \"@type\": \"HowToTool\", \"name\": \"Snowflake account in a supported region\" }],\n      \"supply\": [{ \"@type\": \"HowToSupply\", \"name\": \"A table of US addresses (or the provided sample data)\" }],\n      \"step\": [\n        { \"@type\": \"HowToStep\", \"position\": 1, \"name\": \"Get the app from the Snowflake Marketplace\", \"text\": \"Search the Snowflake Marketplace for 'US Address Validation' or 'Service Objects', open the AV3 listing, and select Try Now to start the free 20-day trial (1,000 validations, no credit card).\", \"url\": \"https:\/\/www.serviceobjects.com\/docs\/address-validation-3-snowflake-quick-start#step-1\" },\n        { \"@type\": \"HowToStep\", \"position\": 2, \"name\": \"Grant the external access integration\", \"text\": \"Grant AV3 the single external access integration it needs to connect to the Service Objects Address Validation API. No data is stored, logged, or retained by Service Objects.\", \"url\": \"https:\/\/www.serviceobjects.com\/docs\/address-validation-3-snowflake-quick-start#step-2\" },\n        { \"@type\": \"HowToStep\", \"position\": 3, \"name\": \"Prepare your address data\", \"text\": \"Provide a table with ADDRESS (required), plus optional\/conditional CONSUMER_ROW_ID, BUSINESSNAME, ADDRESS2, CITY, STATE, and POSTALCODE. Map different column names with a VIEW.\", \"url\": \"https:\/\/www.serviceobjects.com\/docs\/address-validation-3-snowflake-quick-start#step-3\" },\n        { \"@type\": \"HowToStep\", \"position\": 4, \"name\": \"Run your first validation\", \"text\": \"Call APP_CODE.AV3_VALIDATE on an entire table, on a SELECT query, or on a query with a custom output table path.\", \"url\": \"https:\/\/www.serviceobjects.com\/docs\/address-validation-3-snowflake-quick-start#step-4\" },\n        { \"@type\": \"HowToStep\", \"position\": 5, \"name\": \"Read the results\", \"text\": \"Query the output table for standardized addresses, DPV confirmation, DPV notes, ZIP+4, RDI, correction notes, and parsed address fragments. Filter with WHERE DPV = 1 for confirmed deliverable addresses.\", \"url\": \"https:\/\/www.serviceobjects.com\/docs\/address-validation-3-snowflake-quick-start#step-5\" },\n        { \"@type\": \"HowToStep\", \"position\": 6, \"name\": \"Use the output in your workflows\", \"text\": \"Join results back by row ID, filter and route by DPV, feed standardized addresses into downstream pipelines, and schedule recurring validation with a Snowflake task.\", \"url\": \"https:\/\/www.serviceobjects.com\/docs\/address-validation-3-snowflake-quick-start#step-6\" }\n      ]\n    },\n    {\n      \"@type\": \"FAQPage\",\n      \"mainEntity\": [\n        { \"@type\": \"Question\", \"name\": \"What does the AV3 free trial include?\", \"acceptedAnswer\": { \"@type\": \"Answer\", \"text\": \"1,000 address validations over 20 days with full GetBestMatches output, including DPV codes, correction notes, and standardized fields. No credit card is required and there are no automatic charges when the trial ends.\" } },\n        { \"@type\": \"Question\", \"name\": \"Which Snowflake regions are supported?\", \"acceptedAnswer\": { \"@type\": \"Answer\", \"text\": \"AWS US East (N. Virginia), AWS US East (Ohio), AWS US West (Oregon), and Azure Central US (Iowa), among others listed on the Marketplace.\" } },\n        { \"@type\": \"Question\", \"name\": \"Does Service Objects store or retain my address data?\", \"acceptedAnswer\": { \"@type\": \"Answer\", \"text\": \"No. AV3 uses a single external access integration to reach the Service Objects Address Validation API, and no data is stored, logged, or retained by Service Objects. You grant the integration explicitly and can revoke it at any time.\" } },\n        { \"@type\": \"Question\", \"name\": \"What if my table columns are named differently?\", \"acceptedAnswer\": { \"@type\": \"Answer\", \"text\": \"Create a VIEW that maps your columns to the expected names (CONSUMER_ROW_ID, BUSINESSNAME, ADDRESS, ADDRESS2, CITY, STATE, POSTALCODE) and pass that view to AV3_VALIDATE.\" } },\n        { \"@type\": \"Question\", \"name\": \"How do I know an address is deliverable?\", \"acceptedAnswer\": { \"@type\": \"Answer\", \"text\": \"Check the DPV field - a value of 1 means the address is a confirmed USPS delivery point. Filter with WHERE DPV = 1 to return only confirmed, deliverable addresses.\" } },\n        { \"@type\": \"Question\", \"name\": \"Can I schedule validation to run automatically?\", \"acceptedAnswer\": { \"@type\": \"Answer\", \"text\": \"Yes. Wrap the CALL APP_CODE.AV3_VALIDATE(...) statement in a Snowflake task to run recurring validation on a schedule.\" } }\n      ]\n    },\n    {\n      \"@type\": \"BreadcrumbList\",\n      \"itemListElement\": [\n        { \"@type\": \"ListItem\", \"position\": 1, \"name\": \"Home\", \"item\": \"https:\/\/www.serviceobjects.com\/\" },\n        { \"@type\": \"ListItem\", \"position\": 2, \"name\": \"Docs\", \"item\": \"https:\/\/www.serviceobjects.com\/docs\/\" },\n        { \"@type\": \"ListItem\", \"position\": 3, \"name\": \"Address Validation 3 for Snowflake: Quick-Start Guide\", \"item\": \"https:\/\/www.serviceobjects.com\/docs\/address-validation-3-snowflake-quick-start\" }\n      ]\n    }\n  ]\n}\n<\/script><\/p>\n<p><!-- ================= Copy-to-clipboard helper ================= --><br \/>\n<script>\n(function () {\n  var root = document.querySelector('.av3docs-page');\n  if (!root) return;\n  root.addEventListener('click', function (e) {\n    var btn = e.target.closest('.av3docs-copy');\n    if (!btn) return;\n    var block = btn.parentElement.parentElement;\n    var code = block && block.querySelector('code');\n    if (!code) return;\n    var done = function () {\n      btn.textContent = 'Copied';\n      setTimeout(function () { btn.textContent = 'Copy'; }, 1600);\n    };\n    if (navigator.clipboard && navigator.clipboard.writeText) {\n      navigator.clipboard.writeText(code.innerText).then(done).catch(done);\n    } else {\n      var ta = document.createElement('textarea');\n      ta.value = code.innerText; document.body.appendChild(ta); ta.select();\n      try { document.execCommand('copy'); } catch (err) {}\n      document.body.removeChild(ta); done();\n    }\n  });\n})();\n<\/script><br \/>\n<!-- AV3DOCS:END --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Validate US addresses inside Snowflake with Service Objects AV3. Step-by-step quick start: install from the Marketplace, grant access, run AV3_VALIDATE, and read DPV results &#8211; first validated address in under 10 minutes.<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":12736,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-12720","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Address Validation - Quick-Start guide<\/title>\n<meta name=\"description\" content=\"Validate US addresses inside Snowflake with Service Objects AV3. Step-by-step quick start: install from the Marketplace, grant access, run AV3_VALIDATE, and read DPV results - first validated address in under 10 minutes.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.serviceobjects.com\/docs\/snowflake\/av3-snowflake-guide\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Address Validation - Quick-Start guide\" \/>\n<meta property=\"og:description\" content=\"Validate US addresses inside Snowflake with Service Objects AV3. Step-by-step quick start: install from the Marketplace, grant access, run AV3_VALIDATE, and read DPV results - first validated address in under 10 minutes.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.serviceobjects.com\/docs\/snowflake\/av3-snowflake-guide\/\" \/>\n<meta property=\"og:site_name\" content=\"Service Objects | Contact, Phone, Email Verification | Data Quality Services\" \/>\n<meta property=\"article:modified_time\" content=\"2026-07-31T06:54:08+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.serviceobjects.com\/docs\/snowflake\/av3-snowflake-guide\/\",\"url\":\"https:\/\/www.serviceobjects.com\/docs\/snowflake\/av3-snowflake-guide\/\",\"name\":\"Address Validation - Quick-Start guide\",\"isPartOf\":{\"@id\":\"https:\/\/www.serviceobjects.com\/docs\/#website\"},\"datePublished\":\"2026-07-30T05:19:12+00:00\",\"dateModified\":\"2026-07-31T06:54:08+00:00\",\"description\":\"Validate US addresses inside Snowflake with Service Objects AV3. Step-by-step quick start: install from the Marketplace, grant access, run AV3_VALIDATE, and read DPV results - first validated address in under 10 minutes.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.serviceobjects.com\/docs\/snowflake\/av3-snowflake-guide\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.serviceobjects.com\/docs\/snowflake\/av3-snowflake-guide\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.serviceobjects.com\/docs\/snowflake\/av3-snowflake-guide\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.serviceobjects.com\/docs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Snowflake\",\"item\":\"https:\/\/www.serviceobjects.com\/docs\/snowflake\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Address Validation &#8211; Quick-Start guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.serviceobjects.com\/docs\/#website\",\"url\":\"https:\/\/www.serviceobjects.com\/docs\/\",\"name\":\"Service Objects | Contact, Phone, Email Verification | Data Quality Services\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.serviceobjects.com\/docs\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.serviceobjects.com\/docs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.serviceobjects.com\/docs\/#organization\",\"name\":\"Service Objects | Contact, Phone, Email Verification | Data Quality Services\",\"url\":\"https:\/\/www.serviceobjects.com\/docs\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.serviceobjects.com\/docs\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.serviceobjects.com\/docs\/wp-content\/uploads\/2022\/08\/SO-logo-2560px-transparent.png\",\"contentUrl\":\"https:\/\/www.serviceobjects.com\/docs\/wp-content\/uploads\/2022\/08\/SO-logo-2560px-transparent.png\",\"width\":2560,\"height\":1440,\"caption\":\"Service Objects | Contact, Phone, Email Verification | Data Quality Services\"},\"image\":{\"@id\":\"https:\/\/www.serviceobjects.com\/docs\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Address Validation - Quick-Start guide","description":"Validate US addresses inside Snowflake with Service Objects AV3. Step-by-step quick start: install from the Marketplace, grant access, run AV3_VALIDATE, and read DPV results - first validated address in under 10 minutes.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.serviceobjects.com\/docs\/snowflake\/av3-snowflake-guide\/","og_locale":"en_US","og_type":"article","og_title":"Address Validation - Quick-Start guide","og_description":"Validate US addresses inside Snowflake with Service Objects AV3. Step-by-step quick start: install from the Marketplace, grant access, run AV3_VALIDATE, and read DPV results - first validated address in under 10 minutes.","og_url":"https:\/\/www.serviceobjects.com\/docs\/snowflake\/av3-snowflake-guide\/","og_site_name":"Service Objects | Contact, Phone, Email Verification | Data Quality Services","article_modified_time":"2026-07-31T06:54:08+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.serviceobjects.com\/docs\/snowflake\/av3-snowflake-guide\/","url":"https:\/\/www.serviceobjects.com\/docs\/snowflake\/av3-snowflake-guide\/","name":"Address Validation - Quick-Start guide","isPartOf":{"@id":"https:\/\/www.serviceobjects.com\/docs\/#website"},"datePublished":"2026-07-30T05:19:12+00:00","dateModified":"2026-07-31T06:54:08+00:00","description":"Validate US addresses inside Snowflake with Service Objects AV3. Step-by-step quick start: install from the Marketplace, grant access, run AV3_VALIDATE, and read DPV results - first validated address in under 10 minutes.","breadcrumb":{"@id":"https:\/\/www.serviceobjects.com\/docs\/snowflake\/av3-snowflake-guide\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.serviceobjects.com\/docs\/snowflake\/av3-snowflake-guide\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.serviceobjects.com\/docs\/snowflake\/av3-snowflake-guide\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.serviceobjects.com\/docs\/"},{"@type":"ListItem","position":2,"name":"Snowflake","item":"https:\/\/www.serviceobjects.com\/docs\/snowflake\/"},{"@type":"ListItem","position":3,"name":"Address Validation &#8211; Quick-Start guide"}]},{"@type":"WebSite","@id":"https:\/\/www.serviceobjects.com\/docs\/#website","url":"https:\/\/www.serviceobjects.com\/docs\/","name":"Service Objects | Contact, Phone, Email Verification | Data Quality Services","description":"","publisher":{"@id":"https:\/\/www.serviceobjects.com\/docs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.serviceobjects.com\/docs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.serviceobjects.com\/docs\/#organization","name":"Service Objects | Contact, Phone, Email Verification | Data Quality Services","url":"https:\/\/www.serviceobjects.com\/docs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.serviceobjects.com\/docs\/#\/schema\/logo\/image\/","url":"https:\/\/www.serviceobjects.com\/docs\/wp-content\/uploads\/2022\/08\/SO-logo-2560px-transparent.png","contentUrl":"https:\/\/www.serviceobjects.com\/docs\/wp-content\/uploads\/2022\/08\/SO-logo-2560px-transparent.png","width":2560,"height":1440,"caption":"Service Objects | Contact, Phone, Email Verification | Data Quality Services"},"image":{"@id":"https:\/\/www.serviceobjects.com\/docs\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.serviceobjects.com\/docs\/wp-json\/wp\/v2\/pages\/12720","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.serviceobjects.com\/docs\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.serviceobjects.com\/docs\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.serviceobjects.com\/docs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.serviceobjects.com\/docs\/wp-json\/wp\/v2\/comments?post=12720"}],"version-history":[{"count":13,"href":"https:\/\/www.serviceobjects.com\/docs\/wp-json\/wp\/v2\/pages\/12720\/revisions"}],"predecessor-version":[{"id":12750,"href":"https:\/\/www.serviceobjects.com\/docs\/wp-json\/wp\/v2\/pages\/12720\/revisions\/12750"}],"up":[{"embeddable":true,"href":"https:\/\/www.serviceobjects.com\/docs\/wp-json\/wp\/v2\/pages\/12736"}],"wp:attachment":[{"href":"https:\/\/www.serviceobjects.com\/docs\/wp-json\/wp\/v2\/media?parent=12720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}