---
updatedAt: 2025-05-19T20:48:27.000Z
agentTools:
  projectIndex: https://docs.metaplane.dev/llms.txt
---

# Bulk get monitors on tables

Get all monitors on the input table paths. Limit of 200 table paths per request.

# OpenAPI definition

```json
{
  "openapi": "3.0.1",
  "info": {
    "title": "Metaplane Api",
    "description": "MetaplanePublicApi API description",
    "version": "1.0"
  },
  "servers": [
    {
      "url": "https://dev.api.metaplane.dev"
    }
  ],
  "security": [
    {
      "Authorization": []
    }
  ],
  "paths": {
    "/v2/monitors/bulk-fetch/tables/{connectionId}": {
      "post": {
        "tags": [
          "Monitors"
        ],
        "summary": "Bulk get monitors on tables",
        "description": "Get all monitors on the input table paths. Limit of 200 table paths per request.",
        "operationId": "bulkGetTableMonitors",
        "parameters": [
          {
            "name": "connectionId",
            "in": "path",
            "required": true,
            "schema": {
              "type": "string",
              "format": "uuid"
            }
          },
          {
            "name": "includeDisabled",
            "in": "query",
            "schema": {
              "type": "boolean"
            }
          },
          {
            "name": "fetchGroups",
            "in": "query",
            "schema": {
              "type": "boolean"
            }
          }
        ],
        "requestBody": {
          "content": {
            "application/json": {
              "schema": {
                "$ref": "#/components/schemas/BulkFetchMonitorTablesRequest"
              }
            }
          },
          "required": false
        },
        "responses": {
          "200": {
            "description": "Success",
            "content": {
              "application/json": {
                "schema": {
                  "$ref": "#/components/schemas/MonitorListResult"
                }
              }
            }
          }
        }
      }
    }
  },
  "components": {
    "schemas": {
      "PublicAnomalyAlertRule": {
        "type": "object",
        "properties": {
          "sensitivity": {
            "type": "number",
            "description": "Control the bounds of the model. The default value is 3.0.\n0.3 high is the highest sensitivity correlating with smallest bounds.\n6.0 Is lowest sensitivity corresponding with the largest bounds.\n",
            "format": "double",
            "default": 3
          },
          "monitorTypeOverride": {
            "type": "string",
            "enum": [
              "ROW_COUNT",
              "COLUMN_COUNT",
              "CARDINALITY",
              "UNIQUENESS",
              "NULLNESS",
              "PERCENT_ZERO",
              "PERCENT_NEGATIVE",
              "MIN",
              "MAX",
              "MEAN",
              "STDDEV",
              "FRESHNESS",
              "CUSTOM",
              "PUSH",
              "SUM",
              "DURATION",
              "GENERIC_OBJECT"
            ]
          },
          "modelClassType": {
            "type": "string",
            "enum": [
              "STATIONARY",
              "NONE"
            ]
          },
          "modelBoundsOverride": {
            "type": "string",
            "description": "Flags to completely override part of the model bounds",
            "nullable": true,
            "enum": [
              "UPPER_ONLY",
              "LOWER_ONLY"
            ]
          },
          "minLowerBoundSize": {
            "type": "number",
            "description": "Controls the minimum size for the lower bound of the models predictive range\n",
            "format": "double",
            "nullable": true,
            "default": 3
          },
          "minUpperBoundSize": {
            "type": "number",
            "description": "Controls the minimum size for the upper bound of the models predictive range\n",
            "format": "double",
            "nullable": true,
            "default": 3
          }
        }
      },
      "PublicMonitor": {
        "type": "object",
        "properties": {
          "id": {
            "type": "string",
            "format": "uuid"
          },
          "type": {
            "type": "string",
            "enum": [
              "ROW_COUNT",
              "COLUMN_COUNT",
              "CARDINALITY",
              "UNIQUENESS",
              "NULLNESS",
              "PERCENT_ZERO",
              "PERCENT_NEGATIVE",
              "MIN",
              "MAX",
              "MEAN",
              "STDDEV",
              "FRESHNESS",
              "CUSTOM",
              "PUSH",
              "SUM",
              "DURATION",
              "GENERIC_OBJECT"
            ]
          },
          "genericObjectSubtype": {
            "type": "string"
          },
          "valueType": {
            "type": "string",
            "enum": [
              "METRIC",
              "SOURCE_TO_TARGET"
            ]
          },
          "cronTab": {
            "type": "string"
          },
          "name": {
            "type": "string",
            "nullable": true
          },
          "description": {
            "type": "string",
            "nullable": true
          },
          "isEnabled": {
            "type": "boolean"
          },
          "config": {
            "$ref": "#/components/schemas/MonitorConfig"
          },
          "createdAt": {
            "type": "string",
            "format": "date-time"
          },
          "updatedAt": {
            "type": "string",
            "format": "date-time"
          },
          "absolutePath": {
            "type": "string"
          },
          "entityType": {
            "type": "string"
          },
          "connectionId": {
            "type": "string",
            "format": "uuid"
          },
          "monitorTags": {
            "uniqueItems": true,
            "type": "array",
            "items": {
              "type": "string"
            }
          },
          "monitorGroups": {
            "type": "array",
            "description": "List of all groups that have seen at least one datapoint for this monitor",
            "nullable": true,
            "items": {
              "$ref": "#/components/schemas/MonitorGrouping"
            }
          }
        }
      },
      "MonitorGrouping": {
        "type": "object",
        "properties": {
          "groupings": {
            "uniqueItems": true,
            "type": "array",
            "items": {
              "$ref": "#/components/schemas/LabelNameValue"
            }
          }
        },
        "description": "List of all groups that have seen at least one datapoint for this monitor",
        "nullable": true
      },
      "LabelNameValue": {
        "type": "object",
        "properties": {
          "name": {
            "type": "string"
          },
          "value": {
            "type": "string"
          }
        }
      },
      "TimeDuration": {
        "type": "object",
        "properties": {
          "days": {
            "type": "integer",
            "format": "int64"
          },
          "hours": {
            "type": "integer",
            "format": "int64"
          },
          "minutes": {
            "type": "integer",
            "format": "int64"
          }
        }
      },
      "MonitorListResult": {
        "type": "object",
        "properties": {
          "data": {
            "type": "array",
            "items": {
              "$ref": "#/components/schemas/PublicMonitor"
            }
          }
        }
      },
      "PublicIncrementalClause": {
        "type": "object",
        "properties": {
          "columnName": {
            "type": "string"
          },
          "duration": {
            "$ref": "#/components/schemas/TimeDuration"
          }
        },
        "nullable": true
      },
      "PublicManualThreshold": {
        "type": "object",
        "properties": {
          "operatorType": {
            "type": "string",
            "enum": [
              "GREATER_THAN",
              "GREATER_THAN_EQUALS",
              "LESS_THAN",
              "LESS_THAN_EQUALS",
              "EQUAL",
              "NOT_EQUAL"
            ]
          },
          "value": {
            "type": "number",
            "format": "double"
          }
        }
      },
      "PublicAlertRule": {
        "type": "object",
        "properties": {
          "type": {
            "type": "string",
            "enum": [
              "ANOMALY",
              "MANUAL"
            ]
          },
          "numFailuresBeforeAlert": {
            "type": "integer",
            "description": "Number of time a monitor can fail before an incident is created",
            "format": "int32",
            "nullable": true
          }
        },
        "description": "Optional alert rule configuration. Defaults to ANOMALY",
        "nullable": true,
        "discriminator": {
          "propertyName": "type",
          "mapping": {
            "MANUAL": "#/components/schemas/PublicManualThresholdRule",
            "ANOMALY": "#/components/schemas/PublicAnomalyAlertRule"
          }
        },
        "oneOf": [
          {
            "$ref": "#/components/schemas/PublicAnomalyAlertRule"
          },
          {
            "$ref": "#/components/schemas/PublicManualThresholdRule"
          }
        ]
      },
      "BulkFetchMonitorTablesRequest": {
        "type": "object",
        "properties": {
          "tablePaths": {
            "uniqueItems": true,
            "type": "array",
            "description": "Set of table path string in format of: {database}.{schema}.{table}",
            "items": {
              "type": "string",
              "description": "Set of table path string in format of: {database}.{schema}.{table}"
            }
          }
        }
      },
      "PublicManualThresholdRule": {
        "type": "object",
        "properties": {
          "thresholds": {
            "uniqueItems": true,
            "type": "array",
            "items": {
              "$ref": "#/components/schemas/PublicManualThreshold"
            }
          }
        }
      },
      "MonitorConfig": {
        "type": "object",
        "properties": {
          "customSql": {
            "type": "string",
            "nullable": true
          },
          "customMetricUnitType": {
            "type": "string",
            "description": "Overrides the display type in the metaplane UI. Default to float if not specified. Only applies to custom sql monitors",
            "nullable": true,
            "enum": [
              "INT",
              "FLOAT",
              "PERCENT",
              "SECOND",
              "BYTE",
              "MILLISECOND"
            ]
          },
          "incrementalClause": {
            "$ref": "#/components/schemas/PublicIncrementalClause"
          },
          "customWhereClause": {
            "type": "string",
            "nullable": true
          },
          "alertRule": {
            "$ref": "#/components/schemas/PublicAlertRule"
          },
          "groupByColumns": {
            "type": "array",
            "description": "List of columns to group query by",
            "nullable": true,
            "items": {
              "type": "string",
              "description": "List of columns to group query by",
              "nullable": true
            }
          },
          "timeZone": {
            "type": "string",
            "description": "Timezone identifier like: America/New_York",
            "nullable": true
          }
        },
        "nullable": true
      }
    },
    "securitySchemes": {
      "Authorization": {
        "type": "apiKey",
        "description": "Copy in your API key generated from metaplane",
        "name": "Authorization",
        "in": "header"
      }
    }
  },
  "x-readme": {
    "explorer-enabled": true,
    "proxy-enabled": false
  }
}
```