Ingest data from Google Pub/Sub
Pub/Sub is an asynchronous and scalable messaging service that decouples services producing messages from services processing those messages.
Quick Start
Connect in minutes with SQL
Use CREATE SOURCE or CREATE TABLE to ingest data from Google Pub/Sub into RisingWave. No plugins, no middleware — just PostgreSQL-compatible SQL.
CREATE TABLE orders_rw (
order_id INTEGER PRIMARY KEY,
customer_id INTEGER,
order_status VARCHAR,
total_amount DECIMAL,
last_updated TIMESTAMP)
WITH (
connector = 'google_pubsub',
pubsub.subscription = 'test-subscription-1',
) FORMAT PLAIN ENCODE JSON;For comprehensive configuration details, please refer to the Pub/Sub connector documentation.
Capabilities
What you can do with RisingWave + Google Pub/Sub
Real-time Ingestion
Continuously stream data from Google Pub/Sub into RisingWave with sub-second latency. Process millions of events per second.
SQL Transformations
Join Google Pub/Sub data with other sources, apply windowing, aggregation, and filtering — all in standard SQL.
Materialized Views
Create incrementally maintained materialized views over Google Pub/Sub data. Always fresh, always queryable.
Multi-format Support
Supports Avro, JSON, Protobuf, CSV, and more. Compatible with Schema Registry for schema evolution.
Start streaming in minutes
Connect to Google Pub/Sub with just a few lines of SQL. No infrastructure to manage, no code to write.