Synapse - Master key and Database scoped credentials

Question

NAGA SANDEEP KUMAR KAPA 51

I have a scenario where couple of server less databases needed in synapse.
For those

And also how to automate the creation of those databases. Can we use script activity in pipeline to create those.

1 answer

Answer 1

Alberto Morillo 34,671 MVP Volunteer Moderator

Yes, you will need to create the master key on each database to protect the scoped credentials.
Yes you need to create the scoped credentials on each database to access containers on storage accounts.

You can setup a task on a pipeline to run an ARM template that creates the Synapse Serverless database.

NAGA SANDEEP KUMAR KAPA 51 Reputation points

2022-07-07T17:06:58.343+00:00

Hi ,

Thanks for the reply. Is there any other way to create serverless databases in synapse. Can't we run the scripts using script activity in adf pipelines.

I also need to create stored procedure in those databases. Can I know how can I achieve it . Is devops (YAML) the only way to create databases?
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator

2022-07-07T17:58:54.537+00:00

You can create the stored procedure as part of post-deployment scripts as explained here.

You can also use PowerShell and CLI to create a SQL Pool as explained here.
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2022-07-11T19:22:17.59+00:00
Hello @NAGA SANDEEP KUMAR KAPA ,
I am just checking in to see if the above answer helped. If you have any further questions, please let us know.
@Alberto Morillo , thanks for your help here.

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator

2022-07-11T19:57:33.793+00:00

Thank you for your support @Bhargava-MSFT .