gakas14/Formula1_Data_Modeling

This project involves getting different datasets, creating a data model, creating tables, creating relationships between tables, and then loading the data into Snowflake.

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.

3. We create a Snowflake table using Python.

4. We Build a data model.

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