routes

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

Overview

Name	routes
Type	Resource
Id	google.datastream.routes

Fields

Name	Datatype	Description
name	string	Output only. The resource's name.
createTime	string	Output only. The create time of the resource.
destinationAddress	string	Required. Destination address for connection
destinationPort	integer	Destination port for connection
displayName	string	Required. Display name.
labels	object	Labels.
updateTime	string	Output only. The update time of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	locationsId, privateConnectionsId, projectsId, routesId	Use this method to get details about a route.
list	SELECT	locationsId, privateConnectionsId, projectsId	Use this method to list routes created for a private connectivity configuration in a project and location.
create	INSERT	locationsId, privateConnectionsId, projectsId	Use this method to create a route for a private connectivity configuration in a project and location.
delete	DELETE	locationsId, privateConnectionsId, projectsId, routesId	Use this method to delete a route.

SELECT examples

Use this method to list routes created for a private connectivity configuration in a project and location.

SELECT
name,
createTime,
destinationAddress,
destinationPort,
displayName,
labels,
updateTime
FROM google.datastream.routes
WHERE locationsId = '{{ locationsId }}'
AND privateConnectionsId = '{{ privateConnectionsId }}'
AND projectsId = '{{ projectsId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO google.datastream.routes (
locationsId,
privateConnectionsId,
projectsId,
labels,
displayName,
destinationAddress,
destinationPort
)
SELECT 
'{{ locationsId }}',
'{{ privateConnectionsId }}',
'{{ projectsId }}',
'{{ labels }}',
'{{ displayName }}',
'{{ destinationAddress }}',
'{{ destinationPort }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: name
      value: string
    - name: createTime
      value: string
    - name: updateTime
      value: string
    - name: labels
      value: object
    - name: displayName
      value: string
    - name: destinationAddress
      value: string
    - name: destinationPort
      value: integer

DELETE example

Deletes the specified routes resource.

/*+ delete */
DELETE FROM google.datastream.routes
WHERE locationsId = '{{ locationsId }}'
AND privateConnectionsId = '{{ privateConnectionsId }}'
AND projectsId = '{{ projectsId }}'
AND routesId = '{{ routesId }}';