Categories:

System functions (System Information)

SYSTEM$GET_REMOTE_STANDARD_LISTING_STATUS

Returns the status of a listing that you (the provider) have shared with a VPS consumer.

Calling this system function requires a role with the USAGE privilege for the specific listing.

Syntax

SYSTEM$GET_REMOTE_STANDARD_LISTING_STATUS(
  '<listing_name>',
  '<snowflake_region>',
  '<region_group>'
  );

Arguments

listing_name

Specifies the name of the private listing that you shared.

snowflake_region

Specifies the Snowflake Region ID for the VPS that you shared the private listing with.

region_group

Specifies the region group for the VPS that you shared the private listing with.

Returns

The output is similar to this example:

{
  "listingName": "LOCAL_LISTING_3",
  "region": "REG_2",
  "regionGroup": "PUBLIC",
  "shareName": "LISTING_SHARE_3",
  "shareAccount": "SNOWFLAKE_MANAGED$PUBLIC_REG_2",
  "shareAccountAlias": "SNOWFLAKE_MANAGED$PUBLIC_REG_2",
  "shareRefreshedOn": 1665163824,
  "isRefreshSuccessful": true,
  "shareRefreshErrorCode": null,
  "shareRefreshErrorMessage": null,
  "databaseRefreshedOn": 1665163364,
  "isDatabaseRefreshSuccessful": false,
  "databaseRefreshErrorCode": null,
  "databaseRefreshErrorMessage": null,
  "numConsumer": 0,
  "consumerAccounts": []
}

If errors occurred when sharing the listing, the output also returns the latest share and database refresh errors.