Snowflake and Google BigQuery dialects

Kunal Ghosh

unread,

Oct 17, 2024, 1:43:52 AM10/17/24

to jOOQ User Group

Can I test Snowflake and Google BigQuery dialects using the enterprise trial version?

Lukas Eder

unread,

Oct 17, 2024, 1:44:51 AM10/17/24

to jooq...@googlegroups.com

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+unsubscribe@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.

Kunal Ghosh

unread,

Oct 17, 2024, 3:41:37 AM10/17/24

to jOOQ User Group

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.

Screenshot 2024-10-17 114628.png

Lukas Eder

unread,

Oct 17, 2024, 3:43:02 AM10/17/24

to jooq...@googlegroups.com

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

To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/06f48168-0b2c-4821-841d-57791766d6dfn%40googlegroups.com.

Kunal Ghosh

unread,

Oct 21, 2024, 5:33:29 AM10/21/24

to jOOQ User Group

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

Lukas Eder

unread,

Oct 21, 2024, 5:35:32 AM10/21/24

to jooq...@googlegroups.com

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

To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/0fe0a4d4-cdd0-4c7e-b89c-8cea4193cfe5n%40googlegroups.com.

Kunal Ghosh

unread,

Oct 21, 2024, 7:00:49 AM10/21/24

to jOOQ User Group

Hi Lukas,
Yes, I haven't configured the SQLDialect with my jOOQ configuration.

Thanks for your information.