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

Use the future_rows() function to retrieve future rows from a DataFrame created on a valid-time or bi-temporal table/view. Future rows are defined as those where the start of the valid-time period is greater than the current time.

There are no parameters for this function.

Example setup

Load the data.

>>> load_example_data("teradataml", "Employee_roles")

Create a DataFrame on 'Employee_roles' table.

>>> df = DataFrame("Employee_roles")

Example: Retrieve future rows from the DataFrame

>>> df.future_rows()

EmployeeID   EmployeeName   Department   Salary         role_validity_period
         3            Bob    Marketing    330.0     ('29/01/01', '99/12/31')