Skip to content

Instantly share code, notes, and snippets.

@victortrac

victortrac/bq.sql

Last active August 18, 2022 15:30
Show Gist options
  • Save victortrac/404875d9f1f42668145e34dfed006492 to your computer and use it in GitHub Desktop.
Save victortrac/404875d9f1f42668145e34dfed006492 to your computer and use it in GitHub Desktop.
Download ZIP
BigQuery to find changelog updates to GCP services ordered by last update
Raw
bq.sql
SELECT max(published_at) as last_update,
min(published_at) as first_update,
DATE_DIFF(max(published_at),min(published_at),DAY) as age_days,
product_name FROM `bigquery-public-data.google_cloud_release_notes.release_notes`
GROUP BY product_name
ORDER BY last_update asc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment