topic SnowSQL in Talend in Talend Studio

SnowSQL in Talend

Anonymous — Wed, 17 Apr 2019 01:32:14 GMT

Hello,

Trying to execute SnowSQL command ( COPY INTO <TABLE> FROM @MYSTAGE) to copy the data from external Stage (S3) to the table in Snowflake using tJDBCROW component in Talend.

However it is not recognizing it as STAGE and trying to read as table and throws error. Is there any specific way to execute the SNOWSQL in Talend.

Thanks !!

Re: SnowSQL in Talend

Anonymous — Wed, 17 Apr 2019 07:25:03 GMT

Hello,

Could you please have a look at tSnowflakeRow component which executes the SQL command stated onto a specified Snowflake database.

For more information, please have a look at this component reference about:https://help.talend.com/reader/y5mRXjwqYsWmZFUNfjYtSQ/m1tdAb75Q_Cp_l_OS_s_Jw

Best regards

Sabrina