Any plans to add a SQL Activity?

Question

Does anyone know if there are any plans to add a SQL activity that will officially support running commands like insert/update/delete against a target DB?

I can hack this with the lookup activity by having multiple statements in the 'Query':-

Insert into 'blah' values ('something'); select count(*) from 'blah';

I am nervous of putting anything into production on the basis of unsupported functionality since it could get dropped or changed without notice.

The reason I think this is needed is that that to any jobs in my DB I have to export the data, stage it and reload to the target table, all of which adds significant cost and time. Yes, I can do stored procs but that just takes me out of ADF making ADF redundant for a load of use cases. Yes I know about polybase/copy into but this is still 5x slower than doing directly against the DB.

Anyone know anything about if this feature is coming? I have an idea posted here 43490781-add-activity-for-running-sql

Answer 1

Hi @Mathew Partridge ,

As per the conversation with internal teams, product team is evaluating this feature request suggestion/feedback by gathering the relevant evidences to consider and prioritize accordingly. At the moment, we do not have a definite ETA about when it will be added to backlog as it is still under review. But I have shared your feedback link with the respective product team to further review it. Hopefully there should be an update from product team on the the feature request post as soon as a decision is made. I will also keep track of this feature request post and update this thread once I hear back from the product team about the final decision.

I would also recommend you to follow Azure Updates for future updates on new features/releases on Azure products.

Do let us know if you have further query.

----------

Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.