Redshift OCF Connector: Overview

Overview

The OCF connector for Redshift was developed by Alation and is available as a Zip file that can be uploaded and installed in Manage Connectors. Create a ticket with Alation Support about receiving the Redshift connector package.

This connector should be used to catalog Redshift as a data source in Alation. The connector catalogs Redshift objects such as tables, columns, views, primary keys, foreign keys, functions, and function definition fields. It enables end-users to search and find Redshift objects from the Alation user interface.

Team

The following administrators are required to install this connector:

  • Alation administrator:

    • Installs the connector

    • Creates and configures the Redshift data source in the Catalog

  • Redshift objects administrator:

    • Creates a service account with the Enterprise authentication type

    • Provides the JDBC URI to access metadata

    • Provides access to public schemas to extract metadata

Scope

The table below shows what features are covered by the connector:

Browser

Redshift

Core Capabilities

Automated metadata extraction (MDE)

Query-based MDE

Search

Catalog page curation

Catalog sets

Propagation of trust flags

Popularity

Compose

Compose authentication (Basic Authentication)

Compose authentication (SSL)

Compose query creation

Query execution

QLI

Query based QLI

Filters

Lineage

Sampling and Profiling

Table sampling

Custom query-based table sampling

Custom query-based column profiling

Dynamic profiling

Service Account Authentication

Basic (username and password)

SSL

Kerberos

Keytab

LDAP

Technical Metadata

Tables

Attributes

Primary keys

Foreign keys

Views

Schemas

Source comments