SputnikTea

#!/bin/bash

# Needs google cloud SDK installed and initated
# Deploy before scheduler

FUNC_NAME="delete_bqml_pipe_slots"
PROJECT_ID="my-project"
REGION="europe-west1"
# Service Account with bigquery.resourceAdmin role
SA_ID="bqml-pipe-slot-admin"

SputnikTea

/*
is_relevant_col is
 - '0' for irrelevant recommendations (negatives)
 - '1' for relevant recommendations (positives)
*/

WITH t1 AS ( -- Precition@k per row
    SELECT *,
        avg(is_relevant_col)
            OVER(