Schema:: ACCOUNT_USAGE

EXTERNAL_ACCESS_HISTORY View¶

This Account Usage view can be used to query the history of external access performed by procedure or UDF handler code within the last 365 days (1 year).

Columns¶

Column Name	Data Type	Description
QUERY_ID	TEXT	ID of the query or job that called the UDF or procedure performing external access.
HOSTNAMES	TEXT	Name of the hosts accessed.
STATUS	TEXT	Status of the attempt to connect to the external location. One of the following values: `Success` if the connection was successful `Deny` if the connection was denied
IP	VARCHAR	IP address for the external network location.
SOURCE_CLOUD	TEXT	Name of the cloud provider where the data transfer originated. One of the following: `aws` `gcp` `azure`
SOURCE_REGION	TEXT	Region where the data transfer originated.
TARGET_CLOUD	TEXT	Name of the cloud provider to which the data was sent. One of the following: `aws` `gcp` `azure` `internet` (for regions not on a cloud provider)
TARGET_REGION	TEXT	Region to which the data was sent. `internet` for regions not on a cloud provider.
SENT_BYTES	VARIANT	Number of bytes sent to the external endpoint.
RECEIVED_BYTES	VARIANT	Number of bytes received from the external endpoint.

Usage Notes¶

General notes:

Each row in the view represents a single IP address that the procedure or UDF accesses. As a result, there might be multiple rows with different IP addresses, but with the same query ID. There might also be multiple hostnames mapped to the same IP address.
Latency for the view might be up to 180 minutes (3 hours).