feature_groups

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

Overview

Name	feature_groups
Type	Resource
Id	google.aiplatform.feature_groups

Fields

Name	Datatype	Description
name	string	Identifier. Name of the FeatureGroup. Format: projects/{project}/locations/{location}/featureGroups/{featureGroup}
description	string	Optional. Description of the FeatureGroup.
bigQuery	object	Input source type for BigQuery Tables and Views.
createTime	string	Output only. Timestamp when this FeatureGroup was created.
etag	string	Optional. Used to perform consistent read-modify-write updates. If not set, a blind "overwrite" update happens.
labels	object	Optional. The labels with user-defined metadata to organize your FeatureGroup. 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 FeatureGroup(System labels are excluded)." System reserved label keys are prefixed with "aiplatform.googleapis.com/" and are immutable.
updateTime	string	Output only. Timestamp when this FeatureGroup was last updated.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	featureGroupsId, locationsId, projectsId	Gets details of a single FeatureGroup.
list	SELECT	locationsId, projectsId	Lists FeatureGroups in a given project and location.
create	INSERT	locationsId, projectsId	Creates a new FeatureGroup in a given project and location.
delete	DELETE	featureGroupsId, locationsId, projectsId	Deletes a single FeatureGroup.
patch	UPDATE	featureGroupsId, locationsId, projectsId	Updates the parameters of a single FeatureGroup.

SELECT examples

Lists FeatureGroups in a given project and location.

SELECT
name,
description,
bigQuery,
createTime,
etag,
labels,
updateTime
FROM google.aiplatform.feature_groups
WHERE locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}'; 

INSERT example

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

All Properties

/*+ create */
INSERT INTO google.aiplatform.feature_groups (
locationsId,
projectsId,
bigQuery,
name,
description,
labels,
etag
)
SELECT 
'{{ locationsId }}',
'{{ projectsId }}',
'{{ bigQuery }}',
'{{ name }}',
'{{ description }}',
'{{ labels }}',
'{{ etag }}'
;

Manifest

bigQuery:
  dense: boolean
  bigQuerySource:
    inputUri: string
  staticDataSource: boolean
  timeSeries:
    timestampColumn: string
  entityIdColumns:
    - type: string
updateTime: string
name: string
description: string
labels: object
createTime: string
etag: string

UPDATE example

Updates a feature_groups resource.

/*+ update */
UPDATE google.aiplatform.feature_groups
SET 
bigQuery = '{{ bigQuery }}',
name = '{{ name }}',
description = '{{ description }}',
labels = '{{ labels }}',
etag = '{{ etag }}'
WHERE 
featureGroupsId = '{{ featureGroupsId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';

DELETE example

Deletes the specified feature_groups resource.

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