Cloud Computing Explained: What is Serverless SQL and Why Should You Care?

Well. Let's start by examining what Serverless really means.

According to Wikipedia, serverless computing is a cloud computing execution model where the cloud provider manages the server and dynamically allocates the resource needed to finish the task.

That means, as users, we are in charge of the logic only. We don't need to take care of the servers, capacity planning, or maintenance operations scale. It doesn't mean they are not happening; they are, just not by us. 😁

According to Wikipedia, SQL is a domain-specific programming language used for managing data held in relational databases.

Serverless SQL is a distributed computing tool that enables us to process distributed data using SQL language without managing the databases servers themselves. If we have data, or "big data" in one or more of our data lake/storages, like AWS S3 or Azure blob storage, we can run SQL query on that data without the need to build a pipeline or inject the data into distributed databases such as Cassandra or MongoDB.

This is a huge advantage, especially when we would like to interact with offline data without creating the pipelines or peek at completely fresh new data that was just sunk into the storage before replicating/transforming and saved into a dedicated Database.

As with all cloud services, there is a need to understand the cost model. with serverless, we pay-per-use. That means that we pay for the amount of processed data. 

If we ran a

select *

query on 2TB, the prices would be calculated by the 2TB data processed. This can be more cost-efficient than having a dedicated pool of servers, depends on the company/group needs.