Skip to main content

​
Overview

To set up connection with Redshift, Statsig needs the following information
  • Cluster Endpoint
  • A service user Username
  • A service user Password
  • A staging schema that Statsig can write results to
SHA256 passwords are not currently supported, please utilize MD5 to avoid issues.
You can find this information in your aws console within your specific cluster, as shown in the image below. (Open image in new tab for a bigger image). The service user should be able to read necessary experiment data, and be able to write to the Statsig staging schema you specify.
Frame 1
When you save the connection, we will run a series of tiny commands to test permissions — e.g. creating a temp table, running a select/delete statement on that table, and then dropping that table.
The provided Service Account will require the following attributes: enable_case_sensitive_identifier, enable_case_sensitive_super_attribute. If these are not already set, Statsig will set them to TRUE upon setup completion.

​
SSH Tunneling

For Redshift connections, we also allow users to create an SSH tunnel into their Redshift cluster for a more secure and private access to the database. To enable access, Statsig requires:
  • SSH Host
  • SSH Port
  • SSH User
Statsig will use this information to generate an SSH key. Please add this generated key to your ~/.ssh/authorized_keys file on your SSH proxy machine to enable SSH tunneling.

​
What IP addresses will Statsig access data warehouses from?

See FAQ