BigQuery Advent Calendar 2025

9 participant

24 followers

23 likes

Category：DevOps & Infrastructure & SRE

Creator：

@na0

Tags：

BigQuery

BigQueryに関する話を投稿しましょう。

BigQueryが主役級の話から、BigQueryが隅っこで頑張る話まで、お気軽にどうぞ。

昨年のアドベントカレンダー
https://qiita.com/advent-calendar/2024/bigquery

How to join the calendar

You can join the calendar by selecting an available date and registering the URL of the article you wish to link to. If a slot is available, you can go back to a past date to join!

Series 1

Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
30	@shiozaki BigQueryで括弧なしに呼び出せる関数一覧 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 2 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 3 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 4 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 5 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@na0 2025 年の BigQuery と目指す新世界 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use
Join calendar on 7 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 8 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 9 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 10 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 11 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 12 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@kujira6803 BigQuery 最近の推しアップデート3選 (2025) Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use
@ck_fm0211 セマンティックレイヤってなんなのをBigQueryで確認する Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 15 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 16 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 17 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 18 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoshiokatsuneo@github BigQuery最適化: 相関サブクエリはスカラーサブクエリを配列サブクエリにするとフィルタされる Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@hawkymisc まだBigQueryのない現場で消耗してるの？そうだよ。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use
@senohirona BigQueryテーブルのカラム説明文の有無による生成AI機能の差異検証 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@hiracky16 AI.GENERATE_TEXT 関数を本番稼働する際に考えたこと Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Kazuya_Araki_Tokyo recursive CTEs Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 24 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 25 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	26	27

@shiozaki
BigQueryで括弧なしに呼び出せる関数一覧
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 2 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 3 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 4 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 5 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@na0
2025 年の BigQuery と目指す新世界
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 7 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 8 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 9 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 10 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 11 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 12 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@kujira6803
BigQuery 最近の推しアップデート3選 (2025)
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@ck_fm0211
セマンティックレイヤってなんなのをBigQueryで確認する
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 15 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 16 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 17 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 18 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoshiokatsuneo@github
BigQuery最適化: 相関サブクエリはスカラーサブクエリを配列サブクエリにするとフィルタされる
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@hawkymisc
まだBigQueryのない現場で消耗してるの？そうだよ。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@senohirona
BigQueryテーブルのカラム説明文の有無による生成AI機能の差異検証
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@hiracky16
AI.GENERATE_TEXT 関数を本番稼働する際に考えたこと
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Kazuya_Araki_Tokyo
recursive CTEs
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 24 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 25 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use

Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
30	@shiozaki BigQueryで括弧なしに呼び出せる関数一覧 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 2 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 3 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 4 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 5 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@na0 2025 年の BigQuery と目指す新世界 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use
Join calendar on 7 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 8 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 9 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 10 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 11 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 12 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@kujira6803 BigQuery 最近の推しアップデート3選 (2025) Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use
@ck_fm0211 セマンティックレイヤってなんなのをBigQueryで確認する Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 15 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 16 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 17 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 18 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoshiokatsuneo@github BigQuery最適化: 相関サブクエリはスカラーサブクエリを配列サブクエリにするとフィルタされる Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@hawkymisc まだBigQueryのない現場で消耗してるの？そうだよ。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use
@senohirona BigQueryテーブルのカラム説明文の有無による生成AI機能の差異検証 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@hiracky16 AI.GENERATE_TEXT 関数を本番稼働する際に考えたこと Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Kazuya_Araki_Tokyo recursive CTEs Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 24 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	Join calendar on 25 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	26	27

@shiozaki
BigQueryで括弧なしに呼び出せる関数一覧
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 2 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 3 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 4 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 5 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@na0
2025 年の BigQuery と目指す新世界
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 7 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 8 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 9 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 10 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 11 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 12 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@kujira6803
BigQuery 最近の推しアップデート3選 (2025)
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@ck_fm0211
セマンティックレイヤってなんなのをBigQueryで確認する
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 15 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 16 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 17 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 18 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoshiokatsuneo@github
BigQuery最適化: 相関サブクエリはスカラーサブクエリを配列サブクエリにするとフィルタされる
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@hawkymisc
まだBigQueryのない現場で消耗してるの？そうだよ。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@senohirona
BigQueryテーブルのカラム説明文の有無による生成AI機能の差異検証
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@hiracky16
AI.GENERATE_TEXT 関数を本番稼働する際に考えたこと
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Kazuya_Araki_Tokyo
recursive CTEs
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 24 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
Join calendar on 25 day
You can also reserve a slot without registering a title or URL.
Title
URL
Articles to be submitted are welcome on any website as well as on Qiita.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use

You can increase the number of series when Calendar 1 is filled with more than 10 articles.

BigQuery Advent Calendar 2025

edit_calendarHow to join the calendar

Series 1

How to join the calendar