4 Steps to Transform Your Address Data in Snowflake with the Precisely Geo Addressing Native App

Address data: it’s packed with potential for data-driven decision-making, but it’s also one of the most challenging types of data to get right.

Think about the use cases for address data within your organization – whether you rely on it to streamline logistics, conduct accurate risk assessments, or enrich datasets to fuel advanced analytics, it’s critical that your addresses are clean, accurate, and standardized.

Historically, getting your addresses to consistently meet these standards has been a challenge. But the good news? It’s now easier than ever within Snowflake – using  the Precisely Geo Addressing Native App.

With easy access from your Snowflake account, this app is a game-changer. You’re able to:

• transform raw address data into standardized, enriched, and actionable insights directly within your Snowflake environment
• simplify complex workflows – so you can effortlessly validate, geocode, and enrich address data at scale

Our team is incredibly energized about this development in our partnership with Snowflake, and I want to walk you through exactly how to make the most of this new app.

You’ll discover how to:

• set up the Precisely Geo Addressing Native App in Snowflake
• geocode and verify addresses
• unlock powerful integration capabilities with other datasets with the PreciselyID, our unique identifier

Ready to maximize your address data’s potential? Let’s get started!

Step 1: Set Up Snowflake

To get started, ensure you have access to a Snowflake account. If you don’t already have one, you can sign up for a free trial here. Snowflake provides a powerful platform to host and process data, and it’s the foundation for running the Precisely Geo Addressing Native App.

Step 2: Install the Precisely Geo Addressing Native App from Snowflake Marketplace

The Precisely Geo Addressing Native App is available through the Snowflake Marketplace. Follow these steps to install it:

1. Log in to your Snowflake account and navigate to the Snowsight UI.
2. On the left-hand menu, select Data Products > Marketplace.
3. In the Marketplace search bar, type “Precisely Geo Addressing” and locate the app.

Note: You’ll need to use an ACCOUNTADMIN role (or a role with similar permissions) to install apps from the Marketplace.

Snowflake Marketplace

4. Click on the app to view details and initiate the installation process.
5. Click Get to begin the installation.
6. Select a warehouse for the installation. The default warehouse is typically fine, but you can choose a different warehouse if necessary.
7. Optionally, customize the app name or default warehouse:

• Default name: ‘Geo_Addressing’
• Default warehouse: (leave as is or modify)

8. Click Getagain to confirm and complete the installation.

Installing Precisely Geo Addressing App from Snowflake Marketplace

Installing Precisely Geo Addressing App from Snowflake MarketplaceAfter installation, activate the app and grant it privileges. Once installed, you’re ready to launch it.

 Step 3: Ready to Geocode Addresses

Once you launch the Precisely Geo Addressing App, you’ll receive a sample Snowflake worksheet with examples for the following services:

1. Geocode Address
   Performs forward geocoding using input addresses and returns location data along with other relevant information. Location data in this application refers to the latitude and longitude coordinates for the address.
2. Verify Address
   Verifies and standardizes addresses using the specified processing engine: verifying whether an address is USPS deliverable, and standardizing the input address to match USPS format.
3. Reverse Geocode
   Performs reverse geocoding using input coordinates to return the best matching address for that point.

Syntax for Geocoding an Address

To geocode an address using the app, use the following syntax:

Where:

• ADDRESS and COUNTRY: Column names from your address table. Replace these with the actual column names from your table.
• <APP-NAME>: The name assigned to the app during installation in Step 2. If you didn’t assign a custom name, use the default name: GEO_ADDRESSING.
• <ADDRESS_TABLE_NAME>: Replace this with the name of your address table.

Example Query

Here’s an example of a query to geocode an address directly:

This query returns the geocoded location data for the given address in JSON.

Flattening the JSON Output

To make the geocoded data easier to work with, you can flatten the JSON and extract specific fields – like street name, city, state, and postal code.

Here’s an example query to flatten the JSON and extract key details:

This command will flatten the JSON response, and the output should look something like this:

Step 4: Supercharge Your Address Data with the Power of PreciselyID

One of the most powerful features of the Precisely Geo Addressing App is the inclusion of the PreciselyID in geocoded results. The PreciselyID is a unique and persistent identifier that unlocks the potential to enrich your location data with additional insights and analytics.

What Can PreciselyID do?

Imagine you have a dataset of homes in San Francisco, and you want to assess the wildfire risk for each property. With the PreciselyID, you can easily join your address data with enrichment data available in the Snowflake Marketplace, such as the Precisely Wildfire Risk dataset.

How to enrich address data with wildfire attributes using PreciselyID

First, download the Precisely Wildfire Risk dataset from the Snowflake Marketplace. Once added to your Snowflake environment, it behaves like any other table in your database, making it simple to integrate.

Once I have this dataset ready, I can query it as any other database. Here, I am enriching my geocoded addresses with wildfire attributes via a join on PBKEY or PreciselyID.

What this query does

• Joins on PreciselyID: Matches your geocoded address data (GEOCODED_ADDRESSES) with the wildfire risk data (wfr_ge_usa) using the common field PreciselyID (referred to as PBKEY in the wildfire dataset).
• Retrieves key insights: Combines clean address components (e.g., street, city, postal code) with wildfire-specific attributes like WILDFIRE_RISK_LEVEL and RISK_SCORE.
• Enables advanced analytics: With this enriched data, you can perform detailed risk analysis, visualization, and decision-making.

Why this matters

The ability to seamlessly integrate hundreds of datasets using the PreciselyID simplifies complex workflows. Whether you’re analyzing wildfire risks, crime rates, or points of interest, PreciselyID ensures you can enrich your data and uncover actionable insights with just a single join.

Make Better Data-Driven Decisions with Confidence

Transforming your address data within Snowflake is easier than ever, thanks to the Precisely Geo Addressing Native App.

You can unlock deeper insights and integrate high-quality address data seamlessly into your workflows by leveraging its powerful geocoding, verification, and enrichment capabilities — along with the PreciselyID.

That means you can make data-driven decisions with confidence – whether you’re training machine learning models, enhancing logistics, assessing risk, or enriching datasets with third-party data.

Elevate your location intelligence within Snowflake with the Precisely Geo Addressing Native App – get started today!