Skip to main content
POST
/
v1
/
table
/
{name}
/
count_rows
Count Table Rows
curl --request POST \
  --url https://{db}.{region}.api.lancedb.com/v1/table/{name}/count_rows \
  --header 'Content-Type: application/json' \
  --header 'x-api-key: <api-key>' \
  --data @- <<EOF
{
  "predicate": "category = 'shoes'"
}
EOF
1000

Authorizations

​
x-api-key
string
header
required

Path Parameters

​
name
string
required

name of the table

Body

application/json
​
predicate
string

A SQL filter expression that specifies the rows to count.

Example:

"category = 'shoes'"

Response

Number of rows in the table

The response is of type integer.

Example:

1000