jobs/experiments-monitoring-data-export/experiments_monitoring_data_export/export.py [136:157]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
        query = f"""
            SELECT * EXCEPT(experiment) FROM {dataset}
            WHERE experiment = '{experiment_slug}' AND
            time >= (
                SELECT TIMESTAMP(MIN(start_date))
                FROM `moz-fx-data-experiments.monitoring.experimenter_experiments_v1`
                WHERE normandy_slug = '{experiment_slug}'
            )
            ORDER BY time DESC
        """

    job = client.query(query)
    job.result()
    dataset_ref = bigquery.DatasetReference(source_project, job.destination.dataset_id)
    table_ref = dataset_ref.table(job.destination.table_id)

    # export data for experiment grouped by branch
    _upload_table_to_gcs(
        table_ref,
        bucket,
        gcs_path,
        experiment_slug,
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



jobs/experiments-monitoring-data-export/experiments_monitoring_data_export/export.py [165:183]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
    query = f"""
        SELECT
            time,
            SUM(value) AS value
        FROM `{source_project}.{job.destination.dataset_id}.{job.destination.table_id}`
        GROUP BY 1
        ORDER BY time DESC
    """

    job = client.query(query)
    job.result()
    dataset_ref = bigquery.DatasetReference(source_project, job.destination.dataset_id)
    table_ref = dataset_ref.table(job.destination.table_id)

    _upload_table_to_gcs(
        table_ref,
        bucket,
        gcs_path,
        experiment_slug,
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -