SEARCH_IP
Searches for valid IPv4 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 you…
Redirecting client connections
Business Critical Feature Requires Business Critical Edition (or higher).
Data Clean Rooms Collaborator is unable to login because IP address is blocked by a Network Policy
CAUSE: This issue occurs when the account or user is governed by a network policy and the policy does not include the source IP addresses of the Data Clean Rooms WebApp. Depending upon the region in question the source IP of the WebApp may…
SHOW <objects>
Lists the existing objects for the specified object type. The output includes metadata for the objects, including: Common properties (name, creation timestamp, owning role, comment, etc.)…
How to audit the IP addresses that have been blocked by a network policy in a Snowflake account
FAQ: To view the IP addresses that have been blocked by a network policy within the Snowflake account, query the LOGIN_HISTORY view, which is located in the SNOWFLAKE database and ACCOUNT_USAGE schema.
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…
SHOW CONNECTIONS
Lists the connections for which you have access privileges. The output returns connection metadata and properties, ordered by connection name (see Output in this topic for descriptions of the output columns).
SHOW IMAGE REPOSITORIES
Lists the image repositories for which you have access privileges. You can use this command to list the repositories in the current database and schema for the session, a specified database or schema, or your entire account.
How to monitor activity from specific IP addresses in your Snowflake account
FAQ: The following views in the SNOWFLAKE.