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

Teradata® Package for Python User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Package for Python
Release Number
20.00
Published
March 2024
Language
English (United States)
Last Update
2024-04-09
dita:mapPath
nvi1706202040305.ditamap
dita:ditavalPath
plt1683835213376.ditaval
dita:id
rkb1531260709148
Product Category
Teradata Vantage

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.