-
Use Terraform to manage all my infrastructure
-
Analyze the prefered dataset KMNI Weather Data 10 mins
-
Use airflow to automate the process of data extraction and transformation
- Create a DAG that will run the process every day
- Upload the data to a gcs bucket
-
Use aiflow to automate the data transformation process
- Create a DAG that will run the process every day
- It will read from the previous bucket
- Run spark to transform the data
- Upload the data to big query
- Trigger DBT to run the models and provide views
-
Read the data from big query and create a dashboard
- Use metabase to create the dashboard
- Use the data from big query to populate the dashboard