Is there a way to connect ataccama One Web to a private Redshift?
Page 1 / 1
Hi
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://redshiftdb.com:5439/dev;fetchRingBufferSize=1M
Please feel free to raise a support ticket if you’re continuing to have any troubles.
Reply
Login to the Ataccama Community
No account yet? Create an account
For Ataccama Customers and Partners
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.