From the course: Data Engineering Foundations

Unlock the full course today

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

Solution: Data extraction

Solution: Data extraction

From the course: Data Engineering Foundations

Start my 1-month free trial

Solution: Data extraction

(upbeat music) - [Tutor] So let's look at how we could extract data from the users table. First of all, we had to provide the name of the table. So that was users. Then add the username, the password. The driver that we had to provide was the postgresql drivers, since we're using the postgresql database. So we could simply use the one that we used to extract movies table data. And then at the end, we need to print the user's data frame that we have just read, user underscore df. We would have to use the show function overhead and that's it. So once you run the script you would get the data for the users table. So as you can see we have id, movie underscore id and rating.

Contents