goldengate_connection_assignments

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

Overview

Name	goldengate_connection_assignments
Type	Resource
Id	google.oracledatabase.goldengate_connection_assignments

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
name	string	Identifier. The name of the GoldengateConnectionAssignment resource in the following format: projects/{project}/locations/{region}/goldengateConnectionAssignments/{goldengate_connection_assignment}
createTime	string (google-datetime)	Output only. The time when the connection assignment was created.
displayName	string	Optional. The display name for the GoldengateConnectionAssignment.
entitlementId	string	Output only. The OCID of the entitlement linked to this resource.
labels	object	Optional. The labels or tags associated with the GoldengateConnectionAssignment.
properties	object	Required. The properties of the GoldengateConnectionAssignment. (id: GoldengateConnectionAssignmentProperties)

list

Name	Datatype	Description
name	string	Identifier. The name of the GoldengateConnectionAssignment resource in the following format: projects/{project}/locations/{region}/goldengateConnectionAssignments/{goldengate_connection_assignment}
createTime	string (google-datetime)	Output only. The time when the connection assignment was created.
displayName	string	Optional. The display name for the GoldengateConnectionAssignment.
entitlementId	string	Output only. The OCID of the entitlement linked to this resource.
labels	object	Optional. The labels or tags associated with the GoldengateConnectionAssignment.
properties	object	Required. The properties of the GoldengateConnectionAssignment. (id: GoldengateConnectionAssignmentProperties)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	projectsId, locationsId, goldengateConnectionAssignmentsId		Gets details of a single GoldengateConnectionAssignment.
list	select	projectsId, locationsId	filter, pageToken, pageSize, orderBy	Lists GoldengateConnectionAssignments in a given project and location.
create	insert	projectsId, locationsId	goldengateConnectionAssignmentId, requestId	Creates a new GoldengateConnectionAssignment in a given project and location.
delete	delete	projectsId, locationsId, goldengateConnectionAssignmentsId	requestId	Deletes a single GoldengateConnectionAssignment.
test	exec	projectsId, locationsId, goldengateConnectionAssignmentsId		Tests a single GoldengateConnectionAssignment.

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
goldengateConnectionAssignmentsId	string
locationsId	string
projectsId	string
filter	string
goldengateConnectionAssignmentId	string
orderBy	string
pageSize	integer (int32)
pageToken	string
requestId	string

SELECT examples

get

Gets details of a single GoldengateConnectionAssignment.

SELECT
name,
createTime,
displayName,
entitlementId,
labels,
properties
FROM google.oracledatabase.goldengate_connection_assignments
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND goldengateConnectionAssignmentsId = '{{ goldengateConnectionAssignmentsId }}' -- required
;

list

Lists GoldengateConnectionAssignments in a given project and location.

SELECT
name,
createTime,
displayName,
entitlementId,
labels,
properties
FROM google.oracledatabase.goldengate_connection_assignments
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND filter = '{{ filter }}'
AND pageToken = '{{ pageToken }}'
AND pageSize = '{{ pageSize }}'
AND orderBy = '{{ orderBy }}'
;

INSERT examples

create

Creates a new GoldengateConnectionAssignment in a given project and location.

INSERT INTO google.oracledatabase.goldengate_connection_assignments (
data__displayName,
data__properties,
data__name,
data__labels,
projectsId,
locationsId,
goldengateConnectionAssignmentId,
requestId
)
SELECT 
'{{ displayName }}',
'{{ properties }}',
'{{ name }}',
'{{ labels }}',
'{{ projectsId }}',
'{{ locationsId }}',
'{{ goldengateConnectionAssignmentId }}',
'{{ requestId }}'
RETURNING
name,
done,
error,
metadata,
response
;

Manifest

# Description fields are for documentation purposes
- name: goldengate_connection_assignments
props:
  - name: projectsId
    value: "{{ projectsId }}"
    description: Required parameter for the goldengate_connection_assignments resource.
  - name: locationsId
    value: "{{ locationsId }}"
    description: Required parameter for the goldengate_connection_assignments resource.
  - name: displayName
    value: "{{ displayName }}"
    description: |
      Optional. The display name for the GoldengateConnectionAssignment.
  - name: properties
    description: |
      Required. The properties of the GoldengateConnectionAssignment.
    value:
      ocid: "{{ ocid }}"
      goldengateConnection: "{{ goldengateConnection }}"
      state: "{{ state }}"
      goldengateDeployment: "{{ goldengateDeployment }}"
      alias: "{{ alias }}"
  - name: name
    value: "{{ name }}"
    description: |
      Identifier. The name of the GoldengateConnectionAssignment resource in the following format: projects/{project}/locations/{region}/goldengateConnectionAssignments/{goldengate_connection_assignment}
  - name: labels
    value: "{{ labels }}"
    description: |
      Optional. The labels or tags associated with the GoldengateConnectionAssignment.
  - name: goldengateConnectionAssignmentId
    value: "{{ goldengateConnectionAssignmentId }}"
  - name: requestId
    value: "{{ requestId }}"

DELETE examples

delete

Deletes a single GoldengateConnectionAssignment.

DELETE FROM google.oracledatabase.goldengate_connection_assignments
WHERE projectsId = '{{ projectsId }}' --required
AND locationsId = '{{ locationsId }}' --required
AND goldengateConnectionAssignmentsId = '{{ goldengateConnectionAssignmentsId }}' --required
AND requestId = '{{ requestId }}'
;

Lifecycle Methods

test

Tests a single GoldengateConnectionAssignment.

EXEC google.oracledatabase.goldengate_connection_assignments.test 
@projectsId='{{ projectsId }}' --required, 
@locationsId='{{ locationsId }}' --required, 
@goldengateConnectionAssignmentsId='{{ goldengateConnectionAssignmentsId }}' --required 
@@json=
'{
"type": "{{ type }}"
}'
;