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

Use the closed_rows() function to retrieve closed rows from a DataFrame created on a transaction-time or bi-temporal table/view. Closed rows are defined as those where the end of the transaction-time period is less than the current time.

There are no parameters for this function.

Example setup

Load the data to run the example.

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

Create a DataFrame on 'Employee_address' table.

>>> df = DataFrame("Employee_address")

Example: Retrieve closed rows from the DataFrame

>>> df.closed_rows()

EmployeeID    EmployeeName      address                                                           validity_period
         1        John Doe  123 Main St  ('2025-03-04 15:41:44.610000+00:00', '2025-04-01 23:59:59.999999+00:00')