Schema:

ACCOUNT_USAGE

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 NameData TypeDescription
PROVIDER_RESOURCE_IDVARCHARIdentifier of the AWS service or the Microsoft Azure resource that the endpoint connects to.
HOSTNAMEVARCHARHostname of the AWS service or Microsoft Azure resource that the endpoint connects to.
SUBRESOURCEVARCHARSubresource of the Microsoft Azure resource that the endpoint connects to. Endpoints for AWS do not have a subresource.
SNOWFLAKE_RESOURCE_IDVARCHARIdentifier 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_STATEVARCHAR

Current state of the endpoint. One of the following:

  • PENDING_CREATION: The endpoint is still being created.
  • CREATED: The endpoint is created and ready to use. This state indicates that Snowflake received a response from the cloud provider about the endpoint being successfully created.
  • FAILED: The endpoint is in an unexpected state on the cloud provider, and cannot be used.
  • PENDING_DELETION: The endpoint is on the deletion queue, but can be restored.
  • DELETING: The endpoint is being deleted on the cloud provider and cannot be restored.
CREATED_ONTIMESTAMP_LTZDate and time when the endpoint was created.
LAST_ALTERED_ONTIMESTAMP_LTZDate and time when the endpoint state last changed.
DELETED_ONTIMESTAMP_LTZDate 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.