Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thank you for your replay, unfortunately I have to execute all the query throw talend
You could try using tJDBCRow
You can just use a tSnowflakeInput with Manual Query then send the output to a tJavaRow with a dynamic schema
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.
@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?
cheers