Teradata support

Applies to: Dataedo 24.x (current) versions, Article available also for: 10.x, 23.x

Supported versions

16.20

Supported schema elements and metadata

Dataedo reads following metadata from Teradata databases.

  • Tables
    • Columns
      • Data type with length
      • Nullable
      • Default value
      • Generated column formula
    • Primary keys
      • Columns
    • Unique indexes
      • Column
    • Foreign keys
      • Columns
    • Triggers
      • When triggered
      • Script
  • Views
    • Columns (see tables)
    • Script
  • Procedures
    • Script (SQL procedures only)
    • Parameters
  • Functions
    • Script (SQL functions only)
    • Parameters
    • Returned value

Data profiling

Datedo does not support data profiling in Teradata.

Comments

Dataedo reads Teradata comments from following objects:

  • Tables
    • Columns
  • Views
    • Columns

Dataedo does not write comments back to Teradata.