Skip to content

Lookup Table: From A Sql Source

Settings

You can retrieve data from any database supported by Sync & Save by entering either the name of a table or query, or your own SQL statement. Click the Preview button to check the results of your query.

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.

Feedback and Knowledge Base