Input Data PreSQL

I'm trying to grab a large table and it is taking a considerable time to load. I want to limit the importation of the table to only critical records. I thought a good way to do this would be using the PreSQL in the Input Data Tool but I keep getting syntax error. (Incorrect syntax near '=')

[audit_reference_dwkey] = 17

Developer Tools

Accepted answers

SeanAdams

Hey @Eric227 - using PreSQL is good if you need to create a temporary table of some kind, or delete or update something before running the select.

If what you're trying to do is to filter the table, the best route is to open the query section of the input tool, switch to the SQL view, and add a "Where" clause.

For example if it currently says in the SQL view:

database."tablename"

Then change this to:

Select

Column A,

Column B

from TableName

where

ColumnA = CriticalValue

That will limit the records nicely.

Cheers

Sean

All comments

SeanAdams

Hey @Eric227 - using PreSQL is good if you need to create a temporary table of some kind, or delete or update something before running the select.

If what you're trying to do is to filter the table, the best route is to open the query section of the input tool, switch to the SQL view, and add a "Where" clause.