Extract Transform Load Weather Data

ETL

project description
Explore the docs »

View Demo · Report Bug · Request Feature

Table of contents

1. About The Project
2. Installation
3. Schema
4. Data Wearhouse demo
5. License
6. Contact
7. Acknowledgements

About The Project

In this project, I create an ETL pipeline that extracts data from flat files and transforms and loads it into an SQLite database. The project tasks need to define the data warehouse Schema for a particular analytic use.

Installation

1. requirement

pip install pysqlite

2,

git clone https://github.com/saboye/Extract-Transform-Load-Weather-Data.git

Schema

CREATE TABLE IF NOT EXISTS weather (
    day DATE,	    -- day of measurements
    min_temp FLOAT, -- min temperature in Fahrenheit
    max_temp FLOAT, -- max temperature in Fahrenheit
    snow INTEGETR   -- snow in inches
);

CREATE INDEX IF NOT EXISTS weather_day ON weather(day);

Data Wearhouse demo

To see or to make a SQL query, After downloading please drag and drop the weather.db to https://db.samuelaboye.dev/

License

Distributed under the MIT License. See LICENSE for more information.

Contact

Your Name - @saboye

Project Link: https://github.com/saboye/Extract-Transform-Load-Weather-Data

Acknowledgements

• https://www.postgresql.org/
• https://www.antwak.com/
• https://www.postgresqltutorial.com/