Amazon Redshift support

7th June, 2018
Applies to: 7.x versions, Article available also for: 9.x (current), 8.x
You are looking at documentation for an older release.
Switch to the documentation for Dataedo 9.x (current).

Available from version 7.0.2 beta.

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

Found issue with this article? Comment below
0
There are no comments. Click here to write the first comment.