From the course: Data Engineering Foundations

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Solution: Loading data

Solution: Loading data

From the course: Data Engineering Foundations

Start my 1-month free trial

Solution: Loading data

“

(upbeat music) - [Instructor] So here's the solution to the challenge. First of all, you would have to use the overwrite mode. So that is overwrite. Then the data frame function that you would have to use to load the data frame back to the database is write. You'd have to write the data frame back to the database and then the right parameters to the transform function is the data frame that we have read above. So that is movies_data frame. And then the second parameter, or the second argument is the user_dataframe. Then to load the ratings data frame, you would have to call the loading function and then pause the ratings on the aggregated data that you have just returned above, so that is ratings_df. So this is the solution to the challenge. Run the script, and you would have a new table in your database.

Contents