This gist contains some prototype queries for iOS ETL implementing a minimal prototype of the baseline+metrics ETL proposed in the Mobile ETL (Short-Term) doc: https://docs.google.com/document/d/1aayc2G0qFJP7EOSvELgUsYklpyixeZChVMYtHlbCpw8/edit?ts=6054bd7e
The table has been created as mozdata.analysis.klukas_ios_cls_joined
and contains data for 2021 up to 2021-03-18.
We make a comparison to existing methodology in: https://sql.telemetry.mozilla.org/queries/78820/source