Snowflake
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 alternative was considered but not chosen for the following reasons:
AWS Redshift
- Relatively slow
- No cluster flexibility
Usage
We use Snowflake as our analytics database.
Last updated on