serverless SQL pool - Built-in cost

Question

Hello,
How can I find out the cost of a select query I run in the serverless sql pool?
In the built-in I can see the amount of data used i.e. 10MB but not sure where to see the cost for this very select query I run?

Thank you

Answer 1

Hi @arkiboys ,

Thanks for using Microsoft Q&A forum and posting your query.

For Synapse Serverless SQL pool, you only pay for executed queries and the pricing is based on the amount of data processed by each query. Metadata-only queries (DDL statements) do not incur a cost. Queries will incur a minimum charge of 10 MB and each query will be rounded up to the nearest 1 MB of data processed. Data processed is the amount of data that the system temporarily stores while a query is run.

The pricing for Serverless is $5 per TB of data processed.

You could also try exploring this Azure pricing calculator tool

For more info please refer to below related docs:

• Azure Synapse Analytics pricing
• Cost management for serverless SQL pool in Azure Synapse Analytics

Hope this info helps. Please do let us know if you have further query.

----------

Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.