If you have ever been responsible for the design of a data warehouse using Data Vault 2.0 methodology, then you probably faced the need to decide how to generate and store your primary keys. Even though some general principles work, however, a data warehouse platform on which you build your solution has a significant impact on your decision. In this article:

I will consider several options for primary keys and how choosing a particular approach affects SQL query performance when using Snowflake.

The repository stores the benchmark scripts.