ccdw_aggr_scapi_request

This table aggregates daily performance metrics for SCAPI requests.

Column Alias	Data Type	Key	Description	Index?
`request_date`	DATE		Date of the request.	No
`api_family`	VARCHAR		Family of the SCAPI API.	No
`api_name`	VARCHAR		Name of the SCAPI API.	No
`api_resource`	VARCHAR		Specific SCAPI resource accessed.	No
`api_version`	VARCHAR		Version of the SCAPI API.	No
`site_id`	SMALLINT	FK	Foreign key to `ccdw_dim_site`.	No
`status_code`	INTEGER		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