Solved: Continuous queries in BigQuery? - Page 2

elecnix · 12-11-2023 02:48 PM

Hello!

I was going through the output of bq help query and found a --continuous option:

continuous: [Optional] Specifies whether the query should be executed as a
continuous query. The default value is false.

I could not find any related documentation.

$ bq query --continuous 'select count(*) from dataset.mytable'
Error in query string: Error processing job '...': Legacy SQL queries cannot run continuously.

What queries can run continuously?

nickorlove

Hey Elecnix,

I'm the product manager for this feature. As highlighted above, this feature is current under development and in a private preview. So unless we've allowlisted your project to use this feature, you won't have the ability to call this option. We'll actually be speaking in more detail about this feature at the Next conference in April. Here's a link to my session in case you're able to attend and/or view the recording afterwards: https://cloud.withgoogle.com/next/session-library?session=ANA211

Thanks, Nick

View solution in original post