Azure Synapse Analytics Data Sink to Synapse Serverless SQL Pool Error

SoonJoo@Genting 241 Reputation points
2021-11-23T16:21:11.773+00:00

Hi,

I am trying to copy data from my REST API to Azure Synapse Serverless SQL Pool but having the following error:

{
"errorCode": "2200",
"message": "ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed with the following error: 'CREATE TABLE <table_name> is not supported.',Source=,''Type=System.Data.SqlClient.SqlException,Message=CREATE TABLE <table_name> is not supported.,Source=.Net SqlClient Data Provider,SqlErrorNumber=15868,Class=16,ErrorCode=-2146232060,State=5,Errors=[{Class=16,Number=15868,State=5,Message=CREATE TABLE <table_name> is not supported.,},],'",
"failureType": "UserError",
"target": "Copy_rw1",
"details": []
}

Is the serverless SQL pool support creation of new tables? I did enabled the staging using datalake storage. Wonder what went wrong.

Many thanks!

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.
5,172 questions
{count} votes

1 answer

Sort by: Most helpful
  1. PRADEEPCHEEKATLA 90,536 Reputation points
    2021-11-24T04:19:05.367+00:00

    Hello @SoonJoo@Genting ,

    Thanks for the question and using MS Q&A platform.

    Azure Synapse Analytics - Serverless SQL pool has no local storage, only metadata objects are stored in databases. Therefore, T-SQL related to the following concepts isn't supported:

    • Tables
    • Triggers
    • Materialized views
    • DDL statements other than ones related to views and security
    • DML statements

    For more details, refer to Serverless SQL pool in Azure Synapse Analytics

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

Your answer

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