GET
/
data
/
projects
/
{projectId}
/
catalogs
/
{catalogId}
/
schemas
/
{schemaName}
/
tables
/
{tableName}
/
statistics
Table Statistics
curl --request GET \
  --url https://partner.peaka.studio/api/v1/data/projects/{projectId}/catalogs/{catalogId}/schemas/{schemaName}/tables/{tableName}/statistics \
  --header 'Authorization: Bearer <token>'
{
  "catalogId": "846085284821991568",
  "schemaName": "public",
  "tableName": "actor",
  "columnStatistics": [
    {
      "columnName": "actor_id",
      "distinctFraction": -1
    },
    {
      "columnName": "first_name",
      "distinctFraction": -0.64
    },
    {
      "columnName": "last_name",
      "distinctFraction": -0.605
    },
    {
      "columnName": "last_update",
      "distinctFraction": 1
    }
  ]
}

Authorizations

Authorization
string
header
required

Use the Authorization header with the value 'Bearer <apiKey>' to authenticate. Partner API Keys have full access; Project API Keys are limited to their project scope. Learn more: https://docs.peaka.com/api-reference/authentication

Path Parameters

projectId
string
required

ID of the project

catalogId
string
required

ID of the catalog

schemaName
string
required

Name of the schema

tableName
string
required

Name of the table

Response

200 - application/json

Successful operation

catalogId
string

The ID of the catalog.

schemaName
string

The name of the schema.

tableName
string

The name of the table.

columnStatistics
object[]

Statistics for each column in the table.