Spring Batch Integration with Snowflake

[AmuthaKondusamy]

Hello everyone,

We are currently using Spring Batch in our application with an Oracle database connected via the Oracle driver. However, we are in the process of migrating our database from Oracle to Snowflake. After reconfiguring the database connection to Snowflake, we have encountered an issue.

It seems that Spring Batch does not yet support a connection to Snowflake. The framework has a predefined list of supported databases in the DatabaseType.java class, and Snowflake is not included.

You can check the list here:
https://github.com/spring-projects/spring-batch/blob/main/spring-batch-infrastructure/src/main/java/org/springframework/batch/support/DatabaseType.java

Can someone provide an update on when Snowflake support might be added to Spring Batch, or suggest a workaround to enable the connection to Snowflake?

[fmbenhassine]

There is no plan to support Snowflake, but if its DDL syntax is close enough to oracle, you can try to set it as an oracle database. Here is the section of the docs that explains how to do that: https://docs.spring.io/spring-batch/reference/job/configuring-repository.html#nonStandardDatabaseTypesInRepository.

Have you tried that?