topic Re: How to connect to snowSQL with tSystem in Talend in Talend Studio

How to connect to snowSQL with tSystem in Talend

AMale — Thu, 14 Mar 2024 21:58:33 GMT

Hi everyone,

I have a problem with the tSystem component in Talend. I'm trying to connect to snowsql with tSystem.

But my problem is : after puting 'snowsql -a ACOUNT -u USER' like this

And as you can see, I also put in my password. The problem is, when you try to connect to snowsql it is not in 1 step, but 2.
First the command 'snowsql -a ACOUNT -u USER' then you enter your password when powershell ask you to.

When I run the tSystem showed before, I have this error message :

Where behind the blue is my real password.

How can I fix this to succesfully connect to snowsql please ?

The real goal is then to run a 'PUT file into a interne stage' in Snowflake with Powershell.

Thanks !

Re: How to connect to snowSQL with tSystem in Talend

Xiaodi_Shi — Fri, 15 Mar 2024 06:58:32 GMT

Hello,

Could you please let us know if this support article help for your case?

https://community.qlik.com/t5/Official-Support-Articles/Can-I-execute-multiple-commands-at-one-time-with-a-tSystem/ta-p/2150649

Best regards

Sabrina

Re: How to connect to snowSQL with tSystem in Talend

AMale — Fri, 22 Mar 2024 09:19:08 GMT

Hello Sabrina
Indeed, using the "Use Sungle Command" option with your solution I no longer have any errors on my Talend's terminal.
I have this :

But this still cannot PUT my local files on my Computer, to the INTERNAL STAGE of Snowflake.

I also tried to use the command I use on my tSystem component directly on PowerShell.
Like this : cmd c / " my commands "

As you can see, on Powershell it still ask me for the password "in prompt".

Do you have an idea to solve this on Talend please ?

Best regards

Alexis

Re: How to connect to snowSQL with tSystem in Talend

AMale — Tue, 09 Apr 2024 10:05:28 GMT

Hi everyone,

For the records, my objective was to send files from a local environnement ( VM or local computer ) to Snowflake.
I though I had to pass only by snowSQL on PowerShell, that's why I was thinking of the tSystem component on Talend. I did'nt succed to use the tSystem component.

Anyway, It is possible to do it by SSH, by using the tDBOutputBulk component or just a tDBRow with the PUT command inside.

Thank you Sabrina for your help.

Best regards,

AMale