When using Teiid in a development environment, you may consider setting the max-source-rows-allowed property to reasonably small level value (e.g. 10000) to prevent large amounts of data from being pulled from sources. Leaving the exception-on-max-source-rows set to "true" will alert the developer through an exception that an attempt was made to retrieve more than the specified number of rows.