topic Re: tDbrow snowflake multiple queries in Talend Studio

tDbrow snowflake multiple queries

AbiJeev — Fri, 15 Nov 2024 23:36:19 GMT

Hi,

I have some 10 queries with creating temp tables ,insert,update, drop temp tables and am giving that in single tdbrow with pre existing connection. Before that in same connection I gave alter session multi_statement_count =0, when I run the query first time throwed error "Query executed successfully, but it returned an update count, result set required" ,then one time it ran and now its giving same error.

I tried removing parts of query too. But queries running in snowflake fine. Only through Talend am facing issue.zCan someone explain pls.

Re: tDbrow snowflake multiple queries

Anonymous — Fri, 22 Oct 2021 07:37:17 GMT

Hello,

Could you please clarify in which Talend version/edition you are?

We found a similar issue in release v 7.3.1 about Snowflake multi statement execution error and this issue is fixed 7.3.2, 7.3.1-R2020-05, 8.0.1

With any subscription solution, please contact talend support team for a fixed patch.

Best regards

Sabrina

Re: tDbrow snowflake multiple queries

Anonymous — Fri, 22 Oct 2021 08:01:26 GMT

Hello,

Could you please clarify in which Talend version/edition you are?

We found this issue in release v 7.3.1 about Snowflake multi statement execution error and this issue is fixed 7.3.2, 7.3.1-R2020-05, 8.0.1

With any subscription solution, please contact talend support team to ask for a fixed patch.

Best regards

Sabrina

Re: tDbrow snowflake multiple queries

AbiJeev — Fri, 22 Oct 2021 11:32:29 GMT

Ya am using 7.3.1. Is there any work around for this in this version

Re: tDbrow snowflake multiple queries

AbiJeev — Fri, 22 Oct 2021 15:30:29 GMT

To be precise am using Talend Real Time Big data platform (R2021-03-7.3.1)

Re: tDbrow snowflake multiple queries

Anonymous — Mon, 25 Oct 2021 04:31:47 GMT

Hello,

Please create a support case on talend support portal so that our colleagues from support team will deliver a fixed patch to you through support cycle with priority.

Best regards

Sabrina

Re: tDbrow snowflake multiple queries

Rama4 — Thu, 07 Jul 2022 23:46:24 GMT

How to use Session variable in tSnowflakeRow component ?

Example :

SET NumOfRows = IFNULL((SELECT COUNT(*) FROM EDWBIRPT.dbo.Appraisal_R),0);

SET StartDate =

CASE $NumOfRows

WHEN 0 THEN DATE_TRUNC(month,DATEADD(month,-24,current_date()))

ELSE DATE_TRUNC(month,DATEADD(month,-1,current_date()))

END;

When I use this statement I am getting below error message:

[ERROR] 16:34:38 org.talend.components.snowflake.runtime.SnowflakeRowStandalone- Query execution has failed. Please validate your query.

net.snowflake.client.jdbc.SnowflakeSQLException: SQL compilation error: error line 25 at position 9

Session variable '$NUMOFROWS' does not exist

Re: tDbrow snowflake multiple queries

Anonymous — Mon, 11 Jul 2022 04:30:00 GMT

Hello,

I'm not sure that the support of Session variable has been already added into tDBRow component and will check it with our component team for further confirmation.

How about using context variable in your global sql queries (tsnowflakeInput) component?

You are able to define your query as:

"SELECT * FROM mytable WHERE column1 = "+context.myvariable

Best regards

Sabrina