{"id":12771,"date":"2026-09-21T06:40:37","date_gmt":"2026-09-21T13:40:37","guid":{"rendered":"https:\/\/www.serviceobjects.com\/docs\/?page_id=12771"},"modified":"2026-09-21T06:40:38","modified_gmt":"2026-09-21T13:40:38","slug":"address-geocode-snowflake-guide","status":"publish","type":"page","link":"https:\/\/www.serviceobjects.com\/docs\/snowflake\/address-geocode-snowflake-guide\/","title":{"rendered":"Address Geocode US &#8211; Quick-Start guide"},"content":{"rendered":"<p><!-- AGUSDOCS:START --><\/p>\n<style>\nmain header h1{display:none}\n\/* Fonts + enhancements only. All core styling is inline (survives WP sanitizing). *\/\n@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\");}\n@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\");}\n@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\");}\n.agusdocs-page code{font-family:\"SFMono-Regular\",Consolas,\"Liberation Mono\",Menlo,monospace;font-size:.92em;background:#eef1f8;color:#1b2a63;padding:2px 6px;border-radius:6px;}\n.agusdocs-page pre code{background:none;color:#e7ecff;padding:0;border-radius:0;}\n.agusdocs-page a.agusdocs-link{color:#004E95;}\n.agusdocs-copy:hover{background:rgba(255,255,255,.18) !important;color:#fff !important;}\n<\/style>\n<div class=\"agusdocs-page\" style=\"margin:0 auto;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:700;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 Geocode US quick start<\/h1>\n<p style=\"font-size:clamp(16px,1.6vw,19px);color:#5C6077;margin:0 0 20px;max-width:720px;\">Install the app, start your trial, and turn your first batch of US addresses into coordinates without leaving your own Snowflake account.<\/p>\n<div style=\"border-left:4px solid #377dff;background:#f4f8ff;border-radius:0 10px 10px 0;padding:14px 18px;margin:0 0 22px;font-size:15px;\">Roughly 15 minutes. You will need <code>ACCOUNTADMIN<\/code> for the install and grant steps.<\/div>\n<p>  <a target=\"_blank\" href=\"https:\/\/app.snowflake.com\/marketplace\/listing\/GZ1MJZ4VGDH5T\/service-objects-inc-us-address-geocoding-location-intelligence-for-snowflake\" style=\"display:inline-flex;align-items:center;gap:10px;background:#377dff;color:#fff;font-weight:700;font-size:16px;padding:14px 24px;border-radius:12px;text-decoration:none;box-shadow:0 10px 24px rgba(55,125,255,.35);\">Get Address Geocode US on the Snowflake Marketplace &rarr;<\/a><\/p>\n<p>  <!-- ===================== BEFORE YOU BEGIN ===================== --><\/p>\n<section id=\"before-you-begin\" style=\"margin-top:34px;\">\n<h2 style=\"font-size:clamp(23px,2.6vw,29px);font-weight:700;color:#17072B;letter-spacing:-.02em;margin:0 0 14px;\">Before you begin<\/h2>\n<ul style=\"margin:0 0 12px;padding-left:22px;\">\n<li style=\"margin:6px 0;\">A Snowflake account on a supported cloud and region.<\/li>\n<li style=\"margin:6px 0;\">The <code>ACCOUNTADMIN<\/code> role, or a role that can install a Native App and grant an external access integration.<\/li>\n<li style=\"margin:6px 0;\">A running virtual compute cluster you can use for the session.<\/li>\n<li style=\"margin:6px 0;\">A table of US addresses, or permission to create one.<\/li>\n<\/ul>\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>Coverage is United States only.<\/strong> Addresses outside the US will not return coordinates.<\/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;\">\n    <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:700;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 Address Geocode US and started your trial? Skip to Step 2.<\/p>\n<p style=\"margin:0 0 16px;\">If not: open the Address Geocode US listing on the Snowflake Marketplace and select <strong>Try Now<\/strong> to start the free trial.<\/p>\n<p style=\"margin:0 0 16px;\">The trial is for 20 days and includes 1,000 geocode lookups with full output including latitude and longitude, match level, and the census and jurisdiction fields. No credit card required.<\/p>\n<p style=\"margin:0 0 16px;\">Snowflake will ask you to name the installed application. The examples on this page use the default name <code>SERVICE_OBJECTS_AGUS_APP<\/code> and the application schema <code>APP_CODE<\/code>. If you chose a different application name, substitute it in Step 2.<\/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;\">\n    <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:700;color:#17072B;letter-spacing:-.02em;margin:12px 0 14px;\">Grant the external access integration<\/h2>\n<p style=\"margin:0 0 16px;\">Address Geocode US runs inside your account. Before it can do anything, grant the installed application permission to reach the database and schema you are working in, and to create the table it writes results to.<\/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);\">\n        <span style=\"font-size:11px;letter-spacing:.14em;text-transform:uppercase;color:#8ea0d6;font-weight:700;\">SQL<\/span><br \/>\n        <button type=\"button\" class=\"agusdocs-copy\" style=\"background:rgba(255,255,255,.08);border:1px solid #243056;color:#cdd8ff;font-size:12px;font-weight:700;padding:5px 11px;border-radius:7px;cursor:pointer;\">Copy<\/button>\n      <\/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;\">GRANT USAGE ON DATABASE MY_DB\n  TO APPLICATION SERVICE_OBJECTS_AGUS_APP;\n\nGRANT USAGE ON SCHEMA MY_DB.PUBLIC\n  TO APPLICATION SERVICE_OBJECTS_AGUS_APP;\n\nGRANT CREATE TABLE ON SCHEMA MY_DB.PUBLIC\n  TO APPLICATION SERVICE_OBJECTS_AGUS_APP;<\/code><\/pre>\n<\/p><\/div>\n<p style=\"margin:0 0 16px;\">Substitute your own database and schema for <code>MY_DB<\/code> and <code>MY_DB.PUBLIC<\/code>. If you are unsure what the application ended up being called, run <code>SHOW APPLICATIONS;<\/code> and use the name listed there.<\/p>\n<p style=\"margin:0 0 16px;\">The app reaches the Service Objects geocoding service through a single external access integration. You can inspect it in the app manifest at any time, 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>What this connection does.<\/strong> The app sends address data to the Service Objects API through this one integration, which you grant and can revoke, and retains nothing. Data is encrypted in transit over HTTPS.<\/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;\">\n    <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:700;color:#17072B;letter-spacing:-.02em;margin:12px 0 14px;\">Prepare your address data<\/h2>\n<p style=\"margin:0 0 16px;\">The app reads five columns, and the order is fixed. Every column has to be present in the <code>SELECT<\/code> statement you pass in, even for records that have no value for it. Pass an empty value rather than dropping the column.<\/p>\n<div style=\"overflow-x:auto;border:1px solid #E6E6E6;border-radius:10px;margin:16px 0 20px;\">\n<table cellpadding=\"0\" cellspacing=\"0\" style=\"width:100%;border-collapse:collapse;font-size:14.5px;min-width:520px;\">\n<thead>\n<tr>\n<th style=\"text-align:left;padding:12px 16px;background:#F7FAFD;color:#17072B;font-weight:700;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:700;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:700;font-size:13px;border-bottom:1px solid #eef1f6;\">Notes<\/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:700;padding:2px 9px;border-radius:999px;text-transform:uppercase;background:#e7f6ee;color:#087443;\">Yes<\/span><\/td>\n<td style=\"padding:12px 16px;border-bottom:1px solid #eef1f6;vertical-align:top;\">Your identifier for the record. Carried through to the results table as the join key.<\/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:700;padding:2px 9px;border-radius:999px;text-transform:uppercase;background:#e7f6ee;color:#087443;\">Yes<\/span><\/td>\n<td style=\"padding:12px 16px;border-bottom:1px solid #eef1f6;vertical-align:top;\">Street line, including number and street name.<\/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:700;padding:2px 9px;border-radius:999px;text-transform:uppercase;background:#e7f6ee;color:#087443;\">Yes<\/span><\/td>\n<td style=\"padding:12px 16px;border-bottom:1px solid #eef1f6;vertical-align:top;\">City name. Must be present even when empty.<\/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:700;padding:2px 9px;border-radius:999px;text-transform:uppercase;background:#e7f6ee;color:#087443;\">Yes<\/span><\/td>\n<td style=\"padding:12px 16px;border-bottom:1px solid #eef1f6;vertical-align:top;\">Two letter state code or the full state name. Must be present even when empty.<\/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:700;padding:2px 9px;border-radius:999px;text-transform:uppercase;background:#e7f6ee;color:#087443;\">Yes<\/span><\/td>\n<td style=\"padding:12px 16px;vertical-align:top;\">Five digit ZIP or ZIP plus four.<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<p style=\"margin:0 0 16px;\">To follow along without touching production data, create a small test table that covers the range of input quality you actually hold:<\/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);\">\n        <span style=\"font-size:11px;letter-spacing:.14em;text-transform:uppercase;color:#8ea0d6;font-weight:700;\">SQL<\/span><br \/>\n        <button type=\"button\" class=\"agusdocs-copy\" style=\"background:rgba(255,255,255,.08);border:1px solid #243056;color:#cdd8ff;font-size:12px;font-weight:700;padding:5px 11px;border-radius:7px;cursor:pointer;\">Copy<\/button>\n      <\/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 NUMBER,\n  ADDRESS         VARCHAR,\n  CITY            VARCHAR,\n  STATE           VARCHAR,\n  POSTALCODE      VARCHAR\n);\n\nINSERT INTO MY_SCHEMA.TEST_ADDRESSES VALUES\n  (1, '27 E Cota St',              'Santa Barbara', 'CA', '93101'),\n  (2, '1600 Pennsylvania Ave NW',  'Washington',    'DC', '20500'),\n  (3, '123 Main Street',           'Springfield',   'IL', NULL),\n  (4, '',                          '',              NULL, '10001'),\n  (5, '4 Privet Drive',            'Nowhere',       'XX', '00000');<\/code><\/pre>\n<\/p><\/div>\n<p style=\"margin:0 0 16px;\">Those five cover a clean full address, a well known landmark, a street with no postal code, a postal code on its own, and a record that should not resolve at all. Note that the missing values are empty strings, not omitted columns.<\/p>\n<\/section>\n<p>  <!-- ===================== STEP 4 ===================== --><\/p>\n<section id=\"step-4\" style=\"border-top:1px solid #eef1f6;margin-top:34px;padding-top:30px;\">\n    <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:700;color:#17072B;letter-spacing:-.02em;margin:12px 0 14px;\">Run the geocode<\/h2>\n<p style=\"margin:0 0 16px;\">Geocoding runs as a stored procedure. You call it, it writes a results table, and you query that table. Supply a <code>SELECT<\/code> statement and the path where you want results written.<\/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);\">\n        <span style=\"font-size:11px;letter-spacing:.14em;text-transform:uppercase;color:#8ea0d6;font-weight:700;\">SQL<\/span><br \/>\n        <button type=\"button\" class=\"agusdocs-copy\" style=\"background:rgba(255,255,255,.08);border:1px solid #243056;color:#cdd8ff;font-size:12px;font-weight:700;padding:5px 11px;border-radius:7px;cursor:pointer;\">Copy<\/button>\n      <\/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.AGUS_GET_BEST_MATCHES_V4(\n  'SELECT CONSUMER_ROW_ID, ADDRESS,\n          CITY, STATE, POSTALCODE\n   FROM MY_SCHEMA.TEST_ADDRESSES',\n  'MY_SCHEMA.AGUS_RESULTS'\n);<\/code><\/pre>\n<\/p><\/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;\">\n    <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:700;color:#17072B;letter-spacing:-.02em;margin:12px 0 14px;\">Read the results<\/h2>\n<p style=\"margin:0 0 16px;\">Query the results table the call produced:<\/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);\">\n        <span style=\"font-size:11px;letter-spacing:.14em;text-transform:uppercase;color:#8ea0d6;font-weight:700;\">SQL<\/span><br \/>\n        <button type=\"button\" class=\"agusdocs-copy\" style=\"background:rgba(255,255,255,.08);border:1px solid #243056;color:#cdd8ff;font-size:12px;font-weight:700;padding:5px 11px;border-radius:7px;cursor:pointer;\">Copy<\/button>\n      <\/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.AGUS_RESULTS LIMIT 10;<\/code><\/pre>\n<\/p><\/div>\n<p style=\"margin:0 0 16px;\">These are the columns you act on. They are the location itself, and how precisely the app was able to resolve it.<\/p>\n<div style=\"overflow-x:auto;border:1px solid #E6E6E6;border-radius:10px;margin:16px 0 24px;\">\n<table cellpadding=\"0\" cellspacing=\"0\" style=\"width:100%;border-collapse:collapse;font-size:14.5px;min-width:520px;\">\n<thead>\n<tr>\n<th style=\"text-align:left;padding:12px 16px;background:#F7FAFD;color:#17072B;font-weight:700;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:700;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;\"><code>CONSUMER_ROW_ID<\/code><\/td>\n<td style=\"padding:12px 16px;border-bottom:1px solid #eef1f6;vertical-align:top;\">Your original row identifier, for joining back to source.<\/td>\n<\/tr>\n<tr>\n<td style=\"padding:12px 16px;border-bottom:1px solid #eef1f6;vertical-align:top;\"><code>Level<\/code><\/td>\n<td style=\"padding:12px 16px;border-bottom:1px solid #eef1f6;vertical-align:top;\">Code for how precisely the address resolved. This is the column to route on.<\/td>\n<\/tr>\n<tr>\n<td style=\"padding:12px 16px;border-bottom:1px solid #eef1f6;vertical-align:top;\"><code>LevelDescription<\/code><\/td>\n<td style=\"padding:12px 16px;border-bottom:1px solid #eef1f6;vertical-align:top;\">Plain text explanation of the level code, for example that the address matched exactly at the street location.<\/td>\n<\/tr>\n<tr>\n<td style=\"padding:12px 16px;border-bottom:1px solid #eef1f6;vertical-align:top;\"><code>Latitude<\/code><\/td>\n<td style=\"padding:12px 16px;border-bottom:1px solid #eef1f6;vertical-align:top;\">Decimal latitude for the matched location.<\/td>\n<\/tr>\n<tr>\n<td style=\"padding:12px 16px;border-bottom:1px solid #eef1f6;vertical-align:top;\"><code>Longitude<\/code><\/td>\n<td style=\"padding:12px 16px;border-bottom:1px solid #eef1f6;vertical-align:top;\">Decimal longitude for the matched location.<\/td>\n<\/tr>\n<tr>\n<td style=\"padding:12px 16px;vertical-align:top;\"><code>ZIP<\/code><\/td>\n<td style=\"padding:12px 16px;vertical-align:top;\">ZIP plus four for the matched location.<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<p style=\"margin:0 0 16px;\">Each record also comes back with the jurisdictions and identifiers its location falls inside: state and county, place name, census tract, block and GeoID, congressional and state legislative districts, FIPS codes, the UTC offset, and ready made Google, Bing and MapQuest links. Those are what make the output joinable to public datasets, and the full field list is in the Service Objects documentation for this operation.<\/p>\n<p style=\"margin:0 0 16px;\">Before you use the coordinates for anything, check how precisely your records actually resolved. This counts your results by level, so you can see at a glance how many matched at the property and how many fell back to something wider:<\/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);\">\n        <span style=\"font-size:11px;letter-spacing:.14em;text-transform:uppercase;color:#8ea0d6;font-weight:700;\">SQL<\/span><br \/>\n        <button type=\"button\" class=\"agusdocs-copy\" style=\"background:rgba(255,255,255,.08);border:1px solid #243056;color:#cdd8ff;font-size:12px;font-weight:700;padding:5px 11px;border-radius:7px;cursor:pointer;\">Copy<\/button>\n      <\/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\n  MATCH_LEVEL,\n  COUNT(*) AS RECORDS\nFROM MY_SCHEMA.AGUS_RESULTS\nGROUP BY 1\nORDER BY 2 DESC;<\/code><\/pre>\n<\/p><\/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;\">\n    <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:700;color:#17072B;letter-spacing:-.02em;margin:12px 0 14px;\">Move to production<\/h2>\n<p style=\"margin:0 0 16px;\">When the trial ends, you can continue to the Marketplace listing&rsquo;s paid plan. If your organization has a Snowflake capacity commitment, Marketplace Capacity Drawdown lets you apply a percentage of that committed capacity toward the purchase, so the spend runs through an agreement you already have rather than a new one.<\/p>\n<\/section>\n<\/div>\n<p><!-- ================= JSON-LD: HowTo + Breadcrumb (SEO \/ LLM) ================= --><br \/>\n<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@graph\": [\n    {\n      \"@type\": \"HowTo\",\n      \"name\": \"Geocode US addresses in Snowflake with Service Objects Address Geocode US\",\n      \"description\": \"Install Address Geocode US from the Snowflake Marketplace, grant external access, run the geocode stored procedure, and read latitude, longitude, and match level - inside your own Snowflake account.\",\n      \"totalTime\": \"PT15M\",\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\": \"Open the Address Geocode US listing on the Snowflake Marketplace and select Try Now to start the free 20-day trial (1,000 geocode lookups, no credit card).\", \"url\": \"https:\/\/www.serviceobjects.com\/docs\/snowflake\/agus-snowflake-guide#step-1\" },\n        { \"@type\": \"HowToStep\", \"position\": 2, \"name\": \"Grant the external access integration\", \"text\": \"Grant the application usage on your database and schema and create-table on the schema, then grant the single external access integration it uses to reach the Service Objects geocoding API. The app retains nothing.\", \"url\": \"https:\/\/www.serviceobjects.com\/docs\/snowflake\/agus-snowflake-guide#step-2\" },\n        { \"@type\": \"HowToStep\", \"position\": 3, \"name\": \"Prepare your address data\", \"text\": \"Provide the five fixed-order columns CONSUMER_ROW_ID, ADDRESS, CITY, STATE, POSTALCODE. Every column must appear in the SELECT, even when empty.\", \"url\": \"https:\/\/www.serviceobjects.com\/docs\/snowflake\/agus-snowflake-guide#step-3\" },\n        { \"@type\": \"HowToStep\", \"position\": 4, \"name\": \"Run the geocode\", \"text\": \"Call APP_CODE.AGUS_GET_BEST_MATCHES_V4 with a SELECT statement and the output table path where the results are written.\", \"url\": \"https:\/\/www.serviceobjects.com\/docs\/snowflake\/agus-snowflake-guide#step-4\" },\n        { \"@type\": \"HowToStep\", \"position\": 5, \"name\": \"Read the results\", \"text\": \"Query the results table for Level, LevelDescription, Latitude, Longitude, and ZIP, plus the census and jurisdiction fields. Count results by level to see how precisely records resolved.\", \"url\": \"https:\/\/www.serviceobjects.com\/docs\/snowflake\/agus-snowflake-guide#step-5\" },\n        { \"@type\": \"HowToStep\", \"position\": 6, \"name\": \"Move to production\", \"text\": \"Continue to the Marketplace listing's paid plan when the trial ends. Marketplace Capacity Drawdown can apply committed Snowflake capacity toward the purchase.\", \"url\": \"https:\/\/www.serviceobjects.com\/docs\/snowflake\/agus-snowflake-guide#step-6\" }\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\": \"Snowflake\", \"item\": \"https:\/\/www.serviceobjects.com\/docs\/snowflake\/\" },\n        { \"@type\": \"ListItem\", \"position\": 4, \"name\": \"Address Geocode US quick start\", \"item\": \"https:\/\/www.serviceobjects.com\/docs\/snowflake\/agus-snowflake-guide\" }\n      ]\n    }\n  ]\n}\n<\/script><\/p>\n<p><!-- ================= Copy-to-clipboard helper ================= --><br \/>\n<script>\n(function () {\n  var root = document.querySelector('.agusdocs-page');\n  if (!root) return;\n  root.addEventListener('click', function (e) {\n    var btn = e.target.closest('.agusdocs-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<!-- AGUSDOCS:END --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Turn US addresses into coordinates inside Snowflake with Service Objects Address Geocode US. Step-by-step quick start: install from the Marketplace, grant access, run AGUS_GET_BEST_MATCHES_V4, and read latitude, longitude, and match level &#8211; all in SQL.<\/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-12771","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 Geocode US - Quick-Start guide<\/title>\n<meta name=\"description\" content=\"Turn US addresses into coordinates inside Snowflake with Service Objects Address Geocode US. Step-by-step quick start: install from the Marketplace, grant access, run AGUS_GET_BEST_MATCHES_V4, and read latitude, longitude, and match level - all in SQL.\" \/>\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\/address-geocode-snowflake-guide\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Address Geocode US - Quick-Start guide\" \/>\n<meta property=\"og:description\" content=\"Turn US addresses into coordinates inside Snowflake with Service Objects Address Geocode US. Step-by-step quick start: install from the Marketplace, grant access, run AGUS_GET_BEST_MATCHES_V4, and read latitude, longitude, and match level - all in SQL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.serviceobjects.com\/docs\/snowflake\/address-geocode-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-09-21T13:40:38+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=\"4 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\/address-geocode-snowflake-guide\/\",\"url\":\"https:\/\/www.serviceobjects.com\/docs\/snowflake\/address-geocode-snowflake-guide\/\",\"name\":\"Address Geocode US - Quick-Start guide\",\"isPartOf\":{\"@id\":\"https:\/\/www.serviceobjects.com\/docs\/#website\"},\"datePublished\":\"2026-09-21T13:40:37+00:00\",\"dateModified\":\"2026-09-21T13:40:38+00:00\",\"description\":\"Turn US addresses into coordinates inside Snowflake with Service Objects Address Geocode US. Step-by-step quick start: install from the Marketplace, grant access, run AGUS_GET_BEST_MATCHES_V4, and read latitude, longitude, and match level - all in SQL.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.serviceobjects.com\/docs\/snowflake\/address-geocode-snowflake-guide\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.serviceobjects.com\/docs\/snowflake\/address-geocode-snowflake-guide\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.serviceobjects.com\/docs\/snowflake\/address-geocode-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 Geocode US &#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 Geocode US - Quick-Start guide","description":"Turn US addresses into coordinates inside Snowflake with Service Objects Address Geocode US. Step-by-step quick start: install from the Marketplace, grant access, run AGUS_GET_BEST_MATCHES_V4, and read latitude, longitude, and match level - all in SQL.","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\/address-geocode-snowflake-guide\/","og_locale":"en_US","og_type":"article","og_title":"Address Geocode US - Quick-Start guide","og_description":"Turn US addresses into coordinates inside Snowflake with Service Objects Address Geocode US. Step-by-step quick start: install from the Marketplace, grant access, run AGUS_GET_BEST_MATCHES_V4, and read latitude, longitude, and match level - all in SQL.","og_url":"https:\/\/www.serviceobjects.com\/docs\/snowflake\/address-geocode-snowflake-guide\/","og_site_name":"Service Objects | Contact, Phone, Email Verification | Data Quality Services","article_modified_time":"2026-09-21T13:40:38+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.serviceobjects.com\/docs\/snowflake\/address-geocode-snowflake-guide\/","url":"https:\/\/www.serviceobjects.com\/docs\/snowflake\/address-geocode-snowflake-guide\/","name":"Address Geocode US - Quick-Start guide","isPartOf":{"@id":"https:\/\/www.serviceobjects.com\/docs\/#website"},"datePublished":"2026-09-21T13:40:37+00:00","dateModified":"2026-09-21T13:40:38+00:00","description":"Turn US addresses into coordinates inside Snowflake with Service Objects Address Geocode US. Step-by-step quick start: install from the Marketplace, grant access, run AGUS_GET_BEST_MATCHES_V4, and read latitude, longitude, and match level - all in SQL.","breadcrumb":{"@id":"https:\/\/www.serviceobjects.com\/docs\/snowflake\/address-geocode-snowflake-guide\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.serviceobjects.com\/docs\/snowflake\/address-geocode-snowflake-guide\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.serviceobjects.com\/docs\/snowflake\/address-geocode-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 Geocode US &#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\/12771","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=12771"}],"version-history":[{"count":1,"href":"https:\/\/www.serviceobjects.com\/docs\/wp-json\/wp\/v2\/pages\/12771\/revisions"}],"predecessor-version":[{"id":12772,"href":"https:\/\/www.serviceobjects.com\/docs\/wp-json\/wp\/v2\/pages\/12771\/revisions\/12772"}],"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=12771"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}