saved_queries

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

Overview

Name	saved_queries
Type	Resource
Id	google.aiplatform.saved_queries

Fields

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	Output only. Number of AnnotationSpecs in the context of the SavedQuery.
createTime	string	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	Output only. Timestamp when SavedQuery was last updated.

Methods

Name	Accessible by	Required Params	Description
list	SELECT	datasetsId, locationsId, projectsId	Lists SavedQueries in a Dataset.
delete	DELETE	datasetsId, locationsId, projectsId, savedQueriesId	Deletes a SavedQuery.

SELECT examples

Lists SavedQueries in a Dataset.

SELECT
name,
annotationFilter,
annotationSpecCount,
createTime,
displayName,
etag,
metadata,
problemType,
supportAutomlTraining,
updateTime
FROM google.aiplatform.saved_queries
WHERE datasetsId = '{{ datasetsId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';

DELETE example

Deletes the specified saved_queries resource.

/*+ delete */
DELETE FROM google.aiplatform.saved_queries
WHERE datasetsId = '{{ datasetsId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}'
AND savedQueriesId = '{{ savedQueriesId }}';