Skip to main content

connections

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

Overview

Nameconnections
TypeResource
Idgoogle.servicenetworking.connections

Fields

NameDatatypeDescription
connectionsarrayThe list of Connections.

Methods

NameAccessible byRequired ParamsDescription
listSELECTservicesIdList the private connections that are configured in a service consumer's VPC network.
createINSERTservicesIdCreates a private connection that establishes a VPC Network Peering connection to a VPC network in the service producer's organization. The administrator of the service consumer's VPC network invokes this method. The administrator must assign one or more allocated IP ranges for provisioning subnetworks in the service producer's VPC network. This connection is used for all supported services in the service producer's organization, so it only needs to be invoked once.
patchUPDATEconnectionsId, servicesIdUpdates the allocated ranges that are assigned to a connection.

SELECT examples

List the private connections that are configured in a service consumer's VPC network.

SELECT
connections
FROM google.servicenetworking.connections
WHERE servicesId = '{{ servicesId }}';

INSERT example

Use the following StackQL query and manifest file to create a new connections resource.

/*+ create */
INSERT INTO google.servicenetworking.connections (
servicesId,
network,
reservedPeeringRanges
)
SELECT
'{{ servicesId }}',
'{{ network }}',
'{{ reservedPeeringRanges }}'
;

UPDATE example

Updates a connections resource.

/*+ update */
UPDATE google.servicenetworking.connections
SET
network = '{{ network }}',
reservedPeeringRanges = '{{ reservedPeeringRanges }}'
WHERE
connectionsId = '{{ connectionsId }}'
AND servicesId = '{{ servicesId }}';