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?