Blue icon showing an input into a database.

Dynamic Input In-DB Tool

Version:
2021.3
Last modified: August 11, 2021

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

  • Connection Name Field: 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).

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.