bigquery: timestamp parsing issue when fetching parameterized query jobs and their config #9221
Description
Client
BigQuery
Environment
MacOS
Go Environment
$ go version
go version go1.21.1 darwin/arm64
$ go env
GO111MODULE=''
GOARCH='arm64'
GOBIN=''
GOCACHE='/Users/hsvnsson/Library/Caches/go-build'
GOENV='/Users/hsvnsson/Library/Application Support/go/env'
GOEXE=''
GOEXPERIMENT=''
GOFLAGS=''
GOHOSTARCH='arm64'
GOHOSTOS='darwin'
GOINSECURE=''
GOMODCACHE='/Users/hsvnsson/go/pkg/mod'
GONOPROXY=''
GONOSUMDB=''
GOOS='darwin'
GOPATH='/Users/hsvnsson/go'
GOPRIVATE=''
GOPROXY='https://proxy.golang.org,direct'
GOROOT='/usr/local/go'
GOSUMDB='sum.golang.org'
GOTMPDIR=''
GOTOOLCHAIN='auto'
GOTOOLDIR='/usr/local/go/pkg/tool/darwin_arm64'
GOVCS=''
GOVERSION='go1.21.1'
GCCGO='gccgo'
AR='ar'
CC='clang'
CXX='clang++'
CGO_ENABLED='1'
GOMOD='/dev/null'
GOWORK=''
CGO_CFLAGS='-O2 -g'
CGO_CPPFLAGS=''
CGO_CXXFLAGS='-O2 -g'
CGO_FFLAGS='-O2 -g'
CGO_LDFLAGS='-O2 -g'
PKG_CONFIG='pkg-config'
GOGCCFLAGS='-fPIC -arch arm64 -pthread -fno-caret-diagnostics -Qunused-arguments -fmessage-length=0 -ffile-prefix-map=/var/folders/6w/pc370vsn5c7dtm7gsxm1y9440000gn/T/go-build217012697=/tmp/go-build -gno-record-gcc-switches -fno-common'
Code
package main
import (
"context"
"errors"
"flag"
"log"
"time"
"cloud.google.com/go/bigquery"
"google.golang.org/api/iterator"
"google.golang.org/api/option"
)
func main() {
ctx := context.Background()
serviceAccountPath := flag.String("service-account", "", "Path to service account JSON file")
project := flag.String("project", "", "Project")
flag.Parse()
client, err := bigquery.NewClient(ctx, *project, option.WithCredentialsFile(*serviceAccountPath))
if err != nil {
log.Fatalf("Failed to create client: %v", err)
}
defer client.Close()
it := client.Jobs(ctx)
it.AllUsers = true
it.State = bigquery.Done
it.MinCreationTime = time.Now().Add(-1 * time.Hour)
it.MaxCreationTime = time.Now()
for {
job, err := it.Next()
if errors.Is(err, iterator.Done) {
break
}
if err != nil {
log.Fatalf("Failed to get next job: %v", err)
}
jobConfig, err := job.Config()
if err != nil {
log.Fatalf("Failed to parse job: %v", err)
}
_ = jobConfig
}
}Expected behavior
Following the example in the docs to submit a BigQuery query with a timestamp parameter and then listing jobs using the golang sdk it should be possible to get the job configs without any errors.
Setup:
bq query \
--use_legacy_sql=false \
--parameter='ts_value:TIMESTAMP:2016-12-07 08:00:00' \
'SELECT
TIMESTAMP_ADD(@ts_value, INTERVAL 1 HOUR);'
Then using the code provided above, the call to job.Config() should return a properly parsed job config.
Actual behavior
Error while parsing timestamp:
$ go run main.go -project some-project -service-account ./creds.json
2024/01/04 17:47:40 Failed to parse job: parsing time "2016-12-07T08:00:00" as "2006-01-02T15:04:05.999999999Z07:00": cannot parse "" as "Z07:00"
exit status 1
Additional context
if a timezone is included in the timestamp like --parameter='ts_value:TIMESTAMP:2016-12-07 08:00:00+00:00' then it works but since that's not required and also not included in the example then it would be good if the library handles that format as well.