Prerequisites to Use FeatureStore in teradataml Analytic Functions | Teradata Package for Python - Prerequisites to Using FeatureStore - Teradata Package for Python

Teradata® Package for Python User Guide

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Teradata Package for Python
Release Number
20.00
Published
March 2025
ft:locale
en-US
ft:lastEdition
2025-12-05
dita:mapPath
nvi1706202040305.ditamap
dita:ditavalPath
plt1683835213376.ditaval
dita:id
rkb1531260709148
Product Category
Teradata Vantage

System Requirements

  • Teradata Vantage: Version 17.20 or later
  • teradataml: Version 20.00.00.07 or later
  • Teradata connection: Always connect to the database using create_context() before initializing a FeatureStore object.

Feature Requirements

The Teradata Feature Store requires temporal database features to be enabled on your Vantage system. This is critical for feature versioning and time-based queries.

Refer to Temporal Table Support, B035-1182.

Roles and Permissions

Feature Store Administrator

Before ingesting the feature values and metadata, the DBA needs to set up the Feature Store repository and grant access to other users on the Feature Store repository. Verify the DBA who is setting up Feature Store has privileges to create database, tables, and triggers on the database.

Setting up Feature store includes creating the following database objects.

Database Object Function Description
Database CREATE DATABASE Create the feature store repository.
Table CREATE TABLE Create Feature Store tables
Views CREATE VIEW Create feature version views
Triggers CREATE TRIGGER Create archival triggers

Refer to API FeatureStore.setup() to set up Feature Store.

Refer to FeatureStore.grant and FeatureStore.revoke API to grant and revoke access to a user on Feature Store.

Drop privileges are listed as follows. These privileges allow the DBA to remove a feature store as needed.

Database Object Function Description
Database DROP DATABASE For cleanup operations.
Table DROP TABLE For maintenance operations
Views DROP VIEW
Triggers DROP TRIGGER

Refer to FeatureStore.delete() to delete Feature Store.

Feature Store User

The Feature Store User role is a database user who is responsible for ingesting Feature values and creating datasets on the Feature Store. This role also maintains Feature Store metadata.

Statement Description
INSERT, UPDATE, DELETE For table create, update, and delete Feature values
INSERT, UPDATE, DELETE For data operations and manipulation
SELECT For querying features and their values