stream_microbatches

This table contains metadata related to microbatches

Column Data Type Description
id INT The identification number of the microbatch.
microbatch VARCHAR The name of the microbatch.
target INT The identification number of the target associated with the microbatch.
load_spec INT

The identification number of the load spec associated with the microbatch.

target_columns VARCHAR

The table columns associated with the microbatch.

rejection_schema VARCHAR

The schema that contains the rejection table.

rejection_table VARCHAR

The table where Verticastores messages that are rejected by the database.

enabled BOOLEAN When TRUE, the microbatch is enabled for use.

Examples

This example shows a row from a typical stream_microbatches table.

SELECT * FROM stream_config.stream_microbatches;
-[ RECORD 1 ]----+--------
id               | 1
microbatch       | mbatch1
target           | 1
load_spec        | 750001
target_columns   |
rejection_schema | public
rejection_table  | rejected_messages
enabled          | t