Configure Redshift Integration

This page illustrates how to configure the Redshift integration on the Immuta app settings page. To configure this integration via the Immuta API, see the Integrations API getting started guide.

For instructions on configuring Redshift Spectrum, see the Redshift Spectrum guide.

Requirements

  • A Redshift cluster with an RA3 node is required for the multi-database integration. You must use a Redshift RA3 instance type because Immuta requires cross-database views, which are only supported in Redshift RA3 instance types. For other instance types, you may configure a single-database integration using one of the Redshift Spectrum options.

  • For automated installations, the credentials provided must be a Superuser or have the ability to create databases and users and modify grants.

  • The enable_case_sensitive_identifier parameter must be set to false (default setting) for your Redshift cluster.

Add a Redshift integration

  1. Click the App Settings icon in the navigation menu.

  2. Click the Integrations tab.

  3. Click the +Add Integration button and select Redshift from the dropdown menu.

  4. Complete the Host and Port fields.

  5. Enter an Immuta Database. This is a new database where all secure schemas and Immuta created views will be stored.

  6. Opt to check the Enable Impersonation box and customize the Impersonation Role name as needed. This will allow users to natively impersonate another user.

Select your configuration method

You have two options for configuring your Redshift environment:

  • Automatic setup: Grant Immuta one-time use of credentials to automatically configure your Redshift environment and the integration.

  • Manual setup: Run the Immuta script in your Redshift environment yourself to configure your environment and the integration.

Automatic setup

  1. Select Automatic.

  2. Enter an Initial Database from your Redshift integration for Immuta to use to connect.

  3. Use the dropdown menu to select your Authentication Method.

    1. Username and Password: Enter the Username and Password of the privileged user.

    2. AWS Access Key: Enter the Database User, Access Key ID, and Secret Key. Opt to enter in the Session Token.

Manual setup

  1. Select Manual and download both of the bootstrap scripts.

  2. Run the bootstrap script (initial database) in the Redshift initial database.

  3. Run the bootstrap script (Immuta database) in the new Immuta Database in Redshift.

  4. Choose your authentication method, and enter the information of the newly created account.

Save the configuration

Click Save.

Register data

Register Redshift data in Immuta.

Edit a Redshift integration

  1. Click the App Settings icon in the navigation menu.

  2. Navigate to the Integrations tab and click the down arrow next to the Redshift Integration.

  3. Edit the field you want to change. Note any field shadowed is not editable, and the integration must be disabled and re-installed to change it.

  4. Enter Username and Password.

  5. Click Save.

Remove a Redshift integration

Disabling Redshift Spectrum

Disabling the Redshift integration is not supported when you set the fields nativeWorkspaceName, nativeViewName, and nativeSchemaName to create Redshift Spectrum data sources. Disabling the integration when these fields are used in metadata ingestion causes undefined behavior.

  1. Click the App Settings icon in the navigation menu.

  2. Navigate to the Integrations tab and click the down arrow next to the Redshift Integration.

  3. Click the checkbox to disable the integration.

  4. Enter the username and password that were used to initially configure the integration.

  5. Click Save.

Last updated

Was this helpful?