ONE Web connection to amazon Redshift

  • 9 March 2023
  • 1 reply

Is there a way to connect ataccama One Web to a private Redshift?



Best answer by Cansu 14 March 2023, 12:20

View original

1 reply

Userlevel 6
Badge +7

Hi @Macarena, welcome to the community!

May I ask if you’ve tried the troubleshooting steps?

Amazon Redshift driver has buffer size set to 2 GB by default. Results of Redshift queries are buffered into ONE Desktop process memory, which has reserved size of 1 GB. In order to prevent possible memory issues with data intensive queries we recommend decreasing the size of the buffer by adding the following parameter to your Redshift connection string:

fetchRingBufferSize=1M sets the ring buffer size to 1 MB, which should be sufficient for most usability scenarios.

Example of a Redshift connection string:  jdbc:redshift://;fetchRingBufferSize=1M


Please feel free to raise a support ticket if you’re continuing to have any troubles.