saved_queries

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

Overview

Name	saved_queries
Type	Resource
Id	google.cloudasset.saved_queries

Fields

The following fields are returned by SELECT queries:

list

Name	Datatype	Description
name	string	The resource name of the saved query. The format must be: * projects/project_number/savedQueries/saved_query_id * folders/folder_number/savedQueries/saved_query_id * organizations/organization_number/savedQueries/saved_query_id
content	object	The query content. (id: QueryContent)
createTime	string (google-datetime)	Output only. The create time of this saved query.
creator	string	Output only. The account's email address who has created this saved query.
description	string	The description of this saved query. This value should be fewer than 255 characters.
labels	object	Labels applied on the resource. This value should not contain more than 10 entries. The key and value of each entry must be non-empty and fewer than 64 characters.
lastUpdateTime	string (google-datetime)	Output only. The last update time of this saved query.
lastUpdater	string	Output only. The account's email address who has updated this saved query most recently.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	parentType, parent	filter, pageSize, pageToken	Lists all saved queries in a parent project/folder/organization.
create	insert	parentType, parent	savedQueryId	Creates a saved query in a parent project/folder/organization.

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
parent	string
parentType	string
filter	string
pageSize	integer (int32)
pageToken	string
savedQueryId	string

SELECT examples

list

Lists all saved queries in a parent project/folder/organization.

SELECT
name,
content,
createTime,
creator,
description,
labels,
lastUpdateTime,
lastUpdater
FROM google.cloudasset.saved_queries
WHERE parentType = '{{ parentType }}' -- required
AND parent = '{{ parent }}' -- required
AND filter = '{{ filter }}'
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
;

INSERT examples

create

Creates a saved query in a parent project/folder/organization.

INSERT INTO google.cloudasset.saved_queries (
data__content,
data__description,
data__labels,
data__name,
parentType,
parent,
savedQueryId
)
SELECT 
'{{ content }}',
'{{ description }}',
'{{ labels }}',
'{{ name }}',
'{{ parentType }}',
'{{ parent }}',
'{{ savedQueryId }}'
RETURNING
name,
content,
createTime,
creator,
description,
labels,
lastUpdateTime,
lastUpdater
;

Manifest

# Description fields are for documentation purposes
- name: saved_queries
props:
  - name: parentType
    value: "{{ parentType }}"
    description: Required parameter for the saved_queries resource.
  - name: parent
    value: "{{ parent }}"
    description: Required parameter for the saved_queries resource.
  - name: content
    description: |
      The query content.
    value:
      iamPolicyAnalysisQuery:
        accessSelector:
          permissions:
            - "{{ permissions }}"
          roles:
            - "{{ roles }}"
        conditionContext:
          accessTime: "{{ accessTime }}"
        identitySelector:
          identity: "{{ identity }}"
        options:
          analyzeServiceAccountImpersonation: {{ analyzeServiceAccountImpersonation }}
          expandGroups: {{ expandGroups }}
          expandResources: {{ expandResources }}
          expandRoles: {{ expandRoles }}
          outputGroupEdges: {{ outputGroupEdges }}
          outputResourceEdges: {{ outputResourceEdges }}
        resourceSelector:
          fullResourceName: "{{ fullResourceName }}"
        scope: "{{ scope }}"
  - name: description
    value: "{{ description }}"
    description: |
      The description of this saved query. This value should be fewer than 255 characters.
  - name: labels
    value: "{{ labels }}"
    description: |
      Labels applied on the resource. This value should not contain more than 10 entries. The key and value of each entry must be non-empty and fewer than 64 characters.
  - name: name
    value: "{{ name }}"
    description: |
      The resource name of the saved query. The format must be: * projects/project_number/savedQueries/saved_query_id * folders/folder_number/savedQueries/saved_query_id * organizations/organization_number/savedQueries/saved_query_id
  - name: savedQueryId
    value: "{{ savedQueryId }}"