Five Stars

executing a query in Snowflake

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

 

Tags (1)
3 REPLIES
Eight Stars

Re: executing a query in Snowflake

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
Five Stars

Re: executing a query in Snowflake

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

Four Stars

Re: executing a query in Snowflake

You could try using tJDBCRow