Skip to main content

processes

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

Overview

Nameprocesses
TypeResource
Idgoogle.datalineage.processes

Fields

NameDatatypeDescription
namestringImmutable. The resource name of the lineage process. Format: projects/{project}/locations/{location}/processes/{process}. Can be specified or auto-assigned. {process} must be not longer than 200 characters and only contain characters in a set: a-zA-Z0-9_-:.
attributesobjectOptional. The attributes of the process. Should only be used for the purpose of non-semantic management (classifying, describing or labeling the process). Up to 100 attributes are allowed.
displayNamestringOptional. A human-readable name you can set to display in a user interface. Must be not longer than 200 characters and only contain UTF-8 letters or numbers, spaces or characters like _-:&.
originobjectOrigin of a process.

Methods

NameAccessible byRequired ParamsDescription
getSELECTlocationsId, processesId, projectsIdGets the details of the specified process.
listSELECTlocationsId, projectsIdList processes in the given project and location. List order is descending by insertion time.
createINSERTlocationsId, projectsIdCreates a new process.
deleteDELETElocationsId, processesId, projectsIdDeletes the process with the specified name.
patchUPDATElocationsId, processesId, projectsIdUpdates a process.

SELECT examples

List processes in the given project and location. List order is descending by insertion time.

SELECT
name,
attributes,
displayName,
origin
FROM google.datalineage.processes
WHERE locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';

INSERT example

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

/*+ create */
INSERT INTO google.datalineage.processes (
locationsId,
projectsId,
name,
attributes,
displayName,
origin
)
SELECT
'{{ locationsId }}',
'{{ projectsId }}',
'{{ name }}',
'{{ attributes }}',
'{{ displayName }}',
'{{ origin }}'
;

UPDATE example

Updates a processes resource.

/*+ update */
UPDATE google.datalineage.processes
SET
name = '{{ name }}',
attributes = '{{ attributes }}',
displayName = '{{ displayName }}',
origin = '{{ origin }}'
WHERE
locationsId = '{{ locationsId }}'
AND processesId = '{{ processesId }}'
AND projectsId = '{{ projectsId }}';

DELETE example

Deletes the specified processes resource.

/*+ delete */
DELETE FROM google.datalineage.processes
WHERE locationsId = '{{ locationsId }}'
AND processesId = '{{ processesId }}'
AND projectsId = '{{ projectsId }}';