export data query executes successfully but messages are not pushed to pub/sub topic

Question

I ran this standard query and it executes successfully.

EXPORT DATA
  OPTIONS (
    uri = 'https://pubsub.googleapis.com/projects/ggdevbigqueryproject/topics/GGTEST',
    format = 'JSON',
    overwrite = false
  )
AS
(select * from `ggdevbigqueryproject.QASOURCE.TCUSTMER`);

But no messages are pushed to pub/sub topic GGTEST.

I tried the above query where table exist under same project. I am expecting table data to be pushed as JSON messages in pub/sub topic.

SANN3 · Accepted Answer · 2025-10-05 05:33:03Z

1

BigQuery’s EXPORT DATA to Pub/Sub integration is only supported in a continuous query (streaming / continuous mode), not just a one-off export

Reference: https://cloud.google.com/bigquery/docs/export-to-pubsub

answered Oct 5 at 5:33

SANN3

10.2k7 gold badges68 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

export data query executes successfully but messages are not pushed to pub/sub topic

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related