SnowSQL in Talend

[Anonymous]

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

[Anonymous · Accepted solution]

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