ADS - Add columns in the middle of a table

GP-2266 31 Reputation points
2022-10-28T13:00:37.867+00:00

Hello,

When using ADS table designer to add columns in the middle of the table, the script which is generated contains DDL statements inside a transaction.

Since DDL statements in Synapse are not allowed, has anyone gotten this to work properly? I can remove the begin tran statements manually but there is a lot of them and having to do so is quite annoying.

Looks like this was logged as an issue: https://github.com/microsoft/azuredatastudio/issues/20839

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,553 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. BhargavaGunnam-MSFT 28,111 Reputation points Microsoft Employee
    2022-10-31T21:38:40.707+00:00

    Hello @GP-2266 ,

    Welcome to the MS Q&A platform.

    Currently, in Synapse, there is no support for DDL such as CREATE TABLE inside a user-defined transaction. But the Product team acknowledged and this is currently on our backlog.

    Here is the feedback request.

    https://feedback.azure.com/d365community/idea/65cebf61-0925-ec11-b6e6-000d3a4f07b8

    Appreciate if you could upvote and comment on this feedback. All the feedback shared in this forum is actively monitored and reviewed by the product team which will prioritize them accordingly based on the number of requests.
    Hope this info helps.

    1 person found this answer helpful.