Homework 1: Pre-Requisites (Docker, Terraform, SQL)

Score: 7 = 7 (questions) + 0 (FAQ) + 0 (learning in public)

Homework URL: View submission

Homework 2: Mage

Score: 6 = 6 (questions) + 0 (FAQ) + 0 (learning in public)

Homework URL: View submission

Workshop 1: Data Ingestion

Score: 7 = 4 (questions) + 0 (FAQ) + 3 (learning in public)

Homework URL: View submission

Learning in public links: Show

• https://duckdb.org/docs/sql/statements/drop.html
• https://dlthub.com/docs/general-usage/incremental-loading#choosing-a-write-disposition
• https://github.com/addy024/DataEngineeringZoomcamp2024WorkshopDLTHomework/blob/main/dlt_homework.ipynb

Homework 3: Data Warehouse

Score: 12 = 6 (questions) + 0 (FAQ) + 6 (learning in public)

Homework URL: View submission

Learning in public links: Show

• https://cloud.google.com/bigquery/docs/reference/standard-sql/data-definition-language#table_option_list
• https://cloud.google.com/bigquery/docs/creating-partitioned-tables
• https://cloud.google.com/bigquery/docs/materialized-views-intro
• https://cloud.google.com/bigquery/docs/external-tables
• https://www.atlassian.com/data/sql/how-countdistinct-field-works-in-google-bigquery
• https://cloud.google.com/bigquery/docs/working-with-connections#console

Homework 4: Analytics Engineering

Score: 6 = 4 (questions) + 0 (FAQ) + 2 (learning in public)

Homework URL: View submission

Learning in public links: Show

• https://docs.getdbt.com/docs/supported-data-platforms
• https://medium.com/@suffyan.asad1/getting-started-with-dbt-data-build-tool-a-beginners-guide-to-building-data-transformations-28e335be5f7e