Rationale
Snowflake is our database for analytical purposes.
The main reasons why we chose it over other alternatives are:
- It is much faster.
- It has a deeper Terraform integration.
- It offers flexible permission sets.
- It integrates well with dbt.
- It allows the creation of multiple computing environments, each with the necessary resources.
- It offers cheap storage.
- The pricing model is based on usage, primarily depending on processing power usage.
Alternatives
The following alternatives were considered but not chosen for the following reasons:
AWS Redshift
- Relatively slow.
- No cluster flexibility
Usage
We use Snowflake as our analytics database.