Reference Guide#

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.

2-Step Configuration#

Follow the instruction to get the app and details about installation in Native App Installation

Events and Logs#

To observe and troubleshoot app behavior, you can enable Logging and Event Tracing for your account and share the app logs with us. For more information, please check Snowflake Documentations below:

Stored Procedures#

CHECK_SINGLE_IP#

The CHECK_SINGLE_IP procedure validates and standardizes individual ip components using the Global Ip API. It returns the verification results in JSON format or optional output table, supporting optional fields for flexible and accurate ip validation.

To get started, please contact a sales representative at Snowflakemarketplace@Melissa.com for your License Key.

There are 2 ways to check an ip in Native App Global Ip for Snowflake:

  1. Fill in the Verification Form on the Native App interface

  2. Manually run a Snowflake SQL script to call the stored procedure

Verification Form#

In your Snowflake account, select Data Products > Apps > GLOBAL_IP > Menu > Check Single Ip > Try It Now > Start Checking

Input Example#
  1. Enter the License Key and ip you want to verify

    ../../_images/Snowflake-GlobalIp-Stored-Procedures-Check-Single-Try-Now.png
  2. Select Check

  3. Result will be displayed on the left sidebar

Output Examples#
Check a single ip#

Result will be displayed in JSON format.

../../_images/Snowflake-GlobalIp-Stored-Procedures-Check-Single-Try-Now-Result.png
Check a single ip and insert the result to an output table#

You can choose to insert the result to an output table for later use with our GlobalIp-Snowflake-Reference-Guide-Default-Output-Fields

../../_images/Snowflake-GlobalIp-Stored-Procedures-Check-Single-Try-Now-Default.png
Check a single ip with selected output table fields#

You can choose which fields to be included in the output table.

../../_images/Snowflake-GlobalIp-Stored-Procedures-Check-Single-Try-Now-Selected-Fields.png
Check a single ip with ‘ALL’ output table fields#

You can choose to have All fields to be included in the output table.