feature_views

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

Overview

Name	feature_views
Type	Resource
Id	google.aiplatform.feature_views

Fields

Name	Datatype	Description
name	string	Identifier. Name of the FeatureView. Format: projects/{project}/locations/{location}/featureOnlineStores/{feature_online_store}/featureViews/{feature_view}
bigQuerySource	object
createTime	string	Output only. Timestamp when this FeatureView was created.
etag	string	Optional. Used to perform consistent read-modify-write updates. If not set, a blind "overwrite" update happens.
featureRegistrySource	object	A Feature Registry source for features that need to be synced to Online Store.
indexConfig	object	Configuration for vector indexing.
labels	object	Optional. The labels with user-defined metadata to organize your FeatureViews. Label keys and values can be no longer than 64 characters (Unicode codepoints), can only contain lowercase letters, numeric characters, underscores and dashes. International characters are allowed. See https://goo.gl/xmQnxf for more information on and examples of labels. No more than 64 user labels can be associated with one FeatureOnlineStore(System labels are excluded)." System reserved label keys are prefixed with "aiplatform.googleapis.com/" and are immutable.
satisfiesPzi	boolean	Output only. Reserved for future use.
satisfiesPzs	boolean	Output only. Reserved for future use.
syncConfig	object	Configuration for Sync. Only one option is set.
updateTime	string	Output only. Timestamp when this FeatureView was last updated.
vertexRagSource	object	A Vertex Rag source for features that need to be synced to Online Store.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	featureOnlineStoresId, featureViewsId, locationsId, projectsId	Gets details of a single FeatureView.
list	SELECT	featureOnlineStoresId, locationsId, projectsId	Lists FeatureViews in a given FeatureOnlineStore.
create	INSERT	featureOnlineStoresId, locationsId, projectsId	Creates a new FeatureView in a given FeatureOnlineStore.
delete	DELETE	featureOnlineStoresId, featureViewsId, locationsId, projectsId	Deletes a single FeatureView.
patch	UPDATE	featureOnlineStoresId, featureViewsId, locationsId, projectsId	Updates the parameters of a single FeatureView.
search_nearest_entities	EXEC	featureOnlineStoresId, featureViewsId, locationsId, projectsId	Search the nearest entities under a FeatureView. Search only works for indexable feature view; if a feature view isn't indexable, returns Invalid argument response.
sync	EXEC	featureOnlineStoresId, featureViewsId, locationsId, projectsId	Triggers on-demand sync for the FeatureView.

SELECT examples

Lists FeatureViews in a given FeatureOnlineStore.

SELECT
name,
bigQuerySource,
createTime,
etag,
featureRegistrySource,
indexConfig,
labels,
satisfiesPzi,
satisfiesPzs,
syncConfig,
updateTime,
vertexRagSource
FROM google.aiplatform.feature_views
WHERE featureOnlineStoresId = '{{ featureOnlineStoresId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}'; 

INSERT example

Use the following StackQL query and manifest file to create a new feature_views resource.

All Properties

/*+ create */
INSERT INTO google.aiplatform.feature_views (
featureOnlineStoresId,
locationsId,
projectsId,
etag,
labels,
bigQuerySource,
name,
featureRegistrySource,
indexConfig,
vertexRagSource,
syncConfig
)
SELECT 
'{{ featureOnlineStoresId }}',
'{{ locationsId }}',
'{{ projectsId }}',
'{{ etag }}',
'{{ labels }}',
'{{ bigQuerySource }}',
'{{ name }}',
'{{ featureRegistrySource }}',
'{{ indexConfig }}',
'{{ vertexRagSource }}',
'{{ syncConfig }}'
;

Manifest

satisfiesPzs: boolean
createTime: string
etag: string
satisfiesPzi: boolean
labels: object
bigQuerySource:
  entityIdColumns:
    - type: string
  uri: string
name: string
updateTime: string
featureRegistrySource:
  featureGroups:
    - featureIds:
        - type: string
      featureGroupId: string
  projectNumber: string
indexConfig:
  bruteForceConfig: {}
  embeddingDimension: integer
  distanceMeasureType: string
  crowdingColumn: string
  filterColumns:
    - type: string
  treeAhConfig:
    leafNodeEmbeddingCount: string
  embeddingColumn: string
vertexRagSource:
  uri: string
  ragCorpusId: string
syncConfig:
  cron: string

UPDATE example

Updates a feature_views resource.

/*+ update */
UPDATE google.aiplatform.feature_views
SET 
etag = '{{ etag }}',
labels = '{{ labels }}',
bigQuerySource = '{{ bigQuerySource }}',
name = '{{ name }}',
featureRegistrySource = '{{ featureRegistrySource }}',
indexConfig = '{{ indexConfig }}',
vertexRagSource = '{{ vertexRagSource }}',
syncConfig = '{{ syncConfig }}'
WHERE 
featureOnlineStoresId = '{{ featureOnlineStoresId }}'
AND featureViewsId = '{{ featureViewsId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';

DELETE example

Deletes the specified feature_views resource.

/*+ delete */
DELETE FROM google.aiplatform.feature_views
WHERE featureOnlineStoresId = '{{ featureOnlineStoresId }}'
AND featureViewsId = '{{ featureViewsId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';