topic Talend big data tSnowflakeOutput could not select tabels in Talend Studio

Talend big data tSnowflakeOutput could not select tabels

Anonymous — Sat, 16 Nov 2024 09:30:34 GMT

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?

Re: Talend big data tSnowflakeOutput could not select tabels

Anonymous — Wed, 19 Jul 2017 02:41:53 GMT

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.

Re: Talend big data tSnowflakeOutput could not select tabels

Anonymous — Wed, 19 Jul 2017 17:43:15 GMT

In my case, this select button is been disabled.

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

Re: Talend big data tSnowflakeOutput could not select tabels

Anonymous — Wed, 19 Jul 2017 18:00:16 GMT

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.

Re: Talend big data tSnowflakeOutput could not select tabels

Anonymous — Wed, 19 Jul 2017 18:26:24 GMT

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

Re: Talend big data tSnowflakeOutput could not select tabels

Anonymous — Thu, 20 Jul 2017 08:48:55 GMT

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-and-Repository/ta-p/21697.

Best regards

Sabrina