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