Skip to main content

private_network_gateways

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

Overview​

Nameprivate_network_gateways
TypeResource
Iddatabricks_account.networking.private_network_gateways

Fields​

The following fields are returned by SELECT queries:

NameDatatypeDescription
namestringThe canonical resource name of the gateway, in the form ``accounts/{account_id}/network-connectivity-configs/{ncc_id}/private-network-gateways/{gateway_id}``.
display_namestringThe human-readable name of the gateway.
â–¶aws_cloud_connectionobjectThe AWS connection used by the gateway.
â–¶azure_cloud_connectionobjectThe Azure connection used by the gateway.
bandwidth_tier_gigabits_per_secondintegerThe provisioned bandwidth tier for an Azure gateway, in gigabits per second. Required when creating an Azure gateway.
create_timestring (date-time)The time when the gateway was created.
â–¶destinationsarrayThe destinations routed through this gateway.
error_messagestringThe failure reason when the gateway is in the FAILED state.
â–¶private_dns_resolversarrayThe DNS resolvers used for private name resolution.
statestringThe current lifecycle state of the gateway. (CREATING, DELETING, ESTABLISHED, FAILED)
traffic_modestringThe traffic routed through this gateway. (ALL_TRAFFIC, SPECIFIC_DESTINATIONS)
update_timestring (date-time)The time when the gateway was last updated.

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectaccount_id, ncc_id, gateway_id, account_hostGets a private network gateway.
listselectaccount_id, ncc_id, account_hostpage_tokenLists private network gateways under a network connectivity configuration.
createinsertaccount_id, ncc_id, account_host, display_name, traffic_moderequest_idCreates a private network gateway.
updateupdateaccount_id, ncc_id, gateway_id, update_mask, account_host, display_name, traffic_modeUpdates a private network gateway.
deletedeleteaccount_id, ncc_id, gateway_id, account_hostPermanently deletes a private network gateway.

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
account_hoststringThe Databricks account console host. Selected by DATABRICKS_CLOUD (aws, azure or gcp; default aws), or set explicitly with DATABRICKS_ACCOUNT_HOST (bare host, no scheme). (default: accounts.cloud.databricks.com, x-stackQL-envVar: DATABRICKS_ACCOUNT_HOST, x-stackQL-envVarSelector: {"envVar":"DATABRICKS_CLOUD","default":"aws","values":{"aws":"accounts.cloud.databricks.com","azure":"accounts.azuredatabricks.net","gcp":"accounts.gcp.databricks.com"}})
account_idstringThe account_id segment of the name resource name (accounts/{account_id}/network-connectivity-configs/{ncc_id}/private-network-gateways/{gateway_id}). The canonical resource name of the gateway.
gateway_idstringThe gateway_id segment of the name resource name (accounts/{account_id}/network-connectivity-configs/{ncc_id}/private-network-gateways/{gateway_id}). The canonical resource name of the gateway.
ncc_idstringThe ncc_id segment of the name resource name (accounts/{account_id}/network-connectivity-configs/{ncc_id}/private-network-gateways/{gateway_id}). The canonical resource name of the gateway.
update_maskobjectThe fields to update.
page_tokenstringAn opaque token returned by a previous list request.
request_idstringA unique identifier for this request. The request is idempotent when this is provided.

SELECT examples​

Gets a private network gateway.

SELECT
name,
display_name,
aws_cloud_connection,
azure_cloud_connection,
bandwidth_tier_gigabits_per_second,
create_time,
destinations,
error_message,
private_dns_resolvers,
state,
traffic_mode,
update_time
FROM databricks_account.networking.private_network_gateways
WHERE account_id = '{{ account_id }}' -- required
AND ncc_id = '{{ ncc_id }}' -- required
AND gateway_id = '{{ gateway_id }}' -- required
AND account_host = '{{ account_host }}' -- required
;

INSERT examples​

Creates a private network gateway.

INSERT INTO databricks_account.networking.private_network_gateways (
display_name,
traffic_mode,
aws_cloud_connection,
azure_cloud_connection,
bandwidth_tier_gigabits_per_second,
create_time,
destinations,
error_message,
name,
private_dns_resolvers,
state,
update_time,
account_id,
ncc_id,
account_host,
request_id
)
SELECT
'{{ display_name }}' /* required */,
'{{ traffic_mode }}' /* required */,
'{{ aws_cloud_connection }}',
'{{ azure_cloud_connection }}',
{{ bandwidth_tier_gigabits_per_second }},
'{{ create_time }}',
'{{ destinations }}',
'{{ error_message }}',
'{{ name }}',
'{{ private_dns_resolvers }}',
'{{ state }}',
'{{ update_time }}',
'{{ account_id }}',
'{{ ncc_id }}',
'{{ account_host }}',
'{{ request_id }}'
;

UPDATE examples​

Updates a private network gateway.

UPDATE databricks_account.networking.private_network_gateways
SET
display_name = '{{ display_name }}',
traffic_mode = '{{ traffic_mode }}',
aws_cloud_connection = '{{ aws_cloud_connection }}',
azure_cloud_connection = '{{ azure_cloud_connection }}',
bandwidth_tier_gigabits_per_second = {{ bandwidth_tier_gigabits_per_second }},
create_time = '{{ create_time }}',
destinations = '{{ destinations }}',
error_message = '{{ error_message }}',
name = '{{ name }}',
private_dns_resolvers = '{{ private_dns_resolvers }}',
state = '{{ state }}',
update_time = '{{ update_time }}'
WHERE
account_id = '{{ account_id }}' --required
AND ncc_id = '{{ ncc_id }}' --required
AND gateway_id = '{{ gateway_id }}' --required
AND update_mask = '{{ update_mask }}' --required
AND account_host = '{{ account_host }}' --required
AND display_name = '{{ display_name }}' --required
AND traffic_mode = '{{ traffic_mode }}' --required
RETURNING
name,
display_name,
aws_cloud_connection,
azure_cloud_connection,
bandwidth_tier_gigabits_per_second,
create_time,
destinations,
error_message,
private_dns_resolvers,
state,
traffic_mode,
update_time;

DELETE examples​

Permanently deletes a private network gateway.

DELETE FROM databricks_account.networking.private_network_gateways
WHERE account_id = '{{ account_id }}' --required
AND ncc_id = '{{ ncc_id }}' --required
AND gateway_id = '{{ gateway_id }}' --required
AND account_host = '{{ account_host }}' --required
;