topic Snowflake connection: Pre defined context variable naming convention for Talend Integration Cloud in Talend Studio

Snowflake connection: Pre defined context variable naming convention for Talend Integration Cloud

Anonymous — Sat, 16 Nov 2024 09:02:09 GMT

Hi,

Can someone please help me with the naming conventions of context variables that follow connection_parameters for a Snowflake connection.

I have created a snowflake connection in my talend job, but when i publish it to cloud, i am NOT able to select/link the snowflake connection defined in Cloud

Re: Snowflake connection: Pre defined context variable naming convention for Talend Integration Cloud

Anonymous — Fri, 24 Nov 2017 09:04:50 GMT

Hello,

Please refer to this online document about:TalendHelpCenter:Adding context connection parameters to the Job to see if it is what you are looking for?

Best regards

Sabrina

Re: Snowflake connection: Pre defined context variable naming convention for Talend Integration Cloud

Anonymous — Mon, 27 Nov 2017 06:12:04 GMT

Hi Sabrina,

I have gone through this document, but this didn't help. Since context connection parameters need to follow strict naming conventions like for salesforce context parameter for user name should be 'connection_salesforce_basic_username'. I did NOT find the such names for Snowflake connection parameters. I tried creating context parameters with names like 'connection_snowflake_userId' etc. but when i publish this job to Talend Integration Cloud, the Snowflake connection defined in the Cloud is NOT able to pass values to context connection parameters of the Talend job.

So i am looking for exact names of the context connection parameters

Regards

Saurabh

Re: Snowflake connection: Pre defined context variable naming convention for Talend Integration Cloud

Anonymous — Mon, 27 Nov 2017 17:44:41 GMT

Hi Saurabh,

TIC uses very strict naming conventions for all the parameters. The syntax for native connections must start with 'Connection_<application name>_<parameter_name>'. You might want to use this only if you are using the native connectors provided by TIC.

As snowflake connection are not yet part of the native connectors, you need to use user defined parameters. the syntax for user defined parameters is 'Parameter_<parameter name>. See the link given below for details.

https://help.talend.com/reader/Mav4Vp0qD5Scvag1kN90pA/mlNjwb5d5bGkY9emOuyixg

Regards,

RekhaSree

Re: Snowflake connection: Pre defined context variable naming convention for Talend Integration Cloud

Anonymous — Wed, 29 Nov 2017 06:24:54 GMT

Hi Saurabh,

to use connections, create the custom component with snowflake type. I have done as follows and i am able to connect to snowflake.

Studio :

TIC connection :

Tic Flow : the connection is displayed in the flow.

Thanks,

RekhaSree