- Schema:
OUTBOUND_PRIVATELINK_ENDPOINTS view¶
This Account Usage view displays one row for each private endpoint that has been created for outbound private connectivity.
Columns¶
Column Name |
Data Type |
Description |
---|---|---|
PROVIDER_RESOURCE_ID |
VARCHAR |
Identifier of the AWS service or the Microsoft Azure resource that the endpoint connects to. |
HOSTNAME |
VARCHAR |
Hostname of the AWS service or Microsoft Azure resource that the endpoint connects to. |
SUBRESOURCE |
VARCHAR |
Subresource of the Microsoft Azure resource that the endpoint connects to. Endpoints for AWS do not have a subresource. |
SNOWFLAKE_RESOURCE_ID |
VARCHAR |
Identifier of the private endpoint that connects to the AWS service or Microsoft Azure resource. For AWS, this is the VPCE_ID of the endpoint. For Microsoft Azure, this is the resource ID of the endpoint. |
ENDPOINT_STATE |
VARCHAR |
Current state of the endpoint. One of the following:
|
CREATED_ON |
TIMESTAMP_LTZ |
Date and time when the endpoint was created. |
LAST_ALTERED_ON |
TIMESTAMP_LTZ |
Date and time when the endpoint state last changed. |
DELETED_ON |
TIMESTAMP_LTZ |
Date and time when the endpoint was deleted. NULL if an endpoint has not been deleted, including deprovisioned endpoints that haven’t been deleted yet. |
Usage notes¶
Latency for this view might be up to 2 hours.
Users with the SECURITY_VIEWER database role can access this view.
Data for deleted endpoints is retained for 1 year.
For endpoints created during the preview of the outbound private connectivity feature (before November 2024), values in the LAST_ALTERED_ON column might be the time at which the data became available in the OUTBOUND_PRIVATELINK_ENDPOINTS view, not the creation times of the endpoints.