forked from snowflakedb/gosnowflake
/
oauth.go
66 lines (59 loc) · 1.49 KB
/
oauth.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
// Example: Authenticate with OAuth. In order for this to work, one should
// complete the OAuth flow to get an access token, which is beyond (for now!)
// the scope of this example.
//
package main
import (
"database/sql"
"flag"
"fmt"
"log"
"net/url"
"os"
_ "github.com/snowflakedb/gosnowflake"
)
func main() {
if !flag.Parsed() {
// enable glog for Go Snowflake Driver
flag.Parse()
}
// get environment variables
env := func(k string) string {
if value := os.Getenv(k); value != "" {
return value
}
log.Fatalf("%v environment variable is not set.", k)
return ""
}
account := env("SNOWFLAKE_TEST_ACCOUNT")
token := env("SNOWFLAKE_TEST_OAUTH_TOKEN")
// Tokens must be escaped before being used in the DSN!
escapedToken := url.QueryEscape(token)
dsn := fmt.Sprintf("%v?authenticator=OAUTH&token=%v", account, escapedToken)
db, err := sql.Open("snowflake", dsn)
if err != nil {
log.Fatalf("failed to connect. %v, err: %v", dsn, err)
}
defer db.Close()
query := "SELECT 1"
rows, err := db.Query(query) // no cancel is allowed
if err != nil {
log.Fatalf("failed to run a query. %v, err: %v", query, err)
}
defer rows.Close()
var v int
for rows.Next() {
err := rows.Scan(&v)
if err != nil {
log.Fatalf("failed to get result. err: %v", err)
}
if v != 1 {
log.Fatalf("failed to get 1. got: %v", v)
}
}
if rows.Err() != nil {
fmt.Printf("ERROR: %v\n", rows.Err())
return
}
fmt.Printf("Congrats! You have successfully run %v with Snowflake DB!\n", query)
}