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

Four Stars

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

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

Moderator

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

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

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

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

Employee

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

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

 

Employee

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

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 :studio.png

 

 

 

TIC connection :

TIC.png

 

 

Tic Flow : the connection is displayed in the flow.flow.png

 

 

 

Thanks,

RekhaSree

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Self-service Talend Migration: Moving from On-Premises to the Cloud

Move from On-Premises to the Cloud by following the advice of experts

Read Now

Modern Data Engineering in the Cloud

Learn about modern data engineering in the Cloud

Watch Now

How to deploy Talend Jobs as Docker images to Amazon, Azure and Google Cloud reg...

Learn how to deploy Talend Jobs as Docker images to Amazon, Azure and Google Cloud registries

Blog