Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
FMDF
Contributor III
Contributor III

Redshift connection parameters

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?

Labels (5)
1 Solution

Accepted Solutions
FMDF
Contributor III
Contributor III
Author

1 Reply
FMDF
Contributor III
Contributor III
Author