open_rows() | Teradata Package for Python - open_rows() - Teradata Package for Python

Use the open_rows() function to retrieve 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.

There are no parameters for this function.

Example setup

Load the data.

>>> load_example_data("teradataml", "Employee_address")

Create a DataFrame on 'Employee_address' table.

>>> df = DataFrame("Employee_address")

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