WAIT

A streaming job is a job that creates a materialized view, a table, a sink, or an index. When background DDL is enabled via SET BACKGROUND_DDL, these creation commands return immediately while the actual backfill runs in the background. The WAIT command lets you pause your session until a specific job — or all in-progress jobs — complete.

Syntax

WAIT [ TABLE table_name
     | MATERIALIZED VIEW mv_name
     | SINK sink_name
     | INDEX index_name ];

With no target, WAIT blocks until all background streaming jobs finish (timeout: 2 hours).
With a target, WAIT blocks until the specified object’s creation job finishes.

Parameters

Parameter	Description
`TABLE table_name`	Wait for the background creation job of the specified user table.
`MATERIALIZED VIEW mv_name`	Wait for the background creation job of the specified materialized view.
`SINK sink_name`	Wait for the background creation job of the specified sink.
`INDEX index_name`	Wait for the background creation job of the specified index.

Examples

Wait for all background jobs to finish:

WAIT;

Start a materialized view creation in the background, then wait for it to complete before querying:

SET BACKGROUND_DDL = true;

CREATE MATERIALIZED VIEW mv AS SELECT * FROM t;
-- Returns immediately; backfill runs in the background.

WAIT MATERIALIZED VIEW mv;
-- Blocks until the backfill for mv is done.

SELECT * FROM mv;

Wait for a specific table’s creation to finish:

WAIT TABLE my_table;

Syntax

Parameters

Examples

SET BACKGROUND_DDL

SHOW JOBS

CANCEL JOBS

​Syntax

​Parameters

​Examples

​Related topics

SET BACKGROUND_DDL

SHOW JOBS

CANCEL JOBS

Syntax

Parameters

Examples

Related topics