Skip to content

Teradata

Teradata reader.

koheesio.spark.readers.teradata.TeradataReader #

Wrapper around JdbcReader for Teradata.

Notes
  • Consider using synthetic partitioning column when using partitioned read: MOD(HASHBUCKET(HASHROW(<TABLE>.<COLUMN>)), <NUM_PARTITIONS>)
  • Relevant jars should be added to the Spark session manually. This class does not take care of that.
See Also
Example

This example depends on the Teradata terajdbc4 JAR. e.g. terajdbc4-17.20.00.15. Keep in mind that older versions of terajdbc4 drivers also require tdgssconfig JAR.

from koheesio.spark.readers.teradata import TeradataReader

td = TeradataReader(
    url="jdbc:teradata://<domain_or_ip>/logmech=ldap,charset=utf8,database=<db>,type=fastexport, maybenull=on",
    user="YOUR_USERNAME",
    password="***",
    dbtable="schemaname.tablename",
)

Parameters:

Name Type Description Default
url str

JDBC connection string. Refer to Teradata docs for the list of all available connection string parameters. Example: jdbc:teradata://<domain_or_ip>/logmech=ldap,charset=utf8,database=<db>,type=fastexport, maybenull=on

 required
user str

Username

 required
password SecretStr

Password

 required
dbtable str

Database table name, also include schema name

 required
options Optional[Dict[str, Any]]

Extra options to pass to the Teradata JDBC driver. Refer to Teradata docs for the list of all available connection string parameters.

 {"fetchsize": 2000, "numPartitions": 10}
query Optional[str]

Query

 None
format str

The type of format to load. Defaults to 'jdbc'. Should not be changed.

 required
driver str

Driver name. Be aware that the driver jar needs to be passed to the task. Should not be changed.

 required

driver class-attribute instance-attribute #

driver: str = Field(
    "com.teradata.jdbc.TeraDriver",
    description="Make sure that the necessary JARs are available in the cluster: terajdbc4-x.x.x.x",
)

options class-attribute instance-attribute #

options: Optional[Dict[str, Any]] = Field(
    {"fetchsize": 2000, "numPartitions": 10},
    description="Extra options to pass to the Teradata JDBC driver",
)