Hackernoon logoCloud Computing Explained: What is Serverless SQL and Why Should You Care? by@adipolak

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

Author profile picture

@adipolakAdi Polak

๐Ÿ‘ฉโ€๐Ÿ’ป Software Developer ๐Ÿ“š Blogger ๐Ÿ—ฃ๏ธ Speaker ๐Ÿ’ซ 1 of 25 influential women in Software Development

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

What does Serverless mean?

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. ๐Ÿ˜

What is SQL?

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

So what is Serverless SQL?ย 

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.

Lead Photo by C Dustin on Unsplash

Also published at https://towardsdatascience.com/what-is-serverless-sql-and-how-to-use-it-for-data-exploration-eadad1f1a036

Author profile picture

@adipolakAdi Polak

Read my stories

๐Ÿ‘ฉโ€๐Ÿ’ป Software Developer ๐Ÿ“š Blogger ๐Ÿ—ฃ๏ธ Speaker ๐Ÿ’ซ 1 of 25 influential women in Software Development

Tags

Join Hacker Noon

Create your free account to unlock your custom reading experience.