ccdw_aggr_ocapi

This table aggregates daily performance metrics for OCAPI requests.

Note: This table is not constrained by IP Address Filters configured in Business Manager.

Column Alias	Data Type	Key	Description	Index?
`request_date`	DATE		Date of the request.	No
`api_name`	VARCHAR		Name of the OCAPI API.	No
`api_resource`	VARCHAR		Specific OCAPI resource accessed.	No
`api_version`	VARCHAR		Version of the OCAPI API.	No
`site_id`	SMALLINT	FK	Foreign key to `ccdw_dim_site`.	No
`client_id`	VARCHAR		Client identifier making the request.	No
`status_code`	SMALLINT		HTTP status code of the response.	No
`method`	VARCHAR		HTTP method used (for example, "GET", "POST").	No
`num_requests`	INTEGER		Total number of requests.	No
`response_time`	NUMERIC		Average response time for the requests.	No
`num_requests_bucket1`	INTEGER		Number of requests in response time bucket 1.	No
`num_requests_bucket2`	INTEGER		Number of requests in response time bucket 2.	No
`num_requests_bucket3`	INTEGER		Number of requests in response time bucket 3.	No
`num_requests_bucket4`	INTEGER		Number of requests in response time bucket 4.	No
`num_requests_bucket5`	INTEGER		Number of requests in response time bucket 5.	No
`num_requests_bucket6`	INTEGER		Number of requests in response time bucket 6.	No
`num_requests_bucket7`	INTEGER		Number of requests in response time bucket 7.	No
`num_requests_bucket8`	INTEGER		Number of requests in response time bucket 8.	No
`num_requests_bucket9`	INTEGER		Number of requests in response time bucket 9.	No
`num_requests_bucket10`	INTEGER		Number of requests in response time bucket 10.	No
`num_requests_bucket11`	INTEGER		Number of requests in response time bucket 11.	No

ccdw_aggr_ocapi_request