Introduction Data Warehousing Concepts

The level of query processing comes next, where SQL queries are actually executed. All SQL queries run in a dedicated MPP environment as part of a specific cluster made up of many compute nodes (this is adjustable). Virtual data warehouses are another name for these specialized MPPs. It is not unusual for a company to have distinct virtual data warehouses for each of its several business divisions, including sales, marketing, finance, and others. Although this configuration is more expensive, it guarantees data integrity and top performance.

We now have cloud services. These services, which include infrastructure & storage management as well as access control and data protection, assist in connecting the many Snowflake units, as described in the boxes.