stream_microbatches

This table contains configuration data related to microbatches.

Column	Data Type	Description
id	INTEGER	The identification number of the microbatch.
microbatch	VARCHAR	The name of the microbatch.
target	INTEGER	The identification number of the target associated with the microbatch.
load_spec	INTEGER	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