Workato · On-prem agent

Snowflake JDBC driver internal error (ArrowBuf.getDirectBuffer)

Short answer

This error appears on a select query in a custom SQL action against Snowflake through the on-prem agent. Add &JDBC_QUERY_RESULT_FORMAT=JSON to the connection URL.

VerifiedLast verified

01Error text

Workato error
JDBC driver internal error: exception creating result java.lang.ExceptionInInitializerError at net.snowflake.client.jdbc.internal.apache.arrow.memory.ArrowBuf.getDirectBuffer(ArrowBuf.java:231).: XX000

02Likely causes

  • The error occurs on a select query in a custom SQL action when the Snowflake JDBC driver returns results in Arrow format.

03How to fix it

  1. Add &JDBC_QUERY_RESULT_FORMAT=JSON to the connection URL. This is the recommended fix.
  2. Or use an older Snowflake JDBC driver, for example 3.9.2.
  3. Restart the agent and rerun the job.

04Official documentation

Test every fix in a non-production environment before you apply it to production. See how entries are verified.

More for Workato work:Open Workato jobsWorkato rates and salariesHire a senior Workato developer

The iPaaS Brief

Subscribe to The iPaaS Brief.

The iPaaS newsletter for the people who run integrations. From iPaaS Group.

Free. You finish on theipaasbrief.com and confirm by email.