Network access events system table reference
Preview
This system table is in Public Preview. To access the table, the schema must be enabled in your system
catalog. For more information, see Enable system table schemas.
The network access events table records events where internet access is denied. Each row represents an individual event. For example, if a user attempts to access “google.com” from a notebook and fails, the failure would be logged as an event.
Table path: This system table is located at system.access.outbound_network
.
Network access events system table schema
Column name |
Data type |
Description |
Example |
---|---|---|---|
|
string |
The ID of the Databricks account |
|
|
string |
The ID of the workspace where the event occurred |
|
|
string |
The ID of the event |
|
|
string |
The type of destination. Possible values are |
|
|
string |
Details of the blocked destination. Depending on the destination type, the value could be a domain name, IP address, or storage location. |
|
|
struct |
Details about the DNS destination. Only populates for DNS destinations, otherwise the field is |
|
|
struct |
Details about the IP destination. Only populates for IP destinations, otherwise the field is |
|
|
struct |
Details about the storage destination. Only populates for storage destinations, otherwise the field is |
|
|
timestamp |
Timestamp when the event took place |
|
|
string |
Type of access event that occurred. |
|
Sample queries
The following sample queries help you gain insight into denial logs in your account:
Get all the denial logs for a given workspace for a given time range.
SELECT
event_id, destination_type, destination
COUNT(*) AS destination_count
FROM
system.access.outbound_network
WHERE
event_time > '2024-09-25'
AND event_time < '2024-09-26'
AND account_id = <id>
AND workspace_id = <id>
GROUP BY
destination;
To drill down for a given error
SELECT
storage_event.hostname, storage_event.path, storage_event.rejection_reason
FROM
system.access.outbound_network AS storage_event
WHERE
event_time > '2024-09-25'
AND event_time < '2024-09-26'
AND account_id = <id>
AND workspace_id = <id>
AND destination = 'storage path';