KNOWLEDGE BASE

Error "Too Many Connections" When Connecting to Amazon Redshift


Published: 01 Oct 2018
Last Modified Date: 23 May 2019

Issue

When connecting to Amazon Redshift data source, the following error might occur: 

'Error occurred while trying to connect: FATAL: too many connections for user "[username]"'

Environment

  • Tableau Desktop
  • Amazon Redshift

Resolution

Amazon Redshift has per-user connection limit. When the limit is reached, subsequent connection attempts will fail. It is recommended to restrict the number of connections per user and per database

Cause

Amazon Redshift limits the number of connections per cluster and per database user. 
Did this article resolve the issue?