Documentation

Granting Redshift Access

Abstract

SummaryInstructions about granting Redshift cluster access and (optionally) creating a user and schema for setting up Redshift as an output in Alooma.

You can grant Alooma access to your Redshift cluster in a few simple steps, some of which are optional:

Step 1 - Authorizing Cluster access

Are you planning to connect to Redshift via SSH? If so, skip ahead to [Optional] Step 2 - Creating a User and Schema for Alooma.

For Alooma to be able to access your Redshift cluster directly, you'll need to create a security group where you've whitelisted the Alooma IP addresses from which we'll communicate with your cluster.

  1. From the Redshift Dashboard, click on Clusters.

  2. In the list of clusters, choose your cluster.

  3. In the Configuration tab of the clusters detail page, under the VPC Security Groups section, click the name of the security group.

    cluster-properties.png
  4. In the security group view, select the Inbound tab on the bottom half of the page, then in that tab click Edit.

    edit-security-group.png
  5. In the Edit inbound rules dialog you'll add the IP addresses that Alooma can use to access the cluster. To add a new rule, click Add Rule at the bottom of the list, and set the following:

    • Type - Redshift.

    • Protocol - TCP (the default).

    • Port Range - The number of the open port (Redshift's default is 5439).

    • Source - Custom IP (the default). In the field next to Source, paste the following IP address: 52.35.19.31/32

    add-rule.png
  6. Repeat the Add Rule steps above for each of these additional IPs: 52.88.52.130/32, 52.26.47.1/32, and 52.24.172.83/32.

    Note that you can rename a security group by hovering over the group name and clicking the pencil icon.

[Optional] Step 2 - Creating a User and Schema for Alooma

While this step is optional, we recommend that you create a username and password for Alooma to use specifically for table creation and editing. If you don't create a username and password you can specify an existing user and schema for us to connect to.

To create, connect to your Redshift cluster from your SQL console of choice (e.g. SQL Workbench/J). From there, you'll run the following 2 commands:

  1. Create a user named alooma with a password of your choice.

    CREATE USER alooma WITH PASSWORD '<>'

  2. Create a schema named alooma and grant us owner permissions.

    CREATE SCHEMA alooma AUTHORIZATION alooma;

  3. Optionally, enable Alooma to create schemas on your Redshift database.

    GRANT CREATE ON DATABASE <db-name> TO alooma;

That's it, you've granted Alooma access to your Redshift. Continue to setting up a connection via an SSH server, or connecting directly to Redshift.

Search results

    No results found