{"library":"google-cloud-bigquery","type":"library","category":null,"description":"Official Python client for Google BigQuery. Current version: 3.40.1 (Mar 2026). v3.0 made google-cloud-bigquery-storage and pyarrow required dependencies. Authentication uses Application Default Credentials (ADC) — no explicit API key. query() returns a QueryJob — must call .result() to wait for completion. to_dataframe() dtype behavior changed in v3 (nullable pandas dtypes). Python 3.9+ required as of v3.x.","language":"python","status":"active","version":"3.40.1","tags":["bigquery","google-cloud","python","data","sql","analytics"],"last_verified":"Tue Jun 09","install":[{"cmd":"pip install google-cloud-bigquery","imports":["from google.cloud import bigquery\n\n# ADC auth — uses GOOGLE_APPLICATION_CREDENTIALS env var\n# or gcloud CLI credentials locally\nclient = bigquery.Client(project='my-project')\n\n# query() returns a QueryJob — NOT results\nquery = \"\"\"\n    SELECT name, COUNT(*) as count\n    FROM `bigquery-public-data.usa_names.usa_1910_2013`\n    WHERE state = 'TX'\n    GROUP BY name\n    ORDER BY count DESC\n    LIMIT 10\n\"\"\"\nquery_job = client.query(query)  # starts job\nrows = query_job.result()       # BLOCKS until complete\n\nfor row in rows:\n    print(row.name, row.count)","from google.cloud import bigquery\n\nclient = bigquery.Client(project='my-project')\nquery = 'SELECT id, name, created_at FROM `myproject.mydataset.mytable` LIMIT 100'\n\n# to_dataframe() requires pandas + pyarrow + db-dtypes\ndf = client.query(query).result().to_dataframe()\nprint(df.dtypes)\n# id: Int64 (nullable) — not int64\n# name: object\n# created_at: dbdate"]},{"cmd":"pip install 'google-cloud-bigquery[pandas]'","imports":[]},{"cmd":"pip install 'google-cloud-bigquery[pandas,pyarrow]'","imports":[]}],"homepage":"https://cloud.google.com/bigquery","github":"https://github.com/googleapis/python-bigquery","docs":null,"changelog":null,"pypi":"https://pypi.org/project/google-cloud-bigquery/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"compatibility":{"summary":{"python_range":"3.10–3.9","success_rate":100,"avg_install_s":12.1,"avg_import_s":2.44,"wheel_type":"wheel"},"url":"https://checklist.day/v1/registry/google-cloud-bigquery/compatibility"}}