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
Top comments (0)