VEvenasolutions
Vena tables [Beta]

Get VenaTable

Changed on

Returns metadata for a single VenaTable, including a live estimatedRowCount computed via COUNT(*) against the staging database. Use this endpoint for capacity planning before initiating an export. If the count query fails or times out, estimatedRowCount falls back to 0 and the request still returns 200.

get/models/{modelId}/venaTables/{venaTableId}

Request

Path parameters

modelIdstring required
Example:123456789012345678

ID of the data model

venaTableIdstring required
Example:1000000000001

ID of the VenaTable to return

Response

Successfully retrieved the VenaTable with estimatedRowCount.

idstring required

Unique identifier of the VenaTable (Id), serialized as a string.

namestring required

Display name of the VenaTable as configured in the Vena model.

columnNamesstring[] required

Ordered list of column names for this VenaTable.

estimatedRowCountinteger nullable

Approximate row count via live COUNT(*). Returns 0 when the count query fails or times out.

Example response

{
  "id": "1000000000001",
  "name": "General Ledger Transactions",
  "columnNames": [
    "Account",
    "CostCenter",
    "PostingDate",
    "Amount"
  ],
  "estimatedRowCount": 2457812
}

Changes