BigQuery

Snippits

REGEXP_EXTRACT(email, r'@(.+)') as domain

Commands

bq show --format=prettyjson bigquery-public-data:samples.wikipedia | jq '.schema.fields' 
bq show --schema --format=prettyjson myproject:mydataset.mytable

Golang libraries
Optimizing your BigQuery incremental data ingestion pipelines