Show table monitors and their properties. Table monitors are created using
/create/tablemonitor. Returns
detailed information about existing table monitors.
Input Parameter Description
array of strings
List of monitors to be shown. An empty list or a single entry with an empty string returns all table monitors.
map of string to strings
Optional parameters.The default value is an empty map ( {} ).
Output Parameter Description
The Kinetica server embeds the endpoint response inside a standard response structure which contains status information and the actual response to the query. Here is a description of the various fields of the wrapper:
String
‘OK’ or ‘ERROR’
String
Empty if success or an error message
String
‘show_table_monitors_response’ or ‘none’ in case of an error
String
Empty string
JSON or String
This embedded JSON represents the result of the /show/tablemonitors endpoint:
Show data_str
array of strings
List of monitor IDs.
array of strings
List of source tables being monitored for the respective output parameter monitor_ids.
array of strings
List of notification events for the respective output parameter monitor_ids.
array of strings
List of columns used on the respective tables in output parameter table_names that will increase for new records.
array of strings
List of filter expressions used on the respective tables in output parameter table_names to limit records for notifications.
array of strings
List of join table names.
array of strings
List of join column names.
array of strings
List of join expressions.
array of strings
List of refresh methods used on the respective tables in output parameter table_names.
array of strings
List of refresh periods used on the respective tables in output parameter table_names.
array of strings
List of refresh start times used on the respective tables in output parameter table_names.
array of strings
List of datasink names for the respective output parameter monitor_ids if one is defined.
array of ints
Maximum number of consecutive failures for the respective output parameter monitor_ids before stream is automatically suspended.
array of strings
List of table names that will hold failed notification events when the respective output parameter monitor_ids is suspended.
array of strings
Status of stream for the respective output parameter monitor_ids.
array of maps of string to strings
Additional information about the respective monitors in output parameter monitor_ids.
Show additional_info
Notification type for the respective output parameter monitor_ids and output parameter table_names.The default value is ”.
Notification type schemas for the respective output parameter monitor_ids and output parameter table_names.The default value is ”.
Materialized view that implements the change detector.
Materialized views created for the output parameter filter_expressions.The default value is ”.
Reference count on the respective output parameter monitor_ids.The default value is ”.
Datasink info in JSON format for the respective output parameter monitor_ids if one is defined.The default value is ”.
map of string to strings
Additional information.
Empty string in case of an error.
Assistant
Responses are generated using AI and may contain mistakes.