topic Re: executing a query in Snowflake in Talend Studio

executing a query in Snowflake

aisbel — Tue, 20 Feb 2018 10:54:31 GMT

Hi,

Is there a way to execute a query in snowflake, for example creating or dropping a table

I need to suspend my warehouse by executing "ALTER WAREHOUSE "MY_WHAREHOUSE" SUSPEND;".

Best Regards

Re: executing a query in Snowflake

lojdr — Tue, 20 Feb 2018 14:18:56 GMT

Hello,

Not sure if there is a component for it in Talend, but you can install SnowSQL locally and call the command from the local/dedicated machine as an CLI command.

Regards
Lojdr

Re: executing a query in Snowflake

aisbel — Mon, 26 Feb 2018 07:38:50 GMT

Thank you for your replay, unfortunately I have to execute all the query throw talend

Re: executing a query in Snowflake

akelly — Thu, 05 Apr 2018 00:12:09 GMT

You could try using tJDBCRow

Re: executing a query in Snowflake

Anonymous — Wed, 30 Jan 2019 23:07:43 GMT

You can just use a tSnowflakeInput with Manual Query then send the output to a tJavaRow with a dynamic schema

Re: executing a query in Snowflake

vapukov — Thu, 31 Jan 2019 02:26:57 GMT

Hi,

what's wrong with - tSnowFlakeRow ?

regards

Re: executing a query in Snowflake

Anonymous — Thu, 31 Jan 2019 03:14:26 GMT

For every other databases, I usually got the tXXXRow but with Snowflake, you need to have an output specified while it wasnt the case on tSnowflakeInput. Some of those queries ALTER etc.. doesnt return anything therefore it will make the tSnowflakeRow failed.

After, it will be nice to retry the behavior on the new 7.1 and compare it.

Re: executing a query in Snowflake

vapukov — Thu, 31 Jan 2019 04:05:36 GMT

@AdrienAussie wrote:

For every other databases, I usually got the tXXXRow but with Snowflake, you need to have an output specified while it wasnt the case on tSnowflakeInput. Some of those queries ALTER etc.. doesnt return anything therefore it will make the tSnowflakeRow failed.

After, it will be nice to retry the behavior on the new 7.1 and compare it.

Hi,

sorry, I can't understand - what wrong with tSnowFlakeRow?

DROP TABLE example

same with JDBCRow

cheers

Re: executing a query in Snowflake

Anonymous — Thu, 31 Jan 2019 04:12:59 GMT

It was not working on the previous version.

Talend did a lot of work on Snowflake connectivity in the past 3-4 versions.

Cheers,