executing a query in Snowflake

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)
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

Seven Stars

Re: executing a query in Snowflake

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

 

Snowflake_ManualQuery.PNGSnowflake1.PNG

Thirteen Stars

Re: executing a query in Snowflake

Hi,

 

what's wrong with -  tSnowFlakeRow ?

 

regards

-----------
Seven Stars

Re: executing a query in Snowflake

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.

Thirteen Stars

Re: executing a query in Snowflake


@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

-----------
Seven Stars

Re: executing a query in Snowflake

It was not working on the previous version.

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

Cheers,

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads