Using SQLAlchemy ClauseElement and Expression for Filtering| teradataml - 17.00 - Using Basic SQLAlchemy ClauseElement and Expression for Filtering - Teradata Package for Python

Teradata® Package for Python User Guide

Product
Teradata Package for Python
Release Number
17.00
Release Date
November 2021
Content Type
User Guide
Publication ID
B700-4006-070K
Language
English (United States)

Vantage offers various types of clauses in WHERE clause that allows users to filter the results in a table.

With the help of SQLAlchemy ClauseElements and Expression, teradataml can use the following SQL clauses to filter results in teradataml DataFrame:

  • CASE expression
  • BETWEEN ... AND ... clause
  • IN clause
  • NOT IN clause
  • LIKE clause
  • NOT LIKE clause
  • ILIKE clause
  • IS NULL
  • IS NOT NULL

Refer to example notebook <pkg_install_location>\teradataml\data\notebooks\sqlalchemy\teradataml filtering - Using SQLAlchemy ClauseElements.ipynb to learn about these.