Category
Snowflake Concepts

How to subtract days from a date in Snowflake
Learn how to subtract days from a date in Snowflake using the powerful DATEADD function.

Connecting dbt and Snowflake: A Step-by-Step Guide
Learn how to connect dbt and Snowflake to streamline your data transformation and build efficient analytics workflows.

How to concatenate strings in Snowflake
All you need to know to concatenate strings in Snowflake

How to Convert a Timestamp to UTC in Snowflake: A Technical Reference Guide
Ensure accurate analysis by learning how to convert different Snowflake timestamp types, including epoch, TIMESTAMP_NTZ, TIMESTAMP_LTZ, and TIMESTAMP_TZ, to UTC with this advanced technical guide.


What Are the Benefits of a Multi-Cluster Warehouse in Snowflake?
In Snowflake, you allocate “virtual warehouses” (computing clusters) to execute the SQL database commands that you run on the data platform.

What Type of Data Warehouse Is Snowflake Data Platform?
With Snowflake, it’s possible to build an enterprise data warehouse (EDW), an operational data store (ODS), or a team-specific data mart.

What Is the Use of a Virtual Warehouse in Snowflake Analytics?
In Snowflake, you allocate “virtual warehouses” (computing clusters) to execute the SQL database commands that you run on the data platform.

How Does Snowflake Storage Work? (Databases & Schemas)
Databases and schemas ("namespaces") are used to organize data in Snowflake storage, which uses a columnar format internally for analytics.

How Many Nodes Are in a Snowflake Virtual Warehouse?
Snowflake uses credits, which are analogous to CPU nodes, in order to pay for the virtual warehouses that power its analytical query engine.

Is Snowflake a Data Warehouse for Analytics and Insights?
Snowflake data platform is referred to as a data warehouse or data lake because it separates storage (data) from compute (processing power).

What Is the Difference Between a Database and a Warehouse in Snowflake?
Snowflake uses databases for data storage, while a “Snowflake warehouse” is a virtual computing cluster that processes analytical queries.

How Many Virtual Warehouses Can Snowflake Hold?
Snowflake data platform allows many virtual warehouses in one account, but multi-cluster virtual warehouses are an Enterprise-only feature.

What Is a Multi-Cluster Virtual Warehouse in Snowflake Data Platform?
Multi-cluster virtual warehouses auto-scale compute resources based on the demands on the data warehouse. Here’s how they work in Snowflake.

What Are Warehouses in Snowflake Data Analytics Platform?
Snowflake’s virtual warehouses are computing clusters that process the data analytics commands you run on Snowflake data analytics platform.
You could be building more
Get a product demo to see how Propel helps your product dev team build more with less.