Skip to content

Instantly share code, notes, and snippets.

@davideanastasia

davideanastasia/bigquery_ml_0006.sql

Created October 11, 2018 21:39
Show Gist options
  • Save davideanastasia/341e99eb8f99e4d27b8f9a1d246f7e33 to your computer and use it in GitHub Desktop.
Save davideanastasia/341e99eb8f99e4d27b8f9a1d246f7e33 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
bigquery_ml_0006.sql
CREATE TABLE `kaggle_talkingdata_adtracking.dataset_test_submission_logreg_0001`
AS
SELECT click_id, prob as is_attributed
FROM `kaggle_talkingdata_adtracking.dataset_test_with_prediction_logreg_0001`
JOIN UNNEST(predicted_is_attributed_probs)
WHERE label = 1
ORDER BY click_id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment