> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# show_table_monitors

<div className="kinetica-pydoc">
  <div className="dl py method">
    <div className="dt sig sig-object py" id="gpudb.GPUdb.show_table_monitors"> <span className="sig-name descname"><span className="pre">show\_table\_monitors</span></span><span className="sig-paren">(</span><span className="em sig-param"><span className="n"><span className="pre">monitor\_ids</span></span><span className="o"><span className="pre">=</span></span><span className="default_value"><span className="pre">None</span></span></span>, <span className="em sig-param"><span className="n"><span className="pre">options</span></span><span className="o"><span className="pre">=</span></span><span className="default_value"><span className="pre">{"{"}{"}"}</span></span></span><span className="sig-paren">)</span><a href="https://github.com/kineticadb/kinetica-api-python/blob/master/gpudb/gpudb.py#L40244"><span className="viewcode-link"><span className="pre">\[source]</span></span></a></div>

    <div className="dd">
      <p>Show table monitors and their properties. Table monitors are created using <a className="reference internal" href="#gpudb.GPUdb.create_table_monitor" title="gpudb.GPUdb.create_table_monitor"><code className="xref py py-meth docutils literal notranslate"><span className="pre">GPUdb.create\_table\_monitor()</span></code></a>. Returns detailed information about existing table monitors.</p>
      <p><strong>Parameters</strong></p>

      <div className="blockquote">
        <div>
          <div className="dl simple">
            <div className="dt">monitor\_ids (<span className="em">list of str</span>) –</div>

            <div className="dd">
              <p>List of monitors to be shown. An empty list or a single entry with an empty string returns all table monitors. The user can provide a single element (which will be automatically promoted to a list internally) or a list.</p>
            </div>

            <div className="dt">options (<span className="em">dict of str to str</span>) –</div>

            <div className="dd">
              <p>Optional parameters. The default value is an empty dict ( {"{"}{"}"} ).</p>
            </div>
          </div>
        </div>
      </div>

      <p><strong>Returns</strong></p>

      <div className="blockquote">
        <div>
          <p>A dict with the following entries–</p>

          <div className="dl simple">
            <div className="dt">monitor\_ids (<span className="em">list of str</span>) –</div>

            <div className="dd">
              <p>List of monitor IDs.</p>
            </div>

            <div className="dt">table\_names (<span className="em">list of str</span>) –</div>

            <div className="dd">
              <p>List of source tables being monitored for the respective output parameter <span className="em">monitor\_ids</span>.</p>
            </div>

            <div className="dt">events (<span className="em">list of str</span>) –</div>

            <div className="dd">
              <p>List of notification events for the respective output parameter <span className="em">monitor\_ids</span>.</p>
            </div>

            <div className="dt">increasing\_columns (<span className="em">list of str</span>) –</div>

            <div className="dd">
              <p>List of columns used on the respective tables in output parameter <span className="em">table\_names</span> that will increase for new records.</p>
            </div>

            <div className="dt">filter\_expressions (<span className="em">list of str</span>) –</div>

            <div className="dd">
              <p>List of filter expressions used on the respective tables in output parameter <span className="em">table\_names</span> to limit records for notifications.</p>
            </div>

            <div className="dt">join\_table\_names (<span className="em">list of str</span>) –</div>

            <div className="dd">
              <p>List of join table names.</p>
            </div>

            <div className="dt">join\_column\_names (<span className="em">list of str</span>) –</div>

            <div className="dd">
              <p>List of join column names.</p>
            </div>

            <div className="dt">join\_expressions (<span className="em">list of str</span>) –</div>

            <div className="dd">
              <p>List of join expressions.</p>
            </div>

            <div className="dt">refresh\_method (<span className="em">list of str</span>) –</div>

            <div className="dd">
              <p>List of refresh methods used on the respective tables in output parameter <span className="em">table\_names</span>.</p>
            </div>

            <div className="dt">refresh\_period (<span className="em">list of str</span>) –</div>

            <div className="dd">
              <p>List of refresh periods used on the respective tables in output parameter <span className="em">table\_names</span>.</p>
            </div>

            <div className="dt">refresh\_start\_time (<span className="em">list of str</span>) –</div>

            <div className="dd">
              <p>List of refresh start times used on the respective tables in output parameter <span className="em">table\_names</span>.</p>
            </div>

            <div className="dt">datasink\_names (<span className="em">list of str</span>) –</div>

            <div className="dd">
              <p>List of datasink names for the respective output parameter <span className="em">monitor\_ids</span> if one is defined.</p>
            </div>

            <div className="dt">max\_consecutive\_failures (<span className="em">list of ints</span>) –</div>

            <div className="dd">
              <p>Maximum number of consecutive failures for the respective output parameter <span className="em">monitor\_ids</span> before stream is automatically suspended.</p>
            </div>

            <div className="dt">failed\_notifications\_table\_names (<span className="em">list of str</span>) –</div>

            <div className="dd">
              <p>List of table names that will hold failed notification events when the respective output parameter <span className="em">monitor\_ids</span> is suspended.</p>
            </div>

            <div className="dt">statuses (<span className="em">list of str</span>) –</div>

            <div className="dd">
              <p>Status of stream for the respective output parameter <span className="em">monitor\_ids</span>.</p>
            </div>

            <div className="dt">additional\_info (<span className="em">list of dicts of str to str</span>) –</div>

            <div className="dd">
              <p>Additional information about the respective monitors in output parameter <span className="em">monitor\_ids</span>. Allowed keys are:</p>

              <ul className="simple">
                <li>
                  <p><strong>monitor\_type</strong> – Notification type for the respective output parameter <span className="em">monitor\_ids</span> and output parameter <span className="em">table\_names</span>. The default value is ‘’.</p>
                </li>

                <li>
                  <p><strong>type\_schema</strong> – Notification type schemas for the respective output parameter <span className="em">monitor\_ids</span> and output parameter <span className="em">table\_names</span>. The default value is ‘’.</p>
                </li>

                <li>
                  <p><strong>materialized\_view\_for\_change\_detector</strong> – Materialized view that implements the change detector.</p>
                </li>

                <li>
                  <p><strong>materialized\_view\_for\_filter</strong> – Materialized views created for the output parameter <span className="em">filter\_expressions</span>. The default value is ‘’.</p>
                </li>

                <li>
                  <p><strong>references</strong> – Reference count on the respective output parameter <span className="em">monitor\_ids</span>. The default value is ‘’.</p>
                </li>

                <li>
                  <p><strong>datasink\_json</strong> – Datasink info in JSON format for the respective output parameter <span className="em">monitor\_ids</span> if one is defined. The default value is ‘’.</p>
                </li>
              </ul>
            </div>

            <div className="dt">info (<span className="em">dict of str to str</span>) –</div>

            <div className="dd">
              <p>Additional information.</p>
            </div>
          </div>
        </div>
      </div>
    </div>
  </div>
</div>