Quickstart

Attention

🚧🛠️ Pardon Our Dust! 🛠️🚧

We’re in the process of enhancing our website to provide you with a better experience. While we work diligently, you might notice a few things out of place. Please excuse the temporary mess as we strive to improve our site.

Please contact us at MelissaDocs@Melissa.com if you have any questions.

Introduction

Native App SmartMover: Snowflake powered by SmartMover Cloud API can validate and standardize addresses, detect moves, and provide an updated address for an individual or business.

Native App SmartMover: Snowflake is available for US using data from the USPS.

Native App SmartMover: Snowflake can be used on Snowflake platform to:

• Keep contact addresses from the US and Canada up to date.

• Standardize and validate addresses.

Requirements

Note

A trial account would not be able to use this application at the moment.

A Snowflake account that is eligible for the External Access Integration feature.

Getting Started

Licensing

Please follow the instruction in Register for a Melissa Account Now to get your License Key with Credits.

You can also contact a sales representative at Snowflakemarketplace@Melissa.com or 800-MELISSA ext. 3 (800-635-4772 ext. 3) for any questions about your subscription.

Native App Installation

Step-by-step to install Native App SmartMover for Snowflake:

Get the Native App from Snowflake Marketplace

1. Login to your Snowflake account

2. Get the Native App by using `this direct link <>`_ or manually typing “SmartMover” in Snowflake Marketplace.

3. Select Get

4. When the app is installed successfully, you can access the app from the left panel of your Snowflake account > Data Products > Apps

2-Step Configuration

1. Melissa Connection Configuration

2. Application Configuration

Melissa Connection Configuration

1. Click open the app

2. Select Settings icon in the toolbar

   

3. Select Advanced Options > Where do you want to store the network rule?

   Choose the database, schema that your role has the access control privileges. The new connection will be installed here.

   

4. Select Connect

5. When the connection is created successfully, “Connection Required!” warning will be replaced by our front page.

   

Alternatively, follow the instruction on Snowflake interface to connect to our API endpoints.

Application Configuration

Attention

You will need to do this step again after upgrading to a newer version.

1. Select Application Configuration on the left sidebar of the Menu

2. Select Install. All the neccessary stored procedures will be installed in the application

   

3. A successful message will be on display “Complete initial setup successfully.”

   

When the installation is complete, you can explore on the left sidebar for the app’s features we have to offer.

If you have already completed this step, the Application Configuration page will display a corresponding message.

Try It Now

Verification Form

1. In the Native App, select Menu > Verify Single Address > Try It Now > Start Verifying

   

2. Enter the license key and address you want to verify.

3. Select Verify

4. Result will be displayed on the left sidebar

Output Example