"Latest" documentation on docs.aws.amazon.com is out of date.

[alainbryden]

First, let me say you've been doing great work on v2.0+ of this driver, we've had a number of performance and memory issues using the old 1.4.65 driver for ETL, and the new compression option is very promising for us.

Problem description

Upgrading versions has been a struggle for us, because the "latest" documentation available for the ODBC driver is for v1.5.9.
Even if we start from https://docs.aws.amazon.com/redshift/latest/mgmt/odbc20-install.html - which is the page dedicated to ODBC driver version 2.x, the first link Configuring an ODBC connection leads to a page and the Redshift ODBC configuration guide which is for the older version.

For us, the biggest impact was that we tried following along this guide to set up the fetch size parameter described on page 113, but found that this option didn't exist in the latest installer. After a ton of searching, I came across this documentation for the JDBC driver stating "Fetch size is not supported for ODBC.":

This seemed like a very odd regression to me (and a very misleading statement to make when the option did in fact exist in the older driver version). It wasn't until extensive searching that I came across this repo, and this issue: #15 wherein you mentioned "A similar option is available in 'Cursor' Tab under 'Streaming Cursor' section.". I don't think I'm exaggerating when I say this is the only place on the internet where this information has been imparted. It doesn't even appear on the odbc20 configuration options page, which otherwise appears to mention many of the new options (like compression)

I know you might not have a ton of control over the content over at docs.aws.amazon.com, but I think it's appropriate to keep an issue open here as a reminder that someone somewhere needs to get on top of it.

Thanks again for your work

---

Probably not relevant for purposes of this ticket, but this is me:

• Driver version: 2.1.3.0
• Redshift version PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3), Redshift 1.0.71629
• Client Operating System: Windows Server 2019

[vahid110]

Hi @alainbryden
Thank you for taking the time to report this issue. I appreciate your effort and will make sure it reaches the appropriate team for investigation as soon as possible.