topic Talend - Snowflake Connectivity in Talend Studio

Talend - Snowflake Connectivity

Anonymous — Sat, 13 Apr 2019 18:42:52 GMT

Hello,

I have 2 questions on Talend -> Snowflake.

1. What type of data transfer Mechanism/connection is established from On Prem Talend to Snowflake ( Something like DIrect connect ?)

2. When we load directly into Snowflake tables using Native connection, does snowflake create any internal stage?

Re: Talend - Snowflake Connectivity

manodwhb — Mon, 15 Apr 2019 05:21:26 GMT

Hi @Gopik ,

1) From on premise Talend to Snowflake would be direct connection and it would be established based on Account name, user name,password,warehouse name,schema name and DB name.

2) when you trying to load into snowflake it will create temp tables internal to snowflake and will push to main table/ordinal table.