1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to Data Pipelines

Exercise

Building functions to extract data

It's important to modularize code when building a data pipeline. This helps to make pipelines more readable and reusable, and can help to expedite troubleshooting efforts. Creating and using functions for distinct operations in a pipeline can even help when getting started on a new project by providing a framework to begin development.

pandas has been imported as pd, and sqlalchemy is ready to be used.

Instructions 1/3

undefined XP
    1
    2
    3
  • Complete the connection URI with username "repl", port 5432 and database "sales".
  • Pass the URI to the appropriate sqlalchemy function to create a connection engine.