Teradata
Connection Type | ODBC (64-bit) |
Driver Configuration Requirements | Bulk read and write support is available for standard workflows. Bulk write support is available for in-database workflows. |
Type of Support | Read & Write, In-Database |
Validated On | Database Version: 16.20, 17.20, and 20.00 ODBC Client Version: 17.20.00.08 and 20.00.00.47 |
Alteryx Tools Used to Connect
Standard Workflow Process
In-Database Workflow Process
Additional Details
The Teradata bulk loader doesn't support BLOB or spatial objects. These field types can be written with standard ODBC. Appending to an existing CLOB data type isn't supported.
The Teradata Parallel Transporter Base component of Teradata Tools and Utilities (TTU) must be installed.
Limitations
Alteryx does not explicitly define either PRIMARY INDEX, PRIMARY AMP INDEX, or NO PRIMARY INDEX when creating a table. This means the Primary Index Default will be chosen by the system. For more information on Teradata Primary Index, go to Teradata Online Documentation.