Support
Support from 16.20 to 20.0
Configuration
Vendor
TERADATA
Connection format
The connection URL format is
jdbc:teradata://<database_host>:<port>/<params>
Sometimes the port or the database can be a problem, and the URL can be used in this format jdbc:teradata://<database_host>/DATABASE=<databse>,DBS_PORT=<port>
Permissions
User or role with SELECT permissions on the databases, tables or views from which metadata is to be extracted or a data sample obtained.
If the table contains UDTs, the user will also need permissions on the corresponding procedures (SYSUDTLIB.X, where X is the name of the procedure)
Metadata extraction
Below is the Teradata documentation showing the different fields extracted from the tables *:
https://teradata-docs.s3.amazonaws.com/doc/connectivity/jdbc/reference/current/frameset.html
Important → For some column types, the length observed in the table may vary from the one extracted by Anjana; review the documentation indicated above.