Skip to main content

Amazon Redshift

The Amazon Redshift connection lets FunnelStory query your Redshift cluster or Serverless workgroup with read-only SQL to power data models—often used for warehouse-native account and revenue facts.

What FunnelStory uses it for

  • Data models — PostgreSQL-compatible SQL against tables and views you expose to the FunnelStory database user.

Before you connect

  • Network — The cluster must accept connections from FunnelStory’s static egress IPs (Allowed IP addresses), or you route access via a network path your team manages (for example VPN + bastion patterns may require SSH tunnels to an intermediate host).
  • User — Create a Redshift user with SELECT on the schemas FunnelStory should read (no write or admin rights required).

Add the connection in FunnelStory

  1. Open Configuration → ConnectionsAdd connection, then choose Amazon Redshift (or Redshift as labeled).

  2. Complete the fields in the connection form:

Amazon Redshift connection form

FieldDescription
Connection nameDisplay name.
HostRedshift endpoint hostname.
PortUsually 5439.
DatabaseDatabase name.
UsernameRedshift user.
PasswordRedshift password.
  1. Click Validate, then Add Connection.

After you connect

Attach to models and write Redshift-compatible SQL. See Writing queries.