---
updatedAt: 2026-04-29T23:07:57.000Z
agentTools:
  projectIndex: https://docs.bigeye.com/llms.txt
---

# Search schemas

# OpenAPI definition

```json
{
  "openapi": "3.0.0",
  "info": {
    "title": "Metadata",
    "version": "version not set"
  },
  "paths": {
    "/api/v1/schemas": {
      "get": {
        "operationId": "SchemaService_SearchSchemas",
        "parameters": [
          {
            "in": "query",
            "name": "warehouseId",
            "required": false,
            "explode": true,
            "schema": {
              "type": "array",
              "items": {
                "format": "int32",
                "type": "integer"
              }
            }
          },
          {
            "in": "query",
            "name": "schemaName",
            "required": false,
            "explode": true,
            "schema": {
              "type": "array",
              "items": {
                "type": "string"
              }
            }
          },
          {
            "in": "query",
            "name": "schemaId",
            "required": false,
            "explode": true,
            "schema": {
              "type": "array",
              "items": {
                "format": "int32",
                "type": "integer"
              }
            }
          },
          {
            "in": "query",
            "name": "workspaceId",
            "required": false,
            "schema": {
              "type": "integer",
              "format": "int32"
            }
          }
        ],
        "responses": {
          "200": {
            "description": "A successful response.",
            "content": {
              "application/json": {
                "schema": {
                  "$ref": "#/components/schemas/generatedSchemaList"
                }
              }
            }
          },
          "default": {
            "description": "An unexpected error response.",
            "content": {
              "application/json": {
                "schema": {
                  "$ref": "#/components/schemas/runtimeError"
                }
              }
            }
          }
        },
        "summary": "Search schemas",
        "tags": [
          "SchemaService"
        ]
      }
    }
  },
  "security": [
    {
      "basicAuth": []
    },
    {
      "Personal_API_Key": []
    }
  ],
  "servers": [
    {
      "url": "https://app.bigeye.com"
    }
  ],
  "components": {
    "securitySchemes": {
      "basicAuth": {
        "type": "http",
        "scheme": "basic"
      },
      "Personal_API_Key": {
        "description": "Add 'apikey ' to the beginning of your api key",
        "in": "header",
        "name": "Authorization",
        "type": "apiKey"
      }
    },
    "schemas": {
      "generatedSchema": {
        "description": "*\nRepresentation of a schema in a warehouse.",
        "properties": {
          "dataNodeId": {
            "format": "int32",
            "type": "integer"
          },
          "databaseType": {
            "$ref": "#/components/schemas/generatedWarehouseType"
          },
          "id": {
            "format": "int32",
            "type": "integer"
          },
          "indexByTable": {
            "type": "boolean"
          },
          "isFavorite": {
            "type": "boolean"
          },
          "isVirtual": {
            "type": "boolean"
          },
          "latestMetricTimeValue": {
            "format": "int64",
            "type": "string"
          },
          "logicalSizeBytes": {
            "format": "int64",
            "type": "string"
          },
          "name": {
            "type": "string"
          },
          "numQueriesLatestPeriod": {
            "format": "int32",
            "type": "integer"
          },
          "popularityScore": {
            "format": "double",
            "type": "number"
          },
          "schemaChangeInfo": {
            "$ref": "#/components/schemas/generatedSchemaChangeInfo"
          },
          "sizeLastUpdatedAtMillis": {
            "format": "int64",
            "type": "string"
          },
          "tags": {
            "items": {
              "$ref": "#/components/schemas/generatedTag"
            },
            "type": "array"
          },
          "warehouseId": {
            "format": "int64",
            "type": "string"
          },
          "warehouseName": {
            "type": "string"
          }
        },
        "type": "object"
      },
      "generatedSchemaChangeInfo": {
        "properties": {
          "initialSchemaScanAt": {
            "format": "int64",
            "type": "string"
          },
          "lastSchemaChangeAt": {
            "format": "int64",
            "type": "string"
          },
          "mostRecentSchemaScanAt": {
            "format": "int64",
            "type": "string"
          }
        },
        "type": "object"
      },
      "generatedSchemaList": {
        "properties": {
          "schemas": {
            "items": {
              "$ref": "#/components/schemas/generatedSchema"
            },
            "type": "array"
          }
        },
        "title": "*\nRepresentation of a list of tables for API purposes",
        "type": "object"
      },
      "generatedTag": {
        "properties": {
          "colorHex": {
            "title": "color_hex includes a # prefix (e.g. “#181818” is correct, “181818” is incorrect)",
            "type": "string"
          },
          "createdAt": {
            "format": "int64",
            "type": "string"
          },
          "id": {
            "format": "int32",
            "type": "integer"
          },
          "name": {
            "type": "string"
          },
          "updatedAt": {
            "format": "int64",
            "type": "string"
          },
          "workspaceId": {
            "format": "int32",
            "type": "integer"
          }
        },
        "title": "Tags",
        "type": "object"
      },
      "generatedWarehouseType": {
        "default": "DATABASE_TYPE_UNSPECIFIED",
        "enum": [
          "DATABASE_TYPE_UNSPECIFIED",
          "DATABASE_TYPE_AWS_ATHENA",
          "DATABASE_TYPE_BIGQUERY",
          "DATABASE_TYPE_DATABRICKS",
          "DATABASE_TYPE_MYSQL",
          "DATABASE_TYPE_ORACLE",
          "DATABASE_TYPE_POSTGRES",
          "DATABASE_TYPE_PRESTO",
          "DATABASE_TYPE_REDSHIFT",
          "DATABASE_TYPE_SAP_HANA",
          "DATABASE_TYPE_SNOWFLAKE",
          "DATABASE_TYPE_SQL_SERVER",
          "DATABASE_TYPE_SYNAPSE",
          "DATABASE_TYPE_ROCKSET",
          "DATABASE_TYPE_VERTICA",
          "DATABASE_TYPE_AVATICA",
          "DATABASE_TYPE_DB2",
          "DATABASE_TYPE_TERADATA",
          "DATABASE_TYPE_NETEZZA",
          "DATABASE_TYPE_SALESFORCE"
        ],
        "type": "string"
      },
      "protobufAny": {
        "properties": {
          "typeUrl": {
            "type": "string"
          },
          "value": {
            "format": "byte",
            "type": "string"
          }
        },
        "type": "object"
      },
      "runtimeError": {
        "properties": {
          "code": {
            "format": "int32",
            "type": "integer"
          },
          "details": {
            "items": {
              "$ref": "#/components/schemas/protobufAny"
            },
            "type": "array"
          },
          "error": {
            "type": "string"
          },
          "message": {
            "type": "string"
          }
        },
        "type": "object"
      }
    }
  }
}
```