-
Notifications
You must be signed in to change notification settings - Fork 2.4k
Spring Batch Integration with Snowflake #4768
-
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?
Beta Was this translation helpful? Give feedback.
All reactions
Replies: 1 comment
-
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?
Beta Was this translation helpful? Give feedback.