Lookup Table: From A Sql Source
Settings
![](https://i.embed.ly/1/image?url=http%3A%2F%2Fpinestreetdata.com%2Fmain%2Fwp-content%2Fuploads%2F2013%2F09%2FLookup-Settings.png&key=16b1a988066d11e191834040d3dc5c07)
If
your reference data hasn't changed, then you probably don't want to
re-upload it. Make sure to check the "Upload Only If Data Changes"
check box to keep a snapshot of your lookup data and only upload the
data if it has changed. Click the Preview button to view the latest snapshot of your lookup data.
The data returned by your SQL query should include ALL the records you want in your lookup table.
Note that before version 1.12.1, if no records are found in the source query, then no changes are made to the lookup table.