Schema:: ORGANIZATION_USAGE

OUTBOUND_PRIVATELINK_ENDPOINTS view¶

Important

This view is only available in the organization account. For more information, see Premium views in the organization account.

This Organization Usage view displays one row for each private endpoint that has been created for outbound private connectivity in an account.

Columns¶

Organization-level columns


Column Name	Data Type	Description
ORGANIZATION_NAME	VARCHAR	Name of the organization.
ACCOUNT_LOCATOR	VARCHAR	System-generated identifier for the account.
ACCOUNT_NAME	VARCHAR	User-defined identifier for the account.

Additional 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: `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_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.
Data for deleted endpoints is retained for 1 year.
For endpoints created during the preview of outbound private connectivity (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.