Databases Reference
In-Depth Information
The following screenshot shows the configuration we need in the
Create Select
Statement
dialog for this particular example:
The resulting script is as follows:
LOAD `%Origin Airport ID`,
`Origin Airport`;
SQL SELECT `%Origin Airport ID`,
`Origin Airport`
FROM `Origin Airports`;
Did you notice how we didn't use the star symbol when selecting the list of fields
to retrieve, even when we needed to pull all fields? This is a best practice, to ensure
that only the required fields are returned by the query, and no more. Suppose, for
example, that a new field is added to the source table. If we used the star symbol to
query the database, we would automatically retrieve this new field even when it's
not necessary for our data model, wasting valuable bandwidth in the process.
