Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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