Quickstart#

Introduction#

Personator™ Consumer: Snowflake powered by Personator Consumer Cloud API provides CASS/DPV certified address verification and optionally leverages comprehensive Consumer data for all-in-one email, phone, name checking, name to address verification, move update, and appending missing information, demographics, enrichments.

Personator Consumer can be used on Snowflake platform to:

  • Verify, Correct, & Standardize names, addresses, phones and emails

  • Retrieve move information

  • Append demographics

  • Append Geographic and Census data

Requirements#

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 Personator Consumer 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 “Personator Consumer” in Snowflake Marketplace.

    ../../_images/Personator-Snowflake-Download-App-Step2.png
  3. Select Get.

    ../../_images/Personator-Snowflake-Download-App-Step3.png
  4. When the app is installed successfully, you can access the app from the left panel of your Snowflake account > Data Products > Apps.

    ../../_images/Personator-Snowflake-Download-App-Step4.png

2-Step Configuration#

  1. Melissa Connection Configuration

  2. Application Configuration

Melissa Connection Configuration#
  1. Click open the app.

  2. In the toolbar, select Settings > Connections > Review.

    ../../_images/Personator-Snowflake-Security-Tab.png
  3. Select Advanced Options > Where do you want to store the network rule?.

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

    ../../_images/Personator-Snowflake-Connection-Advanced-Options.png
  4. Select Connect.

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

    ../../_images/Personator-Snowflake-Connection-Complete.png

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

Application Configuration#
  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.

    ../../_images/Personator-Snowflake-Config-Next.png
  3. A successful message will be on display “Complete initial setup successfully.”.

    ../../_images/Personator-Snowflake-Config-Complete.png

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.

../../_images/Personator-Snowflake-Config-Already-Installed.png

Try It Now#

Checking Form#

  1. In the Native App, select Menu > Check Single Contact > Try It Now > Start Checking.

    ../../_images/Personator-Snowflake-Check-Single-Try-Now.png
  2. Enter the license key and contact information you want to check.

  3. Select Check.

  4. Result will be displayed on the left sidebar.

Output Example#

../../_images/Personator-Snowflake-Check-Single-Try-Now-Output.png