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')