cURL
curl --request POST \ --url https://{db}.{region}.api.lancedb.com/v1/tables/{name}/count \ --header 'Content-Type: application/json' \ --header 'x-api-key: <api-key>' \ --data '{ "predicate": "category = '\''shoes'\''" }'
1000
Count the number of rows in a table with optional filtering. You can pass a SQL predicate to count only the rows that match specific criteria.
name of the table
Number of rows in the table
The response is of type integer.
integer