Connecting to Redshift
  • 28 Sep 2022
  • 3 Minutes to read
  • Dark
    Light

Connecting to Redshift

  • Dark
    Light

Sisense enables quick and easy access to databases, tables and views contained within Amazon Redshift databases.

You can import your Redshift data into a Sisense ElastiCube or Live models, using Live Connect.

To add data from Amazon Redshift:

  1. In the Data page, either:
    • Open an ElastiCube or create a new data model
    • Open a Live model, or create a new live model
  2. In the data model, click ; the Add Data dialog box is displayed.
    8-5add-redshift-live-connectorthumb0300.png
  3. Click Amazon Redshiftto open the Amazon Redshift settings.
    redshift
  4. Enter the following details:
    • Location: Enter the Amazon Redshift cluster endpoint. This server address should include the endpoint, port, and database. By default, the port is 5439, for example: [Endpoint]:5439[Database]. To connect to a database running on your own computer, enter localhost .
    • User Name and Password: Enter your Redshift account credentials
    • Default Database: Enter the name of the default database you will use for authentication.
  5. (Optional) Select Encrypt Connection to configure the driver to encrypt all communication with Redshift before sending it over the network, and then select Trust Server Certificate.
  6. (Optional) In Additional Parameters, enter additional configuration options by appending key-value pairs to the connection string (e.g., port=5433;). For a full list of connection string options, click here .
  7. Click .
  8. For Linux, under the Select Data tab, on the left side is a list of schemas located in your data source. Select the relevant schema. You can find the schema easily by filtering for it using the Search field at the top of the list.
    All tables and views associated with the database appear in a new window.
    redshift 2
  9. From the Tables list, select the relevant table or view you want to work with. You can click next to the relevant table or view to see a preview of the data inside it. When you select the table or view, two new options are displayed at the bottom of the list, Import Relationships and Add Custom Import SQL.
  10. (Optional) By default, existing relationships between tables are automatically replicated in the ElastiCube or live model. You can disable this by toggling the Import Relationships switch.
  11. (Optional)
  12. After you have selected all the relevant tables, click Done. The tables are added to your schema in Sisense.
Note:

If you encounter problems connecting to Amazon RedShift, see this article in the support forum.

Configuring a Security Group

Create a security group in the same VPC as the Redshift cluster that you are connecting to Sisense. You can create a security group in Services > VPC > Security > Security Groups.

8-7createsecthumb0300.png

After you create it, add inbound rules to allow traffic from Sisense Cloud as well as the Sisense deployment over the Redshift port (default 5439). The Sisense Cloud IP address is 54.186.74.45 and 54.187.196.247 and the Sisense deployment address will be the IP Address of your Sisense URL (for example, hypothetical Sisense deployment at https://analytics.example.com might have an IP address of 123.45.67.89).

8-7createsec1thumb0300.png

Configuring a Redshift Cluster or Amazon Redshift Serverless

Find your cluster in the Amazon Redshift > Clusters menu and navigate to the Properties tab.

8-7confgdwthumb0300.png

For Amazon Redshift Serverless, navigate to the Workgroup tab.

Edit the Network and security settings to attach the new security group to the Redshift cluster.

8-7configdw1thumb0300.png

Then, ensure that Publicly accessible is set to Yes. Note, this setting has its own Edit button within the Network and security section.

8-7confgdw2thumb0300.png

Once that is done, the endpoint needed to connect can be found in the Connection Details section on the right side of the Properties page.

8-7connectdetailsthumb0300.png

For more on Data Warehouses, see Working with Data Warehouses.


Was this article helpful?