SQL Code Not Pulling Appropriate Data

[Inactive User]

I have a SQL code in the input tool and the data does not want to load in. I am able to select star and bring in the data, however since there will be columns added to this database later I want too restrict this to specific columns. 

I see that the "ID" column is labeled blue and I think this is why there is an error. Since I am new to SQL I cannot figure out where this problem is coming from or why this comes through when it appears to be the same as all other columns that I call out.

Does anyone know why Alteryx is doing this?

[geraldo]

@Inactive User 

What error message is Alteryx sending?

[rohityaman]

This should be because of the reserve keywords. Which database you're trying to connect to?

Meanwhile try covering the ID field with double quotes (") or back ticks (`), like "ID" or `ID` and see if that works.

[Inactive User]

There are no errors populating from the input tool when run. It simply does not bring in any information

[Inactive User]

When using (") I have the same result. When I use (') receive an error coming from row 249 position 47 (The location of this [ID] field name)

[Inactive User]

This is for a SQL database, what additional information are you looking for regarding the database?

[rgoodr2]

Looks like it is recognizing ID as a command word in SQL....try putting brackets around ID. That might work.

[geraldo]

@Inactive User 

Is there a browse tool right after this input data tool?

there is some where clause.

In the log did you see what message is appearing after the query?

[rohityaman]

@Inactive User  Is this MySQL database or SQL Server database? Also, there is an option to validate query by clicking “test query” in input file configuration. Does it throw any error while validating? 

[Inactive User]

Brackets give the same result. I don't think there is an ID command in SQL, right?