This is an implementation of the BigQuery Client as a database/sql/driver for easy integration and usage.
This project is meant to be a basic database/sql driver implementation for Golang so that developers can easily use tools like Gorm, and *sql.DB functions, with Google's BigQuery database.
Check out the example application in the examples
directory, for a few examples.
As this is using the Google Cloud Go SDK, you will need to have your credentials available via the GOOGLE_APPLICATION_CREDENTIALS environment variable point to your credential JSON file.
Just like any other database/sql driver you'll need to import it
package main
import (
"database/sql"
_ "github.com/solcates/go-sql-bigquery"
"log"
)
func main() {
db, err := sql.Open("bigquery",
"bigquery:https://projectid/dataset")
if err != nil {
log.Fatal(err)
}
defer db.Close()
// Do Something with the DB
}
For gorm
package main
import (
"github.com/jinzhu/gorm"
_ "github.com/solcates/go-sql-bigquery/dialects/bigquery"
"log"
)
func main() {
db, err := gorm.Open("bigquery",
"bigquery:https://projectid/dataset")
if err != nil {
log.Fatal(err)
}
defer db.Close()
// Do Something with the DB
}
Pull Requests are welcome!
- driver.Conn implemented
- driver.Querier implemented
- driver.Pinger implemented
- gorm Dialect - have only tested basic use cases
- Prepared Statements - supported via a quick hack
- Parametiterized Queries