Snowflake .NET Driver Logging

This page walks through how to enable Snowflake .NET driver logging in Redpoint Interaction v6.x.

Open Resonance.ExecutionService.exe.config in a text editor.

Locate the <configSections> section.

Add <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net"/> . For example:

XML

<configSections>
    <section 
        name="log4net" 
        type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" />
</configSections>

Add the <log4net> entry within the <configuration> section. For example:

XML

<log4net>
    <appender name="RPISnowflakelogger" type="log4net.Appender.RollingFileAppender">
        <file value="snowflake_dotnet.log" />
        <appendToFile value="true" />
        <rollingStyle value="Size" />
        <maximumFileSize value="10MB" />
        <staticLogFileName value="true" />
        <maxSizeRollBackups value="10" />
        <layout type="log4net.Layout.PatternLayout">
            <!-- <header value="[DateTime] [Thread] [Level] [ClassName] Message&#13;&#10;" /> -->
            <conversionPattern value="[%date] [%t] [%-5level] [%logger] %message%newline" />
        </layout>
    </appender>

    <root>
        <level value="ALL" />
        <appender-ref ref="RPISnowflakelogger" />
    </root>
</log4net>

Log level can be set up within <level value="ALL" /> with the following values. The default value is ALL.
- ALL
- DEBUG
- INFO
- WARN
- ERROR
- FATAL
- OFF
Save the file then restart the execution service.

Refer to the Snowflake Connector for .NET GitHub page for additional information.