Skip to main content

Blue icon showing an input into a database. Dynamic Input In-DB Tool

Use Dynamic Input In-DB to take In-DB Connection Name and Query fields from a standard data stream and input them back into an In-DB data stream. The In-DB Connection Name and Query fields can be obtained from the Dynamic Output In-DB tool.

In-Database enables blending and analysis against large sets of data without moving the data out of a database and can provide significant performance improvements over traditional analysis methods. For more about the In-Database tool category, visit In-Database Overview.

Configure the Tool

  • ConnectionNameField: The alias for the In-DB connection to the database.

  • Query / Query Alias List Field: The In-DB query created at this point in the workflow.

Possible Errors

If the query fed into the Dynamic Input In-DB tool contains a WITH clause, this error is returned:

The In-DB Dynamic Input tool cannot accept a query which uses a WITH clause. Consider using a Query Alias List instead.

To resolve the error, modify the query to remove the common table expression (WITH clause).