How to create a database in the built-in Serverless SQL Pool?

Mateo Estrada Bazan 86 Reputation points
2023-01-02T21:02:33.297+00:00

Hello everybody!

Me and my team are struggling to get to use a database inside the built-in Serverless SQL Pool in Synapse.
We could create a database manually on Develop (using a script and executing it), but when we want to create a linked service, the only database available for us to choose from the list is master (important: the settings from Account selection method we chose are "From Azure suscription")
How can we create another database (different from master) in order for us to use it in our linked service?

Thanks!
Kind regards,
Mateo

275523-whatsapp-image-2023-01-02-at-60040-pm.jpeg

Azure SQL Database
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.
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
{count} votes

2 answers

Sort by: Most helpful
  1. Dillon Silzer 60,716 Reputation points Volunteer Moderator
    2023-01-02T23:22:40.697+00:00

    Hi @Mateo Estrada Bazan

    Try using the following video to guide you creating a new linked service to your Azure SQL Database:

    https://www.youtube.com/watch?v=0ZvFP1AI7xg

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

    If this is helpful please accept answer.


  2. PRADEEPCHEEKATLA 91,496 Reputation points Moderator
    2023-01-04T07:04:42.027+00:00

    Hello @Mateo Estrada Bazan ,

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

    As per the official document - in order to pass the built-in serverless sql pool you need to Enter Manually serverless SQL pool in Azure Synapse from the Azure portal.

    275850-image.png

    Step1: Get the Serverless SQL endpoint from your synapse workspace as shown below:

    275908-image.png

    Step2: Create a linked service for a serverless SQL pool in Azure Synapse from the Azure portal: by choosing Azure Synapse Analytics and select Enter manually as shown below:

    275961-image.png

    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 jhow you can be part of Q&A Volunteer Moderators
    0 comments No comments

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.