Skip to content

Instantly share code, notes, and snippets.

@apeckham
Created August 24, 2017 03:28
Show Gist options
  • Save apeckham/8a57cb5b8e7cbbb14c48bc68afcfce55 to your computer and use it in GitHub Desktop.
Save apeckham/8a57cb5b8e7cbbb14c48bc68afcfce55 to your computer and use it in GitHub Desktop.
connect to bigquery with clojure.java.jdbc
(ns simba
(:require [clojure.java.jdbc :as j])
(:import (com.simba.googlebigquery.jdbc42 Driver)))
(def conn {:classname "com.simba.googlebigquery.jdbc42.Driver"
:subprotocol "bigquery"
:subname "//https://www.googleapis.com/bigquery/v2:443;ProjectId=MY-PROJECT-ID;OAuthServiceAcctEmail=USERNAME@PROJECT.iam.gserviceaccount.com;OAuthPvtKeyPath=PATH-TO-P12-FILE"})
(defn run-query [query] (j/query conn [query]))
(prn (run-query "select 1"))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment