Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Write In-DB : Append Existing not possible to select

caz777
6 - Meteoroid

I am running Alteryx Designer 10.5 and am experienced a strange things when trying to use In-DB functionality.It might be working as intended, but it seems strange to me.

 

I am trying to send a data-stream into a Azure SQL Data Warehouse, by using a Data Stream In, and then using Write In-DB. I want the incoming stream to be appended to the existing DB table.

 

But I am unable to select Append Existing for the Write In-DB tool. I can select it before I connect the tool to the stream, but once connected it dissapears as an option. I have made a simplified (only a Connect In-DB tool and a Write In-Db tool) example in the picture below. As you can see there are suddenly differences in Creation mode options. Is this working as intended?

 

I have tried testing with a normal Azure SQL server instead of my Azure SQL DataWarehouse, with the same result. I have tested different stream inputs to the Write In-Db (Connect In-Db, Data Stream In). I do not have access to a on-premise SQL database, so can not test if this is an azure "feature" :)

 

Anyone have any idea why this is happening?

 

Write_inDB.png

 

 

1 REPLY 1
DanM
Alteryx Community Team
Alteryx Community Team

At this time. Azure does not support appending data to the database, therefore appending data is not an option in the Output tool.
Labels