Hi Kunal, Thanks for your message. jOOQ correctly generates LENGTH(column) for Snowflake, see: https://www.jooq.org/doc/latest/manual/sql-building/column-expressions/string-functions/length-function/
You probably didn't configure the SQLDialect correctly with your jOOQ configuration. Best Regards, Lukas On Mon, Oct 21, 2024 at 11:33 AM Kunal Ghosh <kunal.raj...@gmail.com> wrote: > Hi Lukas, > Thank you Lukas, > How do I use the length function of the Snowflake dialect in Jooq? I have > used length(column), but Jooq has generated char_length in sql. > > Kunal > > On Thursday, October 17, 2024 at 1:13:02 PM UTC+5:30 lukas...@gmail.com > wrote: > >> You don't need a "snowflake jar". Snowflake is just a SQLDialect like any >> other: >> https://www.jooq.org/javadoc/latest/org.jooq/org/jooq/SQLDialect.html >> >> I'll be happy to answer any further, specific questions >> Lukas >> >> On Thu, Oct 17, 2024 at 9:41 AM Kunal Ghosh <kunal....@gmail.com> wrote: >> >>> Hi Lukas, >>> >>> But, how? I have already downloaded the enterprise trial >>> (jOOQ-3.19.13.zip), and there was no snowflake jar present. Please guide me. >>> >>> >>> On Thursday, October 17, 2024 at 11:14:51 AM UTC+5:30 lukas...@gmail.com >>> wrote: >>> >>>> Hi Kunal, >>>> >>>> Yes, you can. >>>> >>>> Best regards, >>>> Lukas >>>> >>>> >>>> On Thursday, October 17, 2024, Kunal Ghosh <kunal....@gmail.com> wrote: >>>> >>>>> Can I test Snowflake and Google BigQuery dialects using the enterprise >>>>> trial version? >>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "jOOQ User Group" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to jooq-user+...@googlegroups.com. >>>>> To view this discussion on the web visit >>>>> https://groups.google.com/d/msgid/jooq-user/96888733-d27b-4569-a7a2-86606a3ee78dn%40googlegroups.com >>>>> <https://groups.google.com/d/msgid/jooq-user/96888733-d27b-4569-a7a2-86606a3ee78dn%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> >>>> -- >>> You received this message because you are subscribed to the Google >>> Groups "jOOQ User Group" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to jooq-user+...@googlegroups.com. >>> >> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/jooq-user/06f48168-0b2c-4821-841d-57791766d6dfn%40googlegroups.com >>> <https://groups.google.com/d/msgid/jooq-user/06f48168-0b2c-4821-841d-57791766d6dfn%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to jooq-user+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/jooq-user/0fe0a4d4-cdd0-4c7e-b89c-8cea4193cfe5n%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/0fe0a4d4-cdd0-4c7e-b89c-8cea4193cfe5n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO5T14Qy%3DPE_sg7u8%2Bg%2BxcC6DKc84uXNS_qYukmV2Sa%2Brw%40mail.gmail.com.
