Everything we've written about BigQuery: connections, SQL patterns, imports, clients, and comparisons.
Connect to Google BigQuery from Ruby with the official google-cloud-bigquery gem. Covers Application Default Credentials, the billing-vs-data project split, named and positional query parameters, the dataset location trap, and dry-run cost caps.
Connect to Google BigQuery from PHP with the google/cloud-bigquery client: composer install, ADC authentication, running queries with parameters, the location trap, dry-run cost controls, and the errors you actually hit.
Connect to BigQuery from C# with Google.Cloud.BigQuery.V2: ADC and service-account auth, running queries, named and positional parameters, reading results, cost controls, and the errors you actually hit.
Connect to BigQuery from Java with the official google-cloud-bigquery client: authentication with Application Default Credentials, running queries, named parameters, cost controls, the location trap, and the errors you actually hit.
Connect to BigQuery from Go with the official cloud.google.com/go/bigquery client. Working code for the ADC auth ladder, parameterized queries, RowIterator scanning, cost controls, and the dataset-location trap.
Connect to BigQuery from Node.js with @google-cloud/bigquery. Working code for ADC and service-account auth, queries, named and positional parameters, DataFrame-free result handling, and cost controls.
Connect to BigQuery from Python with google-cloud-bigquery, pandas-gbq, or BigQuery DataFrames. Working code for auth (ADC and service accounts), queries, parameters, and cost controls.
Four ways to import Excel data into BigQuery: upload CSV via the Cloud Console, use Google Sheets as an intermediary, Python with pandas-gbq, and Mako. Covers GCS staging, schema auto-detection, and large files.
Three ways to import JSON data into BigQuery: bq load CLI, the BigQuery Console, and Mako. Covers NDJSON requirements, schema auto-detection, nested structs, and Cloud Storage staging.
Four ways to import CSV files into BigQuery: the bq CLI, Google Cloud Console, Python client library, and Cloud Storage loads. Includes schema detection and quota tips.