What Database to Use

Last modified: August 07, 2019 • Reading Time: 2 minutes

Contribute to Data School

We are actively working on this chapter. We are looking for two types of contributions:

  1. Help writing this chapter
  2. Share your story about working through this problem at work

Please reach out to @Matt David on our slack to discuss what you want to contribute.

What Database to Use In Progress Overview

When building your Data Warehouse the most important question is what database will you be building it on. We want to cover the most popular options and discuss their pros and cons. We also want to spend some time discussing how you should move the data between your Data Lake and Data Warehouse.

Outline + Learning Objectives

How to evaluate a Database

  • Describe what dimensions to consider when picking a Database

Pros and Cons

  • Differentiate between Databases in terms of their strengths and weaknesses

ETL ELT

  • Describe how the way you move the data from Data Lake to Data Warehouse will impact your organization

How to Evaluate a Database

  • Pricing
  • Ecosystem
  • Architecture
  • Maintenance

Pros Cons

  • BigQuery
  • Redshift
  • Snowflake
  • Postgres

ETL ELT

  • Same Ecosystem
  • Permissions considerations
  • Performance considerations

Written by:
Reviewed by:

Next – Data Warehouse Implementation

Get new data chapters sent right to your Inbox