Get a single Information Schema Table by id

Returns cached metadata for a specific table in the Data Source, including columns and their data types. Not all data source types support information schemas.

GET /information-schema-tables/{tableId}

cURL

cURL

curl https://api.growthbook.io/api/v1/information-schema-tables/ist_123abc \
  -u secret_abc123DEF456:

200

{
  "informationSchemaTable": {
    "id": "<string>",
    "datasourceId": "<string>",
    "informationSchemaId": "<string>",
    "tableName": "<string>",
    "tableSchema": "<string>",
    "databaseName": "<string>",
    "columns": [
      {
        "columnName": "<string>",
        "dataType": "<string>"
      }
    ],
    "refreshMS": 123,
    "dateCreated": "2023-11-07T05:31:56Z",
    "dateUpdated": "2023-11-07T05:31:56Z"
  }
}

Authorizations

bearerAuthbasicAuth

Authorization · string · header · required

If using Bearer auth, pass the Secret Key as the token:

curl https://api.growthbook.io/api/v1 \
  -H "Authorization: Bearer secret_abc123DEF456"

Path Parameters

tableId · string · required

The id of the information schema table

Response

200 - application/json

Success

informationSchemaTable · object · required

Show child attributes