Overview

Use Teradata as a destination in Mage to write structured pipeline data into a Teradata database table. This is ideal for analytics, reporting, or operational workloads in enterprise environments using Teradata’s scalable architecture.

Mage connects using direct credentials and supports exporting to tables in any schema the user has access to.


Configuration Parameters

Provide the following credentials when configuring Teradata as a destination:

KeyDescriptionExample ValueRequired
databaseName of the Teradata database where the table will be created or written to.demo
hostHostname or IP address of the Teradata server.test.clearscape.teradata.com
portPort used by the Teradata database (commonly 1025, depending on environment).1025
usernameTeradata username with write access to the specified database and schema.demo_user
passwordPassword for the Teradata user.abc123...

Notes

  • Mage will automatically create the target table if it doesn’t exist, unless configured otherwise.
  • Ensure the user has CREATE TABLE, INSERT, and SELECT privileges in the target schema.
  • Teradata uses ANSI SQL but has some syntax differences (e.g., date handling, identity columns) to be aware of.
  • This integration is well-suited for batch ingestion pipelines and bulk exports into data marts.