mozilla / docker-etl

Collection of dockerized ETL jobs managed by data engineering.
Mozilla Public License 2.0
19 stars 15 forks source link

feat(kevel-metadata): adding new etl for extracting kevel metadata from kevel api into ads_derived table #242

Open braunreyes opened 4 months ago

braunreyes commented 4 months ago

References https://mozilla-hub.atlassian.net/browse/AD-295

This is a new job that will extract ad data from the kevel API and load into a raw data table called `ads_derived.kevel_metadata_history_v1.

Checklist for reviewer:

TO DO: Finalize the merge logic to comply with stakeholder expectations. Right now the daily partition is overwritten on each run. @sergiosonline @curtismorales you will want to discuss how you want to handle things like 'what if ad_id is in a different flight with different attributes in the same day?'.