INGRESS_NETWORK_ACCESS_HISTORY view¶

This Account Usage view can be used to query any network access attempts to your Snowflake account within the last 365 days (1 year).

列¶

列名称	数据类型	描述
EVENT_TIMESTAMP	TIMESTAMP_LTZ	Time, (in the UTC time zone) of the ingress event occurrence.
REQUEST_ID	VARCHAR	Ingress request ID.
REQUEST METHOD	VARCHAR.	Ingress request method, such as GET or POST.
REQUEST PATH	VARCHAR	Ingress request path.
USER_NAME	VARCHAR.	与此事件关联的用户。
CLIENT_IP	VARCHAR	Client IP.
CLIENT_PRIVATELINK_ID	VARCHAR	Client private link ID.
BYTES_RX	NUMBER	Bytes transferred into Snowflake.
BYTES_TX	NUMBER	Bytes transferred out of Snowflake.
IS_SUCCESS	BOOLEAN	用户的请求是否成功。
ERROR_CODE	VARCHAR	如果请求不成功，则为错误代码。
ERROR_MESSAGE	VARCHAR	如果请求不成功，则向用户返回错误消息。
JOB_UUID	VARCHAR	Number automatically assigned to a query job.
REQUEST_AUTHORITY	VARCHAR	The URL that a client used to access a Snowflake ingress location.

Although the INTERNAL_STAGE_NETWORK_ACCESS_HISTORY view is user-enabled, the INGRESS_NETWORK_ACCESS_HISTORY view is enabled by default in your Snowflake account.