tDbrow snowflake multiple queries

[AbiJeev]

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.

[Anonymous]

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

[Anonymous]

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

[AbiJeev]

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

[AbiJeev]

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

[Anonymous]

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

[Rama4]

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

[Anonymous]

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