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

Successful response

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.

get

Successful response

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.
get	select	name		Gets details about a saved query.
create	insert	parentType, parent	savedQueryId	Creates a saved query in a parent project/folder/organization.
patch	update	name	updateMask	Updates a saved query.
delete	delete	name		Deletes a saved query.

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

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 }}';

get

Gets details about a saved query.

SELECT
name,
content,
createTime,
creator,
description,
labels,
lastUpdateTime,
lastUpdater
FROM google.cloudasset.saved_queries
WHERE name = '{{ name }}' -- required;

INSERT examples

create

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

INSERT INTO google.cloudasset.saved_queries (
data__name,
data__description,
data__labels,
data__content,
parentType,
parent,
savedQueryId
)
SELECT 
'{{ name }}',
'{{ description }}',
'{{ labels }}',
'{{ content }}',
'{{ 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: string
      description: Required parameter for the saved_queries resource.
    - name: parent
      value: string
      description: Required parameter for the saved_queries resource.
    - name: name
      value: string
      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: description
      value: string
      description: >
        The description of this saved query. This value should be fewer than 255 characters.
        
    - name: labels
      value: object
      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: content
      value: object
      description: >
        The query content.
        
    - name: savedQueryId
      value: string

UPDATE examples

patch

Updates a saved query.

UPDATE google.cloudasset.saved_queries
SET 
data__name = '{{ name }}',
data__description = '{{ description }}',
data__labels = '{{ labels }}',
data__content = '{{ content }}'
WHERE 
name = '{{ name }}' --required
AND updateMask = '{{ updateMask}}'
RETURNING
name,
content,
createTime,
creator,
description,
labels,
lastUpdateTime,
lastUpdater;

DELETE examples

delete

Deletes a saved query.

DELETE FROM google.cloudasset.saved_queries
WHERE name = '{{ name }}' --required;