Go Analytics SDK Quickstart Guide
Install, connect, try. A quick start guide to get you up and running with Enterprise Analytics and the Go Analytics SDK.
Enterprise Analytics is a real-time analytical database (RT-OLAP) for real time apps and operational intelligence. Although maintaining some syntactic similarities with the operational SDKs, the Go Analytics SDK is developed from the ground-up for column-based analytical use cases, and supports streaming APIs to handle large datasets.
Before You Start
Install and configure an Enterprise Analytics Cluster.
Adding the SDK to an Existing Project
Declare a dependency on the SDK using its Full Installation.
To see log messages from the SDK, consult the logging documentation.
Connecting and Executing a Query
Go Analytics SDK 1.1 adds support for JWT and client certificate authentication, as well as a new Server Asynchronous Request API that uses request handles to fetch results. Introduced in the self-managed Enterprise Analytics Server 2.2, this API eliminates the need for long-running server connections.
The examples in this first section of the page are for the standard API — async on the client side — working with Enterprise Analytics 2.0 and later (with Server Asynchronous Request API examples following in the Server Async section). You can still use this API with Enterprise Analytics 2.2 and later, in addition to the new API.
Server Synchronous Request API
package main
import (
"context"
"fmt"
"time"
"github.com/couchbase/gocbanalytics"
)
func helloWorld() {
cluster, err := cbanalytics.NewCluster(
connStr,
cbanalytics.NewBasicAuthCredential(username, password),
// The third parameter is optional.
// This example sets the default server query timeout to 3 minutes,
// that is the timeout value sent to the query server.
cbanalytics.NewClusterOptions().SetTimeoutOptions(
cbanalytics.NewTimeoutOptions().SetQueryTimeout(3*time.Minute),
),
)
handleErr(err)
// We create a new context with a timeout of 2 minutes.
// This context will apply timeout/cancellation on the client side.
ctx, cancel := context.WithTimeout(context.Background(), 2*time.Minute)
defer cancel()
printRows := func(result *cbanalytics.QueryResult) {
for row := result.NextRow(); row != nil; row = result.NextRow() {
var content map[string]interface{}
err = row.ContentAs(&content)
handleErr(err)
fmt.Printf("Got row content: %v", content)
}
}
// Execute a query and process rows as they arrive from server.
// Results are always streamed from the server.
result, err := cluster.ExecuteQuery(ctx, "select 1")
handleErr(err)
printRows(result)
// Execute a query with positional arguments.
result, err = cluster.ExecuteQuery(
ctx,
"select ?=1",
cbanalytics.NewQueryOptions().SetPositionalParameters([]interface{}{1}),
)
handleErr(err)
printRows(result)
// Execute a query with named arguments.
result, err = cluster.ExecuteQuery(
ctx,
"select $foo=1",
cbanalytics.NewQueryOptions().SetNamedParameters(map[string]interface{}{"foo": 1}),
)
handleErr(err)
printRows(result)
err = cluster.Close()
handleErr(err)
}
Server Asynchronous Request API
Enterprise Analytics 2.2 introduces a Server Asynchronous Request API. The SDK sends a request, polls for results, and then fetches once the result is available.
package main
import (
"context"
"fmt"
"log"
"time"
cbanalytics "github.com/couchbase/gocbanalytics"
)
func waitForQueryResults(ctx context.Context, handle *cbanalytics.QueryHandle, delay time.Duration) (*cbanalytics.QueryResultHandle, error) {
var lastStatus *cbanalytics.QueryStatus
deadline, _ := ctx.Deadline()
for {
status, err := handle.FetchStatus(ctx)
if err != nil {
fmt.Printf("Error fetching query results: %v\n", err)
} else {
if status.ResultsReady() {
return status.ResultHandle()
}
lastStatus = status
}
nextPoll := time.Now().Add(delay)
if deadline.Before(nextPoll) {
return nil, fmt.Errorf("query results not ready")
}
if lastStatus != nil {
fmt.Printf("Query status: %s\n", lastStatus)
}
fmt.Printf("Query results not ready yet, sleeping for %s...\n", delay)
time.Sleep(delay)
}
}
func main() {
endpoint := "https://localhost"
username := "Administrator"
password := "password"
cred := cbanalytics.NewBasicAuthCredential(username, password)
cluster, err := cbanalytics.NewCluster(endpoint, cred)
if err != nil {
log.Fatalf("failed to create cluster: %v", err)
}
defer func() {
if err := cluster.Close(); err != nil {
log.Printf("failed to close cluster: %v", err)
}
}()
ctx, cancel := context.WithTimeout(context.Background(), 60*time.Second)
defer cancel()
statement := `SELECT VALUE SLEEP("x", 100) FROM RANGE(1, 100) AS id;`
handle, err := cluster.StartQuery(ctx, statement)
if err != nil {
log.Fatalf("failed to start query: %v", err)
}
resultHandle, err := waitForQueryResults(ctx, handle, 2500*time.Millisecond)
if err != nil {
log.Fatalf("waiting for results: %v", err)
}
res, err := resultHandle.FetchResults(ctx)
if err != nil {
log.Fatalf("failed to fetch results: %v", err)
}
for row := res.NextRow(); row != nil; row = res.NextRow() {
var val interface{}
if err := row.ContentAs(&val); err != nil {
log.Printf("failed to decode row: %v", err)
continue
}
fmt.Printf("Found row: %v\n", val)
}
if err := res.Err(); err != nil {
log.Fatalf("result error: %v", err)
}
metadata, err := res.MetaData()
if err != nil {
log.Fatalf("failed to get metadata: %v", err)
}
fmt.Printf("metadata=%+v\n", metadata)
if err := resultHandle.DiscardResults(ctx); err != nil {
log.Printf("failed to discard results: %v", err)
}
}
Connection String
The connStr in the above example should take the form of "https://<your_hostname>:" + PORT
The default port is 443, for TLS connections.
You do not need to give a port number if you are using port 443 — hostname = "https://<your_hostname>" is effectively the same as `hostname = "https://<your_hostname>:" + "443"
If you are using a different port — for example, connecting to a cluster without a load balancer, directly to the Analytics port, 18095 — or not using TLS,
then see the Connecting to Enterprise Analytics page.
const (
connStr = "https://analytics.example.com:18095"
username = "user"
password = "password"
)
Migration from Row-Based Analytics
If you are migrating a project from CBAS — our Analytics service on Capella Operational and Couchbase Server, using our operational SDKs — then information on migration can be found in the Enterprise Analytics docs.
In particular, refer to the SDK section of the Enterprise Analytics migration pages.