Which azure service should I use.

Question

So I have a pretty big on-premise ssms database and I want to use some data from it in azure Machine Learning.
I need to use just a small amount of data from my db, from certain tables.
Also this data updates from time to time.
I want you to help me with the choice of correct azure service for my purpose.

Answer 1

@Cherkasov Dmitriy Welcome to Microsoft Q&A forums.

From the description of your use case, I understand that the database won't be used round the clock but in short bursts of time, when you want to your ML workloads or while updating the tables from your on-premises database.

You might want to consider Azure SQL Serverless database.
You will be billed only for the time the database is in use and it automatically pauses itself during inactive periods.

Please let us know if you have any further questions.

----------

If an answer is helpful, please click on or upvote which might help other community members reading this thread.