DEV Community

Luke Garzia
Luke Garzia

Posted on

Monitoring BigQuery Release Notes

Here's a code snippet for those trying to monitor BigQuery release notes. I separate out 'generally available' versus 'preview'. Also, I isolate BQML versus BQ because I see them as different services.

WITH base_bq_features AS
(
  SELECT description, release_note_type, published_at, product_name, 
  CASE WHEN description like '%[generally available]%' THEN 'ga_release'
  WHEN description like '%[preview]%' THEN 'preview'
  ELSE 'other' END type_of_release,
  CASE WHEN description like '%BigQuery ML%' Then 'BQML' ELSE 'Other' END AS isBQML
  FROM `bigquery-public-data.google_cloud_release_notes.release_notes` 
  WHERE product_name = 'BigQuery'
  AND release_note_type = 'FEATURE'
  ORDER BY published_at DESC
)
SELECT *
FROM base_bq_features
WHERE published_at > '2023-01-01'
AND type_of_release != 'preview'
ORDER by published_at DESC
Enter fullscreen mode Exit fullscreen mode

Top comments (0)