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?
Lukasz Szozda :
The documentation provides detailed description of Virtual Warehouses:\n\nA virtual warehouse, often referred to simply as a “warehouse”, is a\ncluster of compute resources in Snowflake. A warehouse provides the\nrequired resources, such as CPU, memory, and temporary storage, to\nperform the following operations in a Snowflake session:\n\nExecuting SQL SELECT statements that require compute resources (e.g. retrieving rows from tables and views).\n\nPerforming DML operations, such as:\n\nUpdating rows in tables (DELETE , INSERT , UPDATE).\n\nLoading data into tables (COPY INTO ).\n\nUnloading data from tables (COPY INTO ).\n\n\nNote\nTo perform these operations, a warehouse must be running and in use\nfor the session. While a warehouse is running, it consumes Snowflake\ncredits.\n",
2022-07-24T14:40:26