There are a plethora of database systems around. RDBMS, NoSql, Graph, BigData, NewSQL...the list goes on and on. Take a look at the db-engines ranking list and you'll see just how many different database systems are out there. This list is also likely to tell you Snowflake is a growing data platform. But just what is Snowflake?
Snowflake actually provides a relational data model, which supports both structured and unstructured data (much like the other main RDBMS systems these days). It's a cloud-first system, like Azure Fabric or AWS Aurora. You can use it as a one-stop shop for transactional and analytic workloads - Snowflake tries to be all data things to all data men and women.
You should think of Snowflake as a data platform, rather than as a database system. Unlike the major cloud platforms, which offer a number of data products which may be unrelated, Snowflake offers a one-place-for-all system with full integration. OLTP, OLAP, ETL, AI, data science and so on are all supported. The system is primarily designed as a cloud-based data reporting platform. It supports all the major cloud vendors and can use any of them for storage, as well as connecting to any storage you might have on those platforms yourself.
There are loads of database systems out there - why should you use Snowflake? Well...
1) As it's completely cloud-based, Snowflake is elastic and scalable
2) You can manage your costs
3) Snowflake can be used to centralise all of your data
4) It's popular, and there are LOTS of Snowflake-related jobs!
If you're interested in finding out more, check out what Snowflake themselves have to say. I'm not saying Snowflake should always be the default choice for your data project, but take a look - you never know when it might be the right fit for the job.