Teradata Package for Python Function Reference on VantageCloud Lake - open_rows - Teradata Package for Python - Look here for syntax, methods and examples for the functions included in the Teradata Package for Python.

Teradata® Package for Python Function Reference on VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Package for Python
Release Number
20.00.00.08
Published
November 2025
ft:locale
en-US
ft:lastEdition
2025-12-05
dita:id
TeradataPython_FxRef_Lake_2000
Product Category
Teradata Vantage
teradataml.dataframe.dataframe.DataFrame.open_rows = open_rows(self)
DESCRIPTION:
    Retrieves open rows from a DataFrame created on a transaction-time
    or bi-temporal table/view. Open rows are defined as those where the
    end of the transaction-time period is greater than or equal to the current time.
 
PARAMETERS:
    None.
 
RETURNS:
    teradataml DataFrame.
 
RAISES:
    TeradataMLException.
 
EXAMPLES:
    # Load the data to run the example.
    >>> load_example_data("teradataml", "Employee_address")
    
    # Create a DataFrame on 'Employee_address' table.
    >>> df = DataFrame("Employee_address")
    
    # Retrieve open rows from the DataFrame.
    >>> df.open_rows()
    EmployeeID       EmployeeName        address                                                           validity_period
             1           John Doe    123 Main St  ('2025-03-04 15:41:44.610000+00:00', '9999-12-31 23:59:59.999999+00:00')
             2         Jane Smith     456 Elm St  ('2025-03-04 15:41:44.610000+00:00', '9999-12-31 23:59:59.999999+00:00')