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:
Fill in the Verification Form on the Native App interface
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#
Enter the License Key and ip you want to verify
Select Check
Result will be displayed on the left sidebar
Output Examples#
Check a single ip#
Result will be displayed in JSON format.
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
Check a single ip with selected output table fields#
You can choose which fields to be included in the output table.
Check a single ip with ‘ALL’ output table fields#
You can choose to have All fields to be included in the output table.