SQL Code Not Pulling Appropriate Data

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?

Alteryx Help.png

Input

Database Connection

Accepted answers

All comments

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.

unknown

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

unknown

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)

unknown

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?

unknown

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

unknown

I added in a browse tool and that seems to be loading all the data, but no other tool want's to load this through.

There is no where clause, for this SQL code

In the log there are three messages

- Alias translated to odbc :driver - Details on this

- ODBC Driver Version: 03.80

- 2607 records were read from aka:spsql2019 - Details

unknown

I decided that I will just select star on this and then use the select tool to stop any new fields coming in. If there are any other solutions I am still open to give them a try but this will be sufficient for what I need.

rohityaman

An alternate way I can suggest is to create a View in the database and then connect that with Input tool. This way you can fix/control the number of columns from source and you can avoid rendering extra data from unnecessary columns. If required, even filter conditions can be added to the View to further reduce the incoming data volume.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703