Source
SEARCH_IP
Searches for valid IPv4 and IPv6 addresses in specified character - string columns from one or more tables, including fields in VARIANT, OBJECT, and ARRAY columns. The search is based on a single IP address or a range of IP addresses that…
PARSE_IP
Returns a JSON object consisting of all the components from a valid INET (Internet Protocol) or CIDR (Classless Internet Domain Routing) IPv4 or IPv6 string.
IPLookupService
A lookup service that provides several types of enrichment information for IP addresses. The service is configured by providing a MaxMind Database file and specifying which types of enrichment should be provided for an IP Address or…
Malicious IP Protection
The Malicious IP Protection service continuously detects network access attempts originating from IP addresses maintained on a curated list. The service protects the Snowflake instance by blocking network access attempts that originate…
CURRENT_IP_ADDRESS
Returns the IP address of the client that submitted the request.