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 |
✔ |