Understand that the costs for serverless SQL pool in Azure Synapse Analytics are only a portion of the monthly costs in your Azure bill.
If you are using other Azure services, you're billed for all the Azure services and resources used in your Azure subscription, including the third-party services.Jan 4, 2022.
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.
For more info please refer to below related docs: Hope this info helps..
The serverless SQL pools can't read files that are being modified while the query is running.
The query can't take a lock on the files..
Serverless SQL pool benefits
It is suitable for the following scenarios: Basic discovery and exploration - Quickly reason about the data in various formats (Parquet, CSV, JSON) in your data lake, so you can plan how to extract insights from it..
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.
To control costs for your serverless Apache Spark pool, enable the serverless Apache Spark automatic pause feature and set your timeout value accordingly.
Choose the node sizes appropriately to match your preference for performance vs. cost.
Use autoscale to re-size pools when needed.
The serverless SQL pool service is billed for based on the amount of data processed during the billing period.
See Cost management for serverless SQL pool in Azure Synapse Analytics to understand activities that're included in the "data processed" concept.
How can I estimate my costs for serverless SQL pools? .
The cost control feature in serverless SQL pool enables you to set the budget for the amount of data that's processed.
You can set the budget in terabytes of data processed for a day, week, and month.
You can also have one or more budgets set.
To configure cost control for serverless SQL pools, you can use Azure Synapse Studio or T-SQL.
