tosun-si/world-cup-qatar-elt-dbt

Stars
4
Rank 3,304,323 (Top 66 %)
Language
Shell
Created 3 months ago
Updated 3 months ago

tosun-si/world-cup-qatar-elt-dbt

tosun-si

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

This repo shows a real world use case with DBT, BigQuery and Google Cloud. The raw and input data are represented by the Qatar Fifa World Cup Players stats, some transformations are applied with the ELT pattern and DBT to apply aggregation and business transformations.

asgarde

Asgarde allows simplifying error handling with Apache Beam Java, with less code, more concise and expressive code.

bigtesty

BigTesty is a framework that allows to create Integration Tests with BigQuery on a real and short lived Infrastructure.

pasgarde

Asgarde allows simplifying error handling with Apache Beam Python, with less code, more concise and expressive code.

midgard

Midgard is a wrapper on Beam Kotlin, allowing more concise and expressive code. It removes Beam boilerplate code and proposes more Functional Programming style

teams-league-cloud-workflows-elt

This project shows a real world use case with ELT pipeline using Cloud Storage, BigQuery and Cloud Workflows

dataflow-python-ci-cd

Project showing a CI CD pipeline for Dataflow Python with Flex Template and Cloud Build

teams-league-python-ddd-beam-summit

dataflow-java-ci-cd

Project showing a CI CD pipeline for Dataflow Java with Flex Template and Cloud Build

teams-league-airflow-cloudrun-etl

This project shows a real world use case with ETL batch pipeline using Cloud Storage, Cloud Run Service and BigQuery orchestrated by Cloud Composer / Airflow

teams-league-airflow-elt

The goal of this article is showing a real world use case for ELT batch pipeline, with Cloud Storage, BigQuery, Apache Airflow and Cloud Composer : The Extract part is managed in Cloud Storage The Load part is managed from Cloud Storage to BigQuery The Transform part is managed by a BigQuery SQL query Everything is orchestrated by Airflow

teams-league-cloudrun-service-fastapi

Project showing a complete use case with a Cloud Run Service written with a Python module and multiple files. The deployment of service is done with FastApi and Uvicorn.

teams-league-python-dlq-asgarde-beam-summit

world-cup-qatar-team-stats-kotlin-midgard

This application shows a full Apache Beam pipeline with Kotlin and Midgard library. The use case works on the last Qatar FIFA world cup data and calculate players statistics per team. This application will be presented at Beam Summit 2023 in New York

sa-custom-roles-gcp-terraform

This project shows a complete use case with the least privilege principle on Google Cloud using modular Terraform, Terragrunt and Cloud Build

datasets-tables-bq-one-module-terraform

This project how to create BigQuery Datasets and tables with Terraform and elegant Json configuration. This example use a single Terraform module to create datasets and tables. The deployment of IAC part is done with Cloud Build.

teams-league-cloud-workflows-etl-dataflow

This project shows a real world use case with ETL pipeline using Cloud Storage, Dataflow, BigQuery and Cloud Workflows

datasets-tables-bq-multi-modules-terraform

This project how to create BigQuery Datasets and tables with Terraform and elegant Json configuration. This example use two Terraform modules to create datasets and tables. The deployment of IAC part is done with Cloud Build.

teams-league-spark-scala-dataproc-serverless

This project shows a complete, concrete and a real world use case with a Spark Scala job run with Dataproc Serverless on Google Cloud.

tosun-si

TOSUN SI repository

teams-league-java-ddd-beam-summit

world-cup-qatar-event-driven-serverless-archi-workflows

Project showing a use case with a full Event Driven and Serverless Architecture with Cloud Functions, Cloud Run services and Cloud Workflows

teams-league-cloudrun-job

Project showing a complete use case with a Cloud Run Job written with a Python module and multiple files.

bees-demo-fp

This project shows some legacy code and patterns and a refactoring for each of them with Functional Programming, lambda and functions composition

teams-league-airflow-beam-bq

syomi

tp-teams-handling

java8-example

datasets-tables-bq-pulumi

This project shows how to create BigQuery Datasets with tables using Pulumi and elegant/scalable Json configuration. This use cas was previously created with Terraform and the goal is to rewrite it with Pulumi and the Python SDK.

teams-league-java-dlq-asgarde-beam-summit

Project presented at Beam Summit 2022 that shows a complete use case with a Dead Letter Queue on errors with Beam Java and Asgarde library.

teams-league-airflow-spark-scala-etl

This project shows a real world use case with ETL batch pipeline using Cloud Storage, Scala Spark with Dataproc Serverless and BigQuery orchestrated by Cloud Composer / Airflow

event-arc-trigger-function

This project shows a complete use case with an event driven Cloud Function written in Python and triggered with Event Arc

world-cup-qatar-team-stats-java

This application shows a full Apache Beam pipeline with Java. The use case works on the last Qatar FIFA world cup data and calculate players statistics per team. This application will be presented at Beam Summit 2023 in New York. A Kotlin version of this use case is also used in another repo.

airflow-composer-error-handling

This project shows how to apply error handling in Airflow DAGs and Cloud Composer in Google Cloud. Instead of repeat a technical code of error handling in each DAG, the principle is to use a callback and a failure interceptor.

world-cup-qatar-event-driven-serverless-archi

This project show a complete and real world use case with Event Driven and Serverless architecture on Google Cloud