Talend - Snowflake Connectivity

[Anonymous]

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?

[manodwhb · Accepted solution]

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.