evaluations

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

Overview

Name	evaluations
Type	Resource
Id	google.workloadmanager.evaluations

Fields

The following fields are returned by SELECT queries:

get

Successful response

Name	Datatype	Description
name	string	name of resource names have the form 'projects/{project_id}/locations/{location_id}/evaluations/{evaluation_id}'
bigQueryDestination	object	Optional. BigQuery destination (id: BigQueryDestination)
createTime	string (google-datetime)	Output only. [Output only] Create time stamp
customRulesBucket	string	The Cloud Storage bucket name for custom rules.
description	string	Description of the Evaluation
evaluationType	string	Evaluation type
kmsKey	string	Optional. Immutable. Customer-managed encryption key name, in the format projects//locations//keyRings//cryptoKeys/.
labels	object	Labels as key value pairs
resourceFilter	object	annotations as key value pairs (id: ResourceFilter)
resourceStatus	object	Output only. [Output only] The updated rule ids if exist. (id: ResourceStatus)
ruleNames	array	the name of the rule
ruleVersions	array	Output only. [Output only] The updated rule ids if exist.
schedule	string	crontab format schedule for scheduled evaluation, currently only support the following schedule: "0 */1 * * *", "0 */6 * * *", "0 */12 * * *", "0 0 */1 * *", "0 0 */7 * *",
updateTime	string (google-datetime)	Output only. [Output only] Update time stamp

list

Successful response

Name	Datatype	Description
name	string	name of resource names have the form 'projects/{project_id}/locations/{location_id}/evaluations/{evaluation_id}'
bigQueryDestination	object	Optional. BigQuery destination (id: BigQueryDestination)
createTime	string (google-datetime)	Output only. [Output only] Create time stamp
customRulesBucket	string	The Cloud Storage bucket name for custom rules.
description	string	Description of the Evaluation
evaluationType	string	Evaluation type
kmsKey	string	Optional. Immutable. Customer-managed encryption key name, in the format projects//locations//keyRings//cryptoKeys/.
labels	object	Labels as key value pairs
resourceFilter	object	annotations as key value pairs (id: ResourceFilter)
resourceStatus	object	Output only. [Output only] The updated rule ids if exist. (id: ResourceStatus)
ruleNames	array	the name of the rule
ruleVersions	array	Output only. [Output only] The updated rule ids if exist.
schedule	string	crontab format schedule for scheduled evaluation, currently only support the following schedule: "0 */1 * * *", "0 */6 * * *", "0 */12 * * *", "0 0 */1 * *", "0 0 */7 * *",
updateTime	string (google-datetime)	Output only. [Output only] Update time stamp

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	projectsId, locationsId, evaluationsId		Gets details of a single Evaluation.
list	select	projectsId, locationsId	pageSize, pageToken, filter, orderBy	Lists Evaluations in a given project and location.
create	insert	projectsId, locationsId	evaluationId, requestId	Creates a new Evaluation in a given project and location.
delete	delete	projectsId, locationsId, evaluationsId	requestId, force	Deletes a single Evaluation.

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
evaluationsId	string
locationsId	string
projectsId	string
evaluationId	string
filter	string
force	boolean
orderBy	string
pageSize	integer (int32)
pageToken	string
requestId	string

SELECT examples

get

Gets details of a single Evaluation.

SELECT
name,
bigQueryDestination,
createTime,
customRulesBucket,
description,
evaluationType,
kmsKey,
labels,
resourceFilter,
resourceStatus,
ruleNames,
ruleVersions,
schedule,
updateTime
FROM google.workloadmanager.evaluations
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND evaluationsId = '{{ evaluationsId }}' -- required;

list

Lists Evaluations in a given project and location.

SELECT
name,
bigQueryDestination,
createTime,
customRulesBucket,
description,
evaluationType,
kmsKey,
labels,
resourceFilter,
resourceStatus,
ruleNames,
ruleVersions,
schedule,
updateTime
FROM google.workloadmanager.evaluations
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
AND filter = '{{ filter }}'
AND orderBy = '{{ orderBy }}';

INSERT examples

create

Creates a new Evaluation in a given project and location.

INSERT INTO google.workloadmanager.evaluations (
data__name,
data__description,
data__resourceFilter,
data__ruleNames,
data__labels,
data__schedule,
data__customRulesBucket,
data__evaluationType,
data__bigQueryDestination,
data__kmsKey,
projectsId,
locationsId,
evaluationId,
requestId
)
SELECT 
'{{ name }}',
'{{ description }}',
'{{ resourceFilter }}',
'{{ ruleNames }}',
'{{ labels }}',
'{{ schedule }}',
'{{ customRulesBucket }}',
'{{ evaluationType }}',
'{{ bigQueryDestination }}',
'{{ kmsKey }}',
'{{ projectsId }}',
'{{ locationsId }}',
'{{ evaluationId }}',
'{{ requestId }}'
RETURNING
name,
done,
error,
metadata,
response
;

Manifest

# Description fields are for documentation purposes
- name: evaluations
  props:
    - name: projectsId
      value: string
      description: Required parameter for the evaluations resource.
    - name: locationsId
      value: string
      description: Required parameter for the evaluations resource.
    - name: name
      value: string
      description: >
        name of resource names have the form 'projects/{project_id}/locations/{location_id}/evaluations/{evaluation_id}'
        
    - name: description
      value: string
      description: >
        Description of the Evaluation
        
    - name: resourceFilter
      value: object
      description: >
        annotations as key value pairs
        
    - name: ruleNames
      value: array
      description: >
        the name of the rule
        
    - name: labels
      value: object
      description: >
        Labels as key value pairs
        
    - name: schedule
      value: string
      description: >
        crontab format schedule for scheduled evaluation, currently only support the following schedule: "0 */1 * * *", "0 */6 * * *", "0 */12 * * *", "0 0 */1 * *", "0 0 */7 * *",
        
    - name: customRulesBucket
      value: string
      description: >
        The Cloud Storage bucket name for custom rules.
        
    - name: evaluationType
      value: string
      description: >
        Evaluation type
        
      valid_values: ['EVALUATION_TYPE_UNSPECIFIED', 'SAP', 'SQL_SERVER', 'OTHER', 'SCC_IAC']
    - name: bigQueryDestination
      value: object
      description: >
        Optional. BigQuery destination
        
    - name: kmsKey
      value: string
      description: >
        Optional. Immutable. Customer-managed encryption key name, in the format projects/*/locations/*/keyRings/*/cryptoKeys/*.
        
    - name: evaluationId
      value: string
    - name: requestId
      value: string

DELETE examples

delete

Deletes a single Evaluation.

DELETE FROM google.workloadmanager.evaluations
WHERE projectsId = '{{ projectsId }}' --required
AND locationsId = '{{ locationsId }}' --required
AND evaluationsId = '{{ evaluationsId }}' --required
AND requestId = '{{ requestId }}'
AND force = '{{ force }}';