How can I use the warehouse?

I have done the following steps:

• Creating a warehouse (settings)
• Creating a database
• Creating a stage
• Creating a file_format
• Loading data into database through stage in worksheet
• Doing different commands with the data in the database

Since I did not find any information about the warehouse functionality, I wanted to ask you guys the following: What exactly is the use the warehouse in these steps at all? Or are there any other steps after loading data into the database for example loading data into the warehouse?

This is a common confusion due to the slightly bizarre way Snowflake have used the term "warehouse". The key thing to remember is that in Snowflake a "warehouse" represents a compute resource. It has nothing to do with data storage, which is entirely separate from the compute resource.

The separation of compute and data storage is one of the keys strengths of the Snowflake platform as it enables you to have multiple, differently scaled compute resources ("warehouses") for different tasks (e.g. data transformation, reports) that all share the same data storage.