Redshift connection parameters

FMDF — Sat, 16 Nov 2024 17:44:58 GMT

I have the following connection string...

CUSTOM CONNECT TO "provider=QvOdbcConnectorPackage.exe;driver=redshift;server=<clustername>;port=5439;Database=<devname>;SSLMode=prefer;UseSystemTrustStore=false;UseDeclareFetch=1;Fetch=200;ArraySize=10000;MaxVarcharSize=262144;"

It does connect. I know from my oracle connection strings that FetchSize can significantly impact performance.

I cannot find a list of all these parameters for Redshift. I see this one has a param called "Fetch" and "ArraySize" but I cannot locate any documentation on what they are and how they affect the connection.

Anyone happen to know or have a link to the documentation for these?

What is Fetch? Is it the same as FetchSize in Oracle?

Re: Redshift connection parameters

FMDF — Thu, 03 Dec 2020 16:31:41 GMT

I think I found it. Redshift is really a postGres db.

https://www.simba.com/products/PostgreSQL/doc/ODBC_InstallGuide/mac/content/odbc/re/options/ui/declarefetchmode.htm

topic Re: Redshift connection parameters in App Development

Redshift connection parameters

Re: Redshift connection parameters