1. Learn
  2. /
  3. Courses
  4. /
  5. ETL and ELT in Python

Connected

Exercise

The "T" in ELT

Let's not forget about ELT! Here, the extract() and load() functions have been defined for you. Now, all that's left is to finish defining the transform() function and run the pipeline. Go get 'em!

Instructions

100 XP
  • Update the transform() function to call the .execute() method on the data_warehouse object.
  • Use the newly-updated transform() function to populate data in the total_sales target table by transforming data in the raw_sales_data source table.