Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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