How to configure timeout settings for the Snowflake, Drill and Dremio connectors in TIBCO Spotfire

How to configure timeout settings for the Snowflake, Drill and Dremio connectors in TIBCO Spotfire

From TIBCO Spotfire Analyst version 10.9, it is possible to add and configure timeout setting for the Snowflake, Drill and Dremio Connectors. This is done by adding the setting "CommandTimeoutInSeconds" to Spotfire.Dxp.Main.dll.config file, located in the folder <Spotfire Analyst installation dir>\Modules\Spotfire DXP Forms_xxx.

Note: settings of this kind are overwritten when you update TIBCO Spotfire Analyst (to a new version, or just with a new hotfix), so you will need to configure this again after updates.   How to add the CommandTimeoutInSeconds setting:
1. Go to folder "<Spotfire installation directory>\Modules\Spotfire DXP Forms_xxx" and open file Spotfire.Dxp.Main.dll.config in a text editor.
2. Copy and add the line

<section name="Spotfire.Dxp.Data.Adapters.Odbc.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false"/>

 in the following location:
 

<sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
     ...
 <section name="Spotfire.Dxp.Data.Adapters.Odbc.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false"/>
    </sectionGroup>

3. Copy and add the setting 

<Spotfire.Dxp.Data.Adapters.Odbc.Properties.Settings>
        <setting name="CommandTimeoutInSeconds" serializeAs="String">
            <value>[desired timeout in seconds]</value>
        </setting>
    </Spotfire.Dxp.Data.Adapters.Odbc.Properties.Settings>

in the following location:

<applicationSettings>
    ...
    <Spotfire.Dxp.Data.Adapters.Odbc.Properties.Settings>
        <setting name="CommandTimeoutInSeconds" serializeAs="String">
            <value>[desired timeout in seconds]</value>
        </setting>
    </Spotfire.Dxp.Data.Adapters.Odbc.Properties.Settings>
</applicationSettings>

4. In this setting, replace "[desired timeout in seconds]" with timeout specified in seconds. The timeout is 1800 seconds (30 minutes) by default. 
5. Save and close the file.
6. Restart TIBCO Spotfire Analyst.   keywords: snowflake, drill, dremio, connector, timeout, CommandTimeoutInSeconds