saved_queries

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

Overview

Name	saved_queries
Type	Resource
Id	google.aiplatform.saved_queries

Fields

The following fields are returned by SELECT queries:

list

Successful response

Name	Datatype	Description
name	string	Output only. Resource name of the SavedQuery.
annotationFilter	string	Output only. Filters on the Annotations in the dataset.
annotationSpecCount	integer (int32)	Output only. Number of AnnotationSpecs in the context of the SavedQuery.
createTime	string (google-datetime)	Output only. Timestamp when this SavedQuery was created.
displayName	string	Required. The user-defined name of the SavedQuery. The name can be up to 128 characters long and can consist of any UTF-8 characters.
etag	string	Used to perform a consistent read-modify-write update. If not set, a blind "overwrite" update happens.
metadata	any	Some additional information about the SavedQuery.
problemType	string	Required. Problem type of the SavedQuery. Allowed values: * IMAGE_CLASSIFICATION_SINGLE_LABEL * IMAGE_CLASSIFICATION_MULTI_LABEL * IMAGE_BOUNDING_POLY * IMAGE_BOUNDING_BOX * TEXT_CLASSIFICATION_SINGLE_LABEL * TEXT_CLASSIFICATION_MULTI_LABEL * TEXT_EXTRACTION * TEXT_SENTIMENT * VIDEO_CLASSIFICATION * VIDEO_OBJECT_TRACKING
supportAutomlTraining	boolean	Output only. If the Annotations belonging to the SavedQuery can be used for AutoML training.
updateTime	string (google-datetime)	Output only. Timestamp when SavedQuery was last updated.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	projectsId, locationsId, datasetsId	filter, pageSize, pageToken, readMask, orderBy	Lists SavedQueries in a Dataset.
delete	delete	projectsId, locationsId, datasetsId, savedQueriesId		Deletes a SavedQuery.

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
datasetsId	string
locationsId	string
projectsId	string
savedQueriesId	string
filter	string
orderBy	string
pageSize	integer (int32)
pageToken	string
readMask	string (google-fieldmask)

SELECT examples

list

Lists SavedQueries in a Dataset.

SELECT
name,
annotationFilter,
annotationSpecCount,
createTime,
displayName,
etag,
metadata,
problemType,
supportAutomlTraining,
updateTime
FROM google.aiplatform.saved_queries
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND datasetsId = '{{ datasetsId }}' -- required
AND filter = '{{ filter }}'
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
AND readMask = '{{ readMask }}'
AND orderBy = '{{ orderBy }}';

DELETE examples

delete

Deletes a SavedQuery.

DELETE FROM google.aiplatform.saved_queries
WHERE projectsId = '{{ projectsId }}' --required
AND locationsId = '{{ locationsId }}' --required
AND datasetsId = '{{ datasetsId }}' --required
AND savedQueriesId = '{{ savedQueriesId }}' --required;