log4net appender logging to snowflake table

Question

I'm trying to use log4net appender and log into snowflake table. But it's not working. Not sure what the connectiontype should be. Below the code I have tried.

<appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender">
      <bufferSize value="1" />
      <reconnectonerror value="true" />
      <connectionString value="scheme=https;ACCOUNT=<account>;HOST=<host>;port=<port>; ROLE=<role>;WAREHOUSE=<warehouse>; USER=<user>; PASSWORD=<password>;DB=<db>;SCHEMA=<schema>"/>
      <commandText value="Insert into log_messages (log_date, log_thread, log_level, log_logger, log_class, log_method, log_username, log_message, log_exception, log_stacktrace, log_stacktracedetail, appfree1, appfree2, appfree3) values (@log_date, @thread, @log_level, 'logger', @class, @method, @username, @message, @exception, @stacktrace, @stacktracedetail, @appfree1, @appfree2, @appfree3) " />
      <parameter>
        <parameterName value="@log_date" />
        <dbType value="DateTime" />
        <layout type="log4net.Layout.PatternLayout" value="%date{yyyy-MM-ddTHH:mm:ss.fff}" />
      </parameter>
      <parameter>
        <parameterName value="@thread" />
        <dbType value="String" />
        <size value="255" />
        <layout type="log4net.Layout.PatternLayout">
          <conversionPattern value="%thread" />
        </layout>
      </parameter>
      .
      .
    </appender>

How can I log into the table in snowflake ? Is there any other way to do this