topic Where to input - Alter Session MULTI_STATEMENT_COUNT in Talend Studio

Where to input - Alter Session MULTI_STATEMENT_COUNT

caz2 — Fri, 15 Nov 2024 22:20:27 GMT

I am using tDBRow to query Snowflake but there are a couple of queries separated by semi colon. I know I need to set the MULTI_STATEMENT_COUNT to allow the multiple queries to run ok, but I don't know where to set it.

Is it in the snowflake connection tDBConnection and if so where? I tried it on Advanced Settings - Additional JDBC Parameters but it didn't like that statement.

Re: Where to input - Alter Session MULTI_STATEMENT_COUNT

Anonymous — Wed, 23 Nov 2022 02:57:52 GMT

Hello @Carolyn Foster ,

You can use 2 tDBRow components to achieve the goal.

In the first tDBRow , setup the MULTI_STATEMENT_COUNT parameter like the below

"alter session set multi_statement_count=0;"

in the 2nd tDBRow, setup the multiple queries separated by semi like the below

Re: Where to input - Alter Session MULTI_STATEMENT_COUNT

caz2 — Wed, 23 Nov 2022 09:09:25 GMT

Perfect - thank you