Synapse dataverse issue

Pavankumar-3526 306 Reputation points
2023-04-27T17:02:35.05+00:00

Hello,
on my synapse dataverse tables, append only is disabled after I enabled the synapse link.

I don't see any option to enable append only. How can I check the append only box now?

User's image

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.
0 comments No comments
{count} votes

Answer accepted by question author
  1. Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator
    2023-04-29T16:08:37.35+00:00

    Hello Pavankumar-3526,

    Welcome to the MS Q&A platform.

    To enable Appendonly after you enable the synapse link, you need to unlink the tables from the manage tables section and re-add it again with the append-only option.

    The other option is to unlink the Azure Synapse link and re-enable it with the append-only option on your tables.

    User's image

    User's image

    I hope this helps. Please let me know if you have any further questions.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.