Skip to content

Latest commit

 

History

History
25 lines (11 loc) · 1.21 KB

README.md

File metadata and controls

25 lines (11 loc) · 1.21 KB

Formula1_Data_Modeling

In this project, we have a Formula 1 dataset covering races, drivers, constructors, qualifying, circuits, lap times, pit stops, and championships from 1950 to the 2023 season. The data needs to be loaded into a Snowflake database.

1. We first load the different datasets into Python and then process some transformations.

2. We create a connection between Python and Snowflake and create a database.

Screen Shot 2024-03-08 at 12 15 39 PM

3. We create a Snowflake table using Python.

Screen Shot 2024-03-08 at 12 16 06 PM

4. We Build a data model.

F1_Entity_Relation drawio

5. We load the different data frames into a Snowflake.

Screen Shot 2024-03-08 at 1 52 48 PM