Skip to main content

insights

Creates, updates, deletes, gets or lists an insights resource.

Overview​

Nameinsights
TypeResource
Idgoogle.workloadmanager.insights

Fields​

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
deletedeleteprojectsId, locationsId, insightsIdrequestIdDelete the data insights from workload manager data warehouse.
write_insightexecprojectsId, locationsIdWrite the data insights to workload manager data warehouse.

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.

NameDatatypeDescription
insightsIdstring
locationsIdstring
projectsIdstring
requestIdstring

DELETE examples​

Delete the data insights from workload manager data warehouse.

DELETE FROM google.workloadmanager.insights
WHERE projectsId = '{{ projectsId }}' --required
AND locationsId = '{{ locationsId }}' --required
AND insightsId = '{{ insightsId }}' --required
AND requestId = '{{ requestId }}'
;

Lifecycle Methods​

Write the data insights to workload manager data warehouse.

EXEC google.workloadmanager.insights.write_insight
@projectsId='{{ projectsId }}' --required,
@locationsId='{{ locationsId }}' --required
@@json=
'{
"agentVersion": "{{ agentVersion }}",
"insight": "{{ insight }}",
"requestId": "{{ requestId }}"
}'
;