Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
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
Hello,
Could you please let us know if this support article help for your case?
Best regards
Sabrina
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
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