Is there a way to connect ataccama One Web to a private Redshift?
Solved
ONE Web connection to amazon Redshift
- Data Voyager
Best answer by Cansu
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.
+3- Community Manager
- 625 replies
- 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
Most Liked this week
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.