The Database Query (DB Query), a processor function, helps the user request data from a database and enrich the data in your stream. The data retrieved from the database can be from multiple tables.
...
| Note | ||
|---|---|---|
| ||
A high value can result in an error due to memory outage. If so, the stream fails with the following error message in the log: However, this error is received for memory issues in general and can have other causes than a high value for the maximum number of items in the cache. |
...
| Note | |||||
|---|---|---|---|---|---|
| |||||
The Database Query function supports Variable Insertion when writing SQL statements.
|
...