Page tree

Release 9.2




This section provides information on how to enable connection to  Teradata . 

  • Teradata provides Datawarehousing & Analytics solutions and Marketing applications. The  Teradata supports all of their Data warehousing solutions. For more information, see
  • For more information on supported versions, see Connection Types.

This connection supports reading and writing. You can create multiple Teradata connections in the Designer Cloud application.

Supported Versions: 14.10+

Supported Environments:


Designer Cloud Enterprise Edition

AmazonMicrosoft Azure
ReadSupportedSupportedNot supported


  • By default, Teradata does not permit the publication of datasets containing duplicate rows. Workarounds:
    • Your final statement for any recipe that generates results for Teradata should include a Remove duplicate rows transformation. 

      NOTE: The above transformation removes exact, case-sensitive duplicate rows. Teradata may still prevent publication for case-insensitive duplicates.

    • It's possible to change the default writing method to Teradata to enable duplicate rows. For more information, contact Alteryx Support
  • When creating custom datasets using SQL from Teradata sources, the ORDER BY clause in standard SQL does not work. This is a known issue.

Create Teradata Connection

For more information on creating a Teradata connection, see Teradata Connections.


Duplicate row error

This error occurs when duplicate rows are being inserted during publishing to Teradata.

Workaround: All inserted rows must be unique ,or the Teradata tables must be MULTISET. To configure Designer Cloud Enterprise Edition to use MULTISET tables, please contact Alteryx Support.



  1. After you create your connection, load a small dataset based on a table in the connected Teradata. See Import Data Page
  2. Perform a few simple transformations to the data. Run the job. See Transformer Page.
  3. Verify the results.

For more information, see Verify Operations.

This page has no comments.