Is there a way to connect ataccama One Web to a private Redshift?
Best answer by Cansu
View original
Userlevel 6
+7
- Community Manager
- 244 replies
-
14 March 2023
- Answer
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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.