Unexpected Null values from a DbInput (Snowflake)

[Anonymous]

Hi, 

We face a strange problem (issue I hope) with Talend Cloud and Snowflake DB.

The DbInput returns null values instead of valorized Foreign Keys IDs. 

Everything is ok while running the query in the SQL editor. But in Talend, IDs are valorised to NULL. 

In the DEV environment everything works well. IDs are not null. 

BUT with the Integration's data all the foreign key are null. 

Could you give us somes clues, some ideas or some informations please?

Yours Faithfully

[Anonymous · Accepted solution]

Hi,

    I could see from your PPT that you are using two different environments in the context (development vs integration).

    Could you please double check whether all the connections to DB are rightly pointing to Integration DB. Since the query is correctly working in Editor, it should work fine in Talend too. End of day, Talend is orchestrating the data connection to Snowflake in a Graphical manner. My strong suspicion is that one of the connection parameters in the Integration data set is pointing wrongly to Development environment. Another reason could be all the tables used by the SQL query in the Inegration environment are not correctly populated.

Could you please check these aspects and come back to the forum. Since its a big query, check each table independently using "select * from table" through tDBInput to double check the data.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Hi,
Merci, Thank you.
It was a data quality default from the dimension tables.