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=
'{
"insight": "{{ insight }}",
"requestId": "{{ requestId }}",
"agentVersion": "{{ agentVersion }}"
}';