Skip to main content

stable_urls

Creates, updates, deletes, gets or lists a stable_urls resource.

Overview

Namestable_urls
TypeResource
Iddatabricks_account.disasterrecovery.stable_urls

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
namestringFully qualified resource name. Format: accounts/{account_id}/stable-urls/{stable_url_id}.
effective_workspace_idstringThe workspace this stable URL currently routes to. Set to ``initial_workspace_id`` at creation, advanced to the failover group's primary while attached (including across a failover), and preserved when the stable URL is detached from its failover group. Read this to see where an unattached stable URL points: after a failover followed by a detach it reflects the post-failover primary, not ``initial_workspace_id``.
initial_workspace_idstringThe workspace this stable URL is initially bound to. Used only in Create requests to associate the stable URL with a workspace. Not returned in responses.
stable_workspace_idstringThe stable workspace ID for this stable URL. Generated on creation and immutable thereafter; identifies the URL across failovers and is the same value embedded in the ``url`` (as the ``w=`` query parameter for SPOG URLs, or in the ``conn-<id>`` hostname for Private-Link URLs).
failover_group_namestringFully qualified resource name of the FailoverGroup this stable URL is currently linked to, in the format ``accounts/{account_id}/failover-groups/{failover_group_id}``. Empty when the stable URL is not attached to any failover group.
urlstringThe stable URL endpoint. Generated on creation and immutable thereafter. For non-Private-Link workspaces this is ``https://<spog_host>/?w=<connection_id>``. For Private-Link workspaces this is the per-connection hostname.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectparentpage_size, page_tokenList stable URLs for an account.
getselectnameGet a stable URL.
createinsertparent, stable_url_id, stable_urlvalidate_onlyCreate a new stable URL.
deletedeletenameDelete a stable URL.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
namestringThe fully qualified resource name. Format: accounts/{account_id}/stable-urls/{stable_url_id}.
parentstringThe parent resource. Format: accounts/{account_id}.
stable_url_idstringClient-provided identifier for the stable URL. Used to construct the resource name as {parent}/stable-urls/{stable_url_id}.
page_sizeintegerMaximum number of stable URLs to return per page: - when set to a value greater than 0, the page length is the minimum of this value and a server configured value; - when set to 0 or unset, the page length is set to a server configured value (recommended); - when set to a value less than 0, an invalid parameter error is returned.
page_tokenstringPage token received from a previous ListStableUrls call. Provide this to retrieve the subsequent page.
validate_onlybooleanWhen true, validates the request without creating the stable URL.

SELECT examples

List stable URLs for an account.

SELECT
name,
effective_workspace_id,
initial_workspace_id,
stable_workspace_id,
failover_group_name,
url
FROM databricks_account.disasterrecovery.stable_urls
WHERE parent = '{{ parent }}' -- required
AND page_size = '{{ page_size }}'
AND page_token = '{{ page_token }}'
;

INSERT examples

Create a new stable URL.

INSERT INTO databricks_account.disasterrecovery.stable_urls (
stable_url,
parent,
stable_url_id,
validate_only
)
SELECT
'{{ stable_url }}' /* required */,
'{{ parent }}',
'{{ stable_url_id }}',
'{{ validate_only }}'
RETURNING
name,
effective_workspace_id,
initial_workspace_id,
stable_workspace_id,
failover_group_name,
url
;

DELETE examples

Delete a stable URL.

DELETE FROM databricks_account.disasterrecovery.stable_urls
WHERE name = '{{ name }}' --required
;