The following keywords allow for setting table parameters via SQL. This is useful for applying configuration for how the system handles out-of-order data ingestion on a per-table basis. For more information on these values including details on why these settings should be applied, see the documentation for out-of-order data commits.

:::info

Checking table metadata can be done via the tables() and table_columns() functions which are described in the meta functions documentation page.

:::

Syntax

Example

The values for maximum uncommitted rows and a time range for commit lag can changed per each table with the following SQL:

ALTER TABLE my_table SET PARAM maxUncommittedRows=10000
ALTER TABLE my_table SET PARAM commitLag=20s

Checking the values per-table may be done using the tables() function:

select id, name, maxUncommittedRows, commitLag from tables();

For more details on retrieving table and column information, see the meta functions documentation.