private_connections

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

Overview

Name	private_connections
Type	Resource
Id	google.datamigration.private_connections

Fields

The following fields are returned by SELECT queries:

get

Successful response

Name	Datatype	Description
name	string	The name of the resource.
createTime	string (google-datetime)	Output only. The create time of the resource.
displayName	string	The private connection display name.
error	object	Output only. The error details in case of state FAILED. (id: Status)
labels	object	The resource labels for private connections to use to annotate any related underlying resources such as Compute Engine VMs. An object containing a list of "key": "value" pairs. Example: { "name": "wrench", "mass": "1.3kg", "count": "3" }.
pscInterfaceConfig	object	PSC Interface configuration. (id: PscInterfaceConfig)
satisfiesPzi	boolean	Output only. Reserved for future use.
satisfiesPzs	boolean	Output only. Reserved for future use.
state	string	Output only. The state of the private connection.
updateTime	string (google-datetime)	Output only. The last update time of the resource.
vpcPeeringConfig	object	VPC peering configuration. (id: VpcPeeringConfig)

list

Successful response

Name	Datatype	Description
name	string	The name of the resource.
createTime	string (google-datetime)	Output only. The create time of the resource.
displayName	string	The private connection display name.
error	object	Output only. The error details in case of state FAILED. (id: Status)
labels	object	The resource labels for private connections to use to annotate any related underlying resources such as Compute Engine VMs. An object containing a list of "key": "value" pairs. Example: { "name": "wrench", "mass": "1.3kg", "count": "3" }.
pscInterfaceConfig	object	PSC Interface configuration. (id: PscInterfaceConfig)
satisfiesPzi	boolean	Output only. Reserved for future use.
satisfiesPzs	boolean	Output only. Reserved for future use.
state	string	Output only. The state of the private connection.
updateTime	string (google-datetime)	Output only. The last update time of the resource.
vpcPeeringConfig	object	VPC peering configuration. (id: VpcPeeringConfig)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	projectsId, locationsId, privateConnectionsId		Gets details of a single private connection.
list	select	projectsId, locationsId	pageSize, pageToken, filter, orderBy	Retrieves a list of private connections in a given project and location.
create	insert	projectsId, locationsId	privateConnectionId, requestId, skipValidation, validateOnly	Creates a new private connection in a given project and location.
delete	delete	projectsId, locationsId, privateConnectionsId	requestId	Deletes a single Database Migration Service private connection.

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.

Name	Datatype	Description
locationsId	string
privateConnectionsId	string
projectsId	string
filter	string
orderBy	string
pageSize	integer (int32)
pageToken	string
privateConnectionId	string
requestId	string
skipValidation	boolean
validateOnly	boolean

SELECT examples

get

Gets details of a single private connection.

SELECT
name,
createTime,
displayName,
error,
labels,
pscInterfaceConfig,
satisfiesPzi,
satisfiesPzs,
state,
updateTime,
vpcPeeringConfig
FROM google.datamigration.private_connections
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND privateConnectionsId = '{{ privateConnectionsId }}' -- required;

list

Retrieves a list of private connections in a given project and location.

SELECT
name,
createTime,
displayName,
error,
labels,
pscInterfaceConfig,
satisfiesPzi,
satisfiesPzs,
state,
updateTime,
vpcPeeringConfig
FROM google.datamigration.private_connections
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
AND filter = '{{ filter }}'
AND orderBy = '{{ orderBy }}';

INSERT examples

create

Creates a new private connection in a given project and location.

INSERT INTO google.datamigration.private_connections (
data__name,
data__labels,
data__displayName,
data__vpcPeeringConfig,
data__pscInterfaceConfig,
projectsId,
locationsId,
privateConnectionId,
requestId,
skipValidation,
validateOnly
)
SELECT 
'{{ name }}',
'{{ labels }}',
'{{ displayName }}',
'{{ vpcPeeringConfig }}',
'{{ pscInterfaceConfig }}',
'{{ projectsId }}',
'{{ locationsId }}',
'{{ privateConnectionId }}',
'{{ requestId }}',
'{{ skipValidation }}',
'{{ validateOnly }}'
RETURNING
name,
done,
error,
metadata,
response
;

Manifest

# Description fields are for documentation purposes
- name: private_connections
  props:
    - name: projectsId
      value: string
      description: Required parameter for the private_connections resource.
    - name: locationsId
      value: string
      description: Required parameter for the private_connections resource.
    - name: name
      value: string
      description: >
        The name of the resource.
        
    - name: labels
      value: object
      description: >
        The resource labels for private connections to use to annotate any related underlying resources such as Compute Engine VMs. An object containing a list of "key": "value" pairs. Example: `{ "name": "wrench", "mass": "1.3kg", "count": "3" }`.
        
    - name: displayName
      value: string
      description: >
        The private connection display name.
        
    - name: vpcPeeringConfig
      value: object
      description: >
        VPC peering configuration.
        
    - name: pscInterfaceConfig
      value: object
      description: >
        PSC Interface configuration.
        
    - name: privateConnectionId
      value: string
    - name: requestId
      value: string
    - name: skipValidation
      value: boolean
    - name: validateOnly
      value: boolean

DELETE examples

delete

Deletes a single Database Migration Service private connection.

DELETE FROM google.datamigration.private_connections
WHERE projectsId = '{{ projectsId }}' --required
AND locationsId = '{{ locationsId }}' --required
AND privateConnectionsId = '{{ privateConnectionsId }}' --required
AND requestId = '{{ requestId }}';