Telemetry to Amplitude

Background

• Current Telemetry Ping data process: Client App -> Mozilla Telemetry Backend -> Mozilla Data Pipeline -> Amplitude Backend
• For [Mozilla Data Pipeline], we need a script for the data team to run a scheduled job to export telemetry data to Amplitude backend via Amplitude web API.

Trigger from Bitrise CI

Document for triggering event ping PR from Bitrise CI (Restricted within mozilla corp)

Setup

• fork https://github.com/mozilla/bigquery-etl. Assume its location is [DATA-REPO-PATH]
• Get the latest Firefox Lite source code and compile source code ./gradlew assembleFocusWebkitFirebase

Steps:

• in project root
• run below script to write the new mapping to the sql file.

cp ./docs/view.sql [DATA-REPO-PATH]/sql/telemetry/rocket_android_events_v1/view.sql 

for example

cp ./docs/view.sql ../bigquery-etl/sql/telemetry/rocket_android_events_v1/view.sql 

• Create a new PR to the data team's repo Sample PR
• Ask the BI team to verify the script again.
• Ask Frank from the data team to review and merge or slack tpe-metrics to ask questions.