week_1_basics_n_setup

Introduction

• Video
• Slides
• Overview of Architecture, Technologies & Pre-Requisites

We suggest watching videos in the same order as in this document.

The last video (setting up the environment) is optional, but you can check it earlier if you have troubles setting up the environment and following along the videos.

Docker + Postgres

Code

• Introduction to Docker
  • Why do we need Docker
  • Creating a simple "data pipeline" in Docker
• Ingesting NY Taxi Data to Postgres
  • Running Posgtres locally with Docker
  • Using pgcli for connecting to the database
  • Exploring the NY Taxi dataset
  • Ingesting the data to the database
  • Note if you have problems with pgcli, check this video for an alternative way to connect to your database
• Connecting pgAdmin and Postgres
  • The pgAdmin tool
  • Docker networks
• Putting the ingestion script to Docker
  • Converting the Jupyter notebook to a Python script
  • Parametrizing the script with argparse
  • Dockerizing the ingestion script
• Running Postgres and pgAdmin with Docker-Compose
  • Why do we need Docker-compose
  • Docker-compose YAML file
  • Running multiple containers with docker-compose up
• SQL refreshser
  • Adding the Zones table
  • Inner joins
  • Basic data quality checks
  • Left, Right and Outer joins
  • Group by
• Optional: If you have some problems with docker networking, check Port Mapping and Networks in Docker
  • Docker networks
  • Port forwarding to the host environment
  • Communicating between containers in the network
  • .dockerignore file

GCP + Terraform

Code

• Introduction to GCP (Google Cloud Platform)
  • Video
• Introduction to Terraform Concepts & GCP Pre-Requisites
  • Video
  • Companion Notes
• Workshop: Creating GCP Infrastructure with Terraform
  • Video
  • Workshop
• Configuring terraform and GCP SDK on Windows
  • Instructions

Environment setup

For the course you'll need:

• Python 3 (e.g. installed with Anaconda)
• Google Cloud SDK
• Docker with docker-compose
• Terraform

If you have problems setting up the env, you can check this video:

• Setting up the environment on cloud VM
  • Generating SSH keys
  • Creating a virtual machine on GCP
  • Connecting to the VM with SSH
  • Installing Anaconda
  • Installing Docker
  • Creating SSH config file
  • Accessing the remote machine with VS Code and SSH remote
  • Installing docker-compose
  • Installing pgcli
  • Port-forwarding with VS code: connecting to pgAdmin and Jupyter from the local computer
  • Installing terraform
  • Using sftp for putting the credentials to the remote machine
  • Shutting down and removing the instance

Homework

• Homework
• Solution

Community notes

Did you take notes? You can share them here

• Notes from Alvaro Navas
• Notes from Abd
• Notes from Aaron
• Notes from Faisal
• Michael Harty's Notes
• Blog post from Isaac Kargar
• Add your notes here