Data Stream Out Tool
Use Data Stream Out to stream data from an In-DB workflow out to Alteryx Designer.
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, refer to In-Database Overview.
Use the Configuration window to customize the Data Stream Out tool.
Advanced Query Options: Use this section to define Pre and Post SQL statements to execute. Use the 3-dot menu associated with either the Pre or Post Statement fields to launch the Configure Pre/Post SQL Statements window which includes the SQL Editor. Note that Stored Procedures are not currently supported.
Pre- and post-SQL statements are compatible with the following technologies: Bulk Loaders, OCI, ODBC, and OleDB.
Pre-SQL Statement: Define a SQL statement to execute before the in-database execution.
Post-SQL Statement: Define a SQL statement to execute after the in-database execution.
Note
When the workflow runs, the Results window displays messages to show that the tool is executing SQL statements, along with a label (PreSQL, PostSQL).
All SQL statements are sent directly to the database. Pre- and Post-SQL statements do not return data. While SQL can return data, Designer doesn't do anything with that data.
If there are multiple streams of In-DB tools, there is no guaranteed order of execution between different streams. The Results window displays the order.
Sort records before streaming out: This is an optional setting. When checked, the incoming data is sorted by the field specification below.
Name: Select the field to sort on.
Order: Choose either Ascending or Descending.
Use the up and down arrows to change the order, and the "-" button to delete a field.
Connect a standard tool to the output of the Data Stream Out tool.