Query will work in SQL, but not Knime

[Blake_Watkins]

Hello! Knime newcomers here hoping the community can help us out with a question.

We have a database query that we have been able to run successfully in SQL, but the query will not run in Knime.

Query structure is as follows:

SELECT [MATERIAL]
,[PLANT]
,[BOM component]
,[BOM Component Description]
,[Item Category]
,[BOM Item Number]
,[Relevant Production]
FROM [DB_Part_Release_SQL].[dbo].[Download_BOM]
where [PLANT] = '929P

Has anyone experienced something like this? Is there anything special we need to do in Knime? Thank you!

[ArjenEX]

Hi @Blake_Watkins

What kind of error are you getting? It looks to me like your query is either cut-off or not complete since you start with ,[PLANT] which normally would be

SELECT 
[PLANT]
,[BOM component]

, etc.

[Blake_Watkins]

You are correct, I have now corrected it. The structure is as follows:

SELECT [MATERIAL]
,[PLANT]
,[BOM component]
,[BOM Component Description]
,[Item Category]
,[BOM Item Number]
,[Relevant Production]
FROM [DB_Part_Release_SQL].[dbo].[Download_BOM]
where [PLANT] = '929P

[ArjenEX]

@Blake_Watkins

The structure is as follows:

And what kind of error are you getting?

[Blake_Watkins]

We actually ended up getting it to work, it just took a long time run! Thank you!