URL: http://<db.host>:<db.port>/show/tablemonitors
Show table monitors and their properties. Table monitors are created using
/create/tablemonitor . Returns
detailed information about existing table monitors.
List of monitors to be shown. An empty list or a single entry with an empty string returns all table monitors.
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:
Empty if success or an error message
‘show_table_monitors_response’ or ‘none’ in case of an error
This embedded JSON represents the result of the /show/tablemonitors endpoint: List of source tables being monitored for the respective output parameter monitor_ids .
List of notification events for the respective output parameter monitor_ids .
List of columns used on the respective tables in output parameter table_names that will increase for new records.
List of filter expressions used on the respective tables in output parameter table_names to limit records for notifications.
List of join table names.
List of join column names.
List of join expressions.
List of refresh methods used on the respective tables in output parameter table_names .
List of refresh periods used on the respective tables in output parameter table_names .
List of refresh start times used on the respective tables in output parameter table_names .
List of datasink names for the respective output parameter monitor_ids if one is defined.
Maximum number of consecutive failures for the respective output parameter monitor_ids before stream is automatically suspended.
failed_notifications_table_names
List of table names that will hold failed notification events when the respective output parameter monitor_ids is suspended.
Status of stream for the respective output parameter monitor_ids .
additional_info
array of maps of string to strings
Additional information about the respective monitors in output parameter monitor_ids . 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_for_change_detector
Materialized view that implements the change detector.
materialized_view_for_filter
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 ”.
Empty string in case of an error. 
