Skip to main content

feature_online_stores

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

Overview

Namefeature_online_stores
TypeResource
Idgoogle.aiplatform.feature_online_stores

Fields

NameDatatypeDescription
namestringIdentifier. Name of the FeatureOnlineStore. Format: projects/{project}/locations/{location}/featureOnlineStores/{featureOnlineStore}
bigtableobject
createTimestringOutput only. Timestamp when this FeatureOnlineStore was created.
dedicatedServingEndpointobjectThe dedicated serving endpoint for this FeatureOnlineStore. Only need to set when you choose Optimized storage type. Public endpoint is provisioned by default.
encryptionSpecobjectRepresents a customer-managed encryption key spec that can be applied to a top-level resource.
etagstringOptional. Used to perform consistent read-modify-write updates. If not set, a blind "overwrite" update happens.
labelsobjectOptional. The labels with user-defined metadata to organize your FeatureOnlineStore. 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.
optimizedobjectOptimized storage type
satisfiesPzibooleanOutput only. Reserved for future use.
satisfiesPzsbooleanOutput only. Reserved for future use.
statestringOutput only. State of the featureOnlineStore.
updateTimestringOutput only. Timestamp when this FeatureOnlineStore was last updated.

Methods

NameAccessible byRequired ParamsDescription
getSELECTfeatureOnlineStoresId, locationsId, projectsIdGets details of a single FeatureOnlineStore.
listSELECTlocationsId, projectsIdLists FeatureOnlineStores in a given project and location.
createINSERTlocationsId, projectsIdCreates a new FeatureOnlineStore in a given project and location.
deleteDELETEfeatureOnlineStoresId, locationsId, projectsIdDeletes a single FeatureOnlineStore. The FeatureOnlineStore must not contain any FeatureViews.
patchUPDATEfeatureOnlineStoresId, locationsId, projectsIdUpdates the parameters of a single FeatureOnlineStore.

SELECT examples

Lists FeatureOnlineStores in a given project and location.

SELECT
name,
bigtable,
createTime,
dedicatedServingEndpoint,
encryptionSpec,
etag,
labels,
optimized,
satisfiesPzi,
satisfiesPzs,
state,
updateTime
FROM google.aiplatform.feature_online_stores
WHERE locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';

INSERT example

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

/*+ create */
INSERT INTO google.aiplatform.feature_online_stores (
locationsId,
projectsId,
dedicatedServingEndpoint,
etag,
labels,
optimized,
name,
bigtable,
encryptionSpec
)
SELECT
'{{ locationsId }}',
'{{ projectsId }}',
'{{ dedicatedServingEndpoint }}',
'{{ etag }}',
'{{ labels }}',
'{{ optimized }}',
'{{ name }}',
'{{ bigtable }}',
'{{ encryptionSpec }}'
;

UPDATE example

Updates a feature_online_stores resource.

/*+ update */
UPDATE google.aiplatform.feature_online_stores
SET
dedicatedServingEndpoint = '{{ dedicatedServingEndpoint }}',
etag = '{{ etag }}',
labels = '{{ labels }}',
optimized = '{{ optimized }}',
name = '{{ name }}',
bigtable = '{{ bigtable }}',
encryptionSpec = '{{ encryptionSpec }}'
WHERE
featureOnlineStoresId = '{{ featureOnlineStoresId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';

DELETE example

Deletes the specified feature_online_stores resource.

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