Forum Discussion

krish003's avatar
krish003
Frequent Visitor
8 years ago
Solved

redshift Connection (Fatal Error: Too many connections for the User)

  I was able to sucessfully connect to Redshift DB but, when I select multiple tables at once and tried to import them into the model, I get error as follows:   This problem persists if I made...
General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    krish003,

    Based on my research, amazon redshift has per-user connection limit, please check that if you have hit the limitation, you can review this online article to get more details.

    Also please check that if there are any locks or active transaction on the data source side, there is a similar thread for your reference.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

krish003,

Based on my research, amazon redshift has per-user connection limit, please check that if you have hit the limitation, you can review this online article to get more details.

Also please check that if there are any locks or active transaction on the data source side, there is a similar thread for your reference.

Regards,
Lydia

krish003's avatar
krish003
Frequent Visitor
8 years ago

Anonymous 

 

 Thanks for the prompt response,

 

I was able to find the work around for refreshing the tables without any errors by  Disabling-Parallel-Loading of tables from options.

 

Regards,

Krish