Skip to content

Ingesting json data from API and loading into cloud postgresql after transforming using python.

Notifications You must be signed in to change notification settings

bhavk26/JSON_ETL_PYTHON_Postgresql

Repository files navigation

The project fetches, India Statewise yearly (2008-16) accident due to high speed, data as JSON from API provided by Government Digital India Website and ingests the data after transformation to PostgreSQL(relational database) using Python (Pycharm). The ingested tabular data in the PostgreSQL is then fetched by POWER BI for analytics.

Untitled-2024-02-18-1954 .. .. Screenshot 2024-01-31 212228

About

Ingesting json data from API and loading into cloud postgresql after transforming using python.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages