Talend big data tSnowflakeOutput could not select tabels

Highlighted
Four Stars

Talend big data tSnowflakeOutput could not select tabels

I'm loading multiple tables from Access to Snowflake. I could select table from tAccessInput but could not select output table in tSnowflakeOutput. The selection button is been disabled.

How to load data into multiple tables using one tSnowflakeConnection?

Capture.PNG


Accepted Solutions
Highlighted
Employee

Re: Talend big data tSnowflakeOutput could not select tabels

Do you mean you are seeing this:

SnowFlake.jpg

 

If yes, then click on the button with the 3 dots....  you will get the dialog below where you can specify a custom object.

 Snowflake2.jpg

 

However, if you are working on standard object that exist in the list, it is preferable that you select the object, than specify custom object.  Snowflake component leverage avro schema under the hood.  Hence, it is more sensitive than a normal flat schema.  This custom object may or may not work for your use case.  Let us know.

 

View solution in original post

Highlighted
Employee

Re: Talend big data tSnowflakeOutput could not select tabels

It is because your are using the connection data from the repository.  I was showing a screenshot in built-in mode.

The component behaves differently depending on whether you are in repository or built-in mode.

View solution in original post


All Replies
Highlighted
Employee

Re: Talend big data tSnowflakeOutput could not select tabels

Do you mean you are seeing this:

SnowFlake.jpg

 

If yes, then click on the button with the 3 dots....  you will get the dialog below where you can specify a custom object.

 Snowflake2.jpg

 

However, if you are working on standard object that exist in the list, it is preferable that you select the object, than specify custom object.  Snowflake component leverage avro schema under the hood.  Hence, it is more sensitive than a normal flat schema.  This custom object may or may not work for your use case.  Let us know.

 

View solution in original post

Highlighted
Four Stars

Re: Talend big data tSnowflakeOutput could not select tabels

In my case, this select button is been disabled. 

I changed database in Snowflake and reset connection, same issue.

Capture.PNG

Highlighted
Employee

Re: Talend big data tSnowflakeOutput could not select tabels

It is because your are using the connection data from the repository.  I was showing a screenshot in built-in mode.

The component behaves differently depending on whether you are in repository or built-in mode.

View solution in original post

Highlighted
Four Stars

Re: Talend big data tSnowflakeOutput could not select tabels

what's the difference between built-in and repository?

Highlighted
Moderator

Re: Talend big data tSnowflakeOutput could not select tabels

Hi,


@decu wrote:

what's the difference between built-in and repository?


 

In built-in mode, all information is stored locally in the Job. You can enter and edit all information manually.

In repository mode, all information is stored in the repository.

For more information, please have a look at this topic:https://community.talend.com/t5/Troubleshooting-Development/What-is-the-difference-between-Built-In-....

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.

2019 GARTNER 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

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog