UnknownJob timestamp properties not being cast #1377
Description
Environment details
- OS type and version: MacOS 12.5
- Python version: Python 3.8.10
- pip version: pip 22.2.2
google-cloud-bigqueryversion: 3.1.0
Steps to reproduce
- Create a service account that doesn't have the
bigquery.jobs.listAllpermission - Use that service account to fetch a job created by another user (lots of fields will not come, or come redacted, including
jobType, so the_AsyncJobwill be anUnknownJob, see here) - Try to access the job.started field, it'll break (here) because the timestamp fields aren't being cast to int for
UnkownJobinstances
Code example
import json
import google_auth_httplib2
import httplib2
from google.cloud import bigquery
from google.oauth2 import service_account
from googleapiclient.discovery import build
f = open("bigquery_service_account.json")
sa = f.read()
scopes = ["https://www.googleapis.com/auth/bigquery.readonly"]
credentials = service_account.Credentials.from_service_account_info(
json.loads(sa), scopes=scopes
)
# client
client = bigquery.Client(credentials=credentials)
# service
http = httplib2.Http()
authed_http = google_auth_httplib2.AuthorizedHttp(credentials, http=http)
service = build("bigquery", "v2", http=authed_http, cache_discovery=False)
jobs = (
service.jobs()
.list(
allUsers=True,
projectId="<project_id>",
maxResults=1,
projection="full",
)
.execute(num_retries=1)
)
jobs = jobs.get("jobs", [])
for job in jobs:
job = client.job_from_resource(job)
print(job.started)Stack trace
Traceback (most recent call last):
File "bqtest.py", line 38, in <module>
print(job.started)
File "[...]lib/python3.8/site-packages/google/cloud/bigquery/job/base.py", line 336, in started
return _helpers._datetime_from_microseconds(millis * 1000.0)
TypeError: can't multiply sequence by non-int of type 'float'