# Connecting to Amazon Redshift

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

*Source: https://docs.sisense.com/main/SisenseLinux/connecting-to-amazon-redshift.htm*

---

Last updated: June 10, 2026

|  |  |
| --- | --- |
| [Tier](https://www.sisense.com/pricing/#pricing) | [Deployment](https://docs.sisense.com/main/SisenseLinux/introduction-to-sisense-cloud-managed-services.md#ComparisonofManagedCloudandSelfHosted) |
| Launch     Grow    Enterprise | Cloud     On-Prem |

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 [Introducing Live Models](https://docs.sisense.com/main/SisenseLinux/live-connect.md).

**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 Model Editor, click ![+Data](https://docs.sisense.com/main/Resources/Images/+Data.png). The Choose Connection window is displayed.

   ![ConnMgmtChooseConnector](https://docs.sisense.com/main/Resources/Images/connMgmtChooseConnector.png)
3. Choose an available [managed connection](https://docs.sisense.com/main/SisenseLinux/data-source-connection-management.md#AccessingandManagingAvailableConnections), or create a [new connection](https://docs.sisense.com/main/SisenseLinux/data-source-connection-management.md#CreatingNewConnections), for **Amazon Redshift**. The Amazon Redshift area is displayed.
4. Click **Amazon Redshift**to open the Amazon Redshift settings.
     
   ![Redshift](https://docs.sisense.com/main/Resources/Images/redshift_842x438.png)
5. 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.
   - **Database**: Enter the name of the default database you will use for authentication.

   The default Database is an optional property in the connection to a data source. When specified, it acts as a starting point or shortcut, automatically selecting a database during the connection setup to streamline user workflows.

   **IMPORTANT:**

   The default Database is not a security feature. It does not restrict Sisense users from accessing other databases within the data source. Access should be regulated through user permissions in the Redshift database management system.
6. (**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**.
7. (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](https://docs.aws.amazon.com/redshift/latest/mgmt/configure-jdbc-options.html) .
8. Click ![Next](https://docs.sisense.com/main/Resources/Images/Next.png).
9. 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](https://docs.sisense.com/main/Resources/Images/redshift 2_773x448.png)
10. From the Tables list, select the relevant table or view you want to work with. You can click ![8 5previewtable](https://docs.sisense.com/main/Resources/Images/8-5previewtable3.png) 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**.
11. (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.
12. (Optional)
    - **ElastiCube**  
      Click + to customize the data you want to import with SQL. See [Importing Data with Custom Queries](https://docs.sisense.com/main/SisenseLinux/importing-data-with-custom-queries.md) for more information.
    - **Live**  
      Click + to customize the data you want to access with SQL. See [Creating Custom Live Table Queries](https://docs.sisense.com/main/SisenseLinux/creating-custom-live-table-queries.md) for more information.
13. 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](https://support.sisense.com/kb/en/article/elasticube-manager-hangs-when-trying-to-add-amazon-redshift-data) in the support forum.
- Since Redshift defaults to lower case, when editing a Redshift column name in Sisense from lower case to a name with capital letters, you must perform one of the following two workarounds for the change to be able to be saved:

  - Enclose the name in double quotes
  - Disable case sensitivity in Redshift

  For more information, see the following Redshift documentation: [Names and indentifiers](https://docs.aws.amazon.com/redshift/latest/dg/r_names.html?utm_source=chatgpt.com#r_names-delimited-identifiers) & [Enable case sensitive identifier](https://docs.aws.amazon.com/redshift/latest/dg/r_enable_case_sensitive_identifier.html).

  

## 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 7createsecthumb](https://docs.sisense.com/main/Resources/Images/8-7createsecthumb0300_868x316.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 7createsec1thumb](https://docs.sisense.com/main/Resources/Images/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 7confgdwthumb](https://docs.sisense.com/main/Resources/Images/8-7confgdwthumb0300_728x187.png)

For Amazon Redshift Serverless, navigate to the Workgroup tab.

![Image](https://docs.sisense.com/main/Resources/Images/image-1659951097265_1408x489.png)

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

![8 7configdw1thumb](https://docs.sisense.com/main/Resources/Images/8-7configdw1thumb0300_699x435.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 7confgdw2thumb](https://docs.sisense.com/main/Resources/Images/8-7confgdw2thumb0300_414x469.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 7connectdetailsthumb](https://docs.sisense.com/main/Resources/Images/8-7connectdetailsthumb0300.png)