Slide 26
Slide 26 text
Publish API
Outbox Table
CREATE TABLE outbox (
id STRING(64) NOT NULL,
information_1 INT64 NOT NULL,
information_2 STRING(64) NOT NULL,
…,
pubsub_topic STRING(64) NOT NULL,
created TIMESTAMP NOT NULL OPTIONS (
allow_commit_timestamp = true
),
updated TIMESTAMP NOT NULL OPTIONS (
allow_commit_timestamp = true
),
is_published BOOL NOT NULL,
schedule TIMESTAMP,
) PRIMARY KEY(id);
Information used in Pub/Sub message
Pub/Sub topic
Is this record published
Don’t publish until this time