Amazon Redshift support

Connection requirements

To connect to Amazon Redshift you need to install ODBC connector:

https://docs.aws.amazon.com/redshift/latest/mgmt/install-odbc-driver-windows.html

Supported schema elements and metadata

• Tables
  • Columns
    • Data type with length
    • Identity (is identity on)
    • Nullable
    • Default value
  • Primary keys
    • Columns
  • Unique indexes
    • Columns
  • Foreign keys
    • Columns
• Views
  • Columns (see tables)
  • Script
• User-Defined Functions
  • Script
  • Parameters
  • Returned value
• Dependencies (views)

Comments

Dataedo reads comments from following Redshift objects:

• Tables
  • Columns
• Views
  • Columns
• User Defined Functions
  • Parameters

Dataedo does not write comments back to Redshift at this moment.

Learn more

Connect to Amazon Redshift