Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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