SYSTEM$GET_PRIVATELINK_AUTHORIZED_ENDPOINTS¶

Returns a list of the authorized endpoints for your current account to use with private connectivity to the Snowflake service.

The endpoint value in the command output can be used as the value for the aws_id or the private-endpoint-resource-id when using these functions:

Syntax¶

SYSTEM$GET_PRIVATELINK_AUTHORIZED_ENDPOINTS()

Copy

None

Only account administrators (i.e. users with the ACCOUNTADMIN role) can execute this function.
This function can be used with Snowflake accounts on Amazon Web Services (AWS) or Microsoft Azure (Azure); Google Cloud Platform (GCP) is not currently supported.

Return the authorized endpoints for your Snowflake account to use with AWS PrivateLink for your Snowflake account on AWS:

use role accountadmin;
select system$get_privatelink_authorized_endpoints();

Copy

You can optionally use the following command to flatten the query result. For example:

select
  value: endpointId
from
  table(
    flatten(
      input => parse_json(system$get_privatelink_authorized_endpoints())
    )
  );

Copy

Returns (endpoints for a Snowflake account on AWS):

+------------------+
| VALUE:ENDPOINTID |
+------------------+
| "123456789012"   |
+------------------+

Copy