Teradata recommends that the Foreign Server Library is used to interact with the Spark SQL initiator. See Foreign Server Library API Reference for the Spark SQL Initiator Connector for details on Foreign Server Libraries.
The Spark SQL connector supports predicate pushdown by default. Spark SQL initiator connectors support the following logical expressions as pushdown predicates: And, Or, Not, Eq, NEq, LT, GT, LE, GE, Like, IsNull, IN, NotIn, and Between.