Talend big data tSnowflakeOutput could not select tabels

[Anonymous]

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?

[Anonymous · Accepted solution]

Do you mean you are seeing this:

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

 

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.

[Anonymous]

In my case, this select button is been disabled. 

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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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