"Write Data In-DB" Tool: have as option to choose path orientation

[YRA]

Hi Support,

Please consider this Idea in your future release of Alteryx based on the following details:

• Once an In-DB Write action is processed, process is only based on internal table (creation of a temporary table within Hive / Warehouse depository, load data inpath…, then rename & move this table at specified location within « Table Name » option).
• Customer requirement is to have this process available on external table along with available options similar to available one within In-Memory tool.
• Proposed work-around from your side is only satisfactory as a temporary solution:
  • write to a table in the write in-db tool;
  • stream out 1 record from that table;
  • write that to a "fake" temporary table in the regular output tool;
  • and then use a post SQL statement to create the external table and move the data from the table created with write in-db to the external table.

Thanks & Regards,

YRA