Page Comparison

...

1. • API_REQUEST_SUMMARY 

     This table contains the summary data of the request event stream.

     Code Block
     language sql title API_REQUEST_SUMMARY table schema
     CREATE TEMPORARY TABLE API_REQUEST_SUMMARY_FINAL USING CarbonAnalytics OPTIONS (tableName "API_REQUEST_SUMMARY", schema "api string -i, api_version string -i, version string -i, apiPublisher string -i, consumerKey string -i, userId string -i, context string -i, max_request_time long -i, total_request_count int -i, hostName string -i, year int -i, month int -i, day int -i, time string -i, key_api_facet facet -i, key_userId_facet facet -i, api_version_userId_facet facet -i, api_version_userId_apiPublisher_facet facet -i, api_version_userId_context_facet facet -i", primaryKeys "api,api_version,version,apiPublisher,consumerKey,userId,context,hostName,year,month,day" );

     API_VERSION_USAGE_SUMMARY

     This table contains the summary data for API Manager usage. It is also derived from the request event table.

     CREATE TEMPORARY TABLE API_VERSION_USAGE_SUMMARY_FINAL USING CarbonAnalytics OPTIONS (tableName "API_VERSION_USAGE_SUMMARY", schema "api string -i, version string -i, apiPublisher string -i, context string -i, total_request_count int -i, hostName string -i, year int -i, month int -i, day int -i, time string -i, max_request_time long -i, api_version_context_facet facet -i", primaryKeys "api,version,apiPublisher,context,hostName,year,month,day" );

     Code Block
     language sql title VERSION_USAGE_SUMMARY table schema
     Expand
     title Expand to find the table of descriptions for each column
     Code Block api : API Name api_version : API synapse artifact contained name [API Provider +"--"+API Name] version : API version apiPublisher : API provider context : api context consumerKey : consumer key of API invoked client application userId : API invoked end user name max_request_time: The latest API request occurred time total_request_count: Total request count for the requests coming for same API hostname : APIM server hostname year : The year of initial API request occurred of the batch of API requests month : The month of initial API request occurred of the batch of API requests day : The date of API initial request occurred of the batch of API requests time : The time of API initial request occurred of the batch of API requests

   • API_VERSION_USAGE_SUMMARY

     This table contains the summary data for API Manager usage. It is also derived from the request event table.

     Code Block
     language sql title VERSION_USAGE_SUMMARY table schema
     CREATE TEMPORARY TABLE API_VERSION_USAGE_SUMMARY_FINAL USING CarbonAnalytics OPTIONS (tableName "API_VERSION_USAGE_SUMMARY", schema "api string -i, version string -i, apiPublisher string -i, context string -i, total_request_count int -i, hostName string -i, year int -i, month int -i, day int -i, time string -i, max_request_time long -i, api_version_context_facet facet -i", primaryKeys "api,version,apiPublisher,context,hostName,year,month,day" );

     The table below contains the descriptions of each column

     Code Block

     api : API Name version : API version apiPublisher : API provider context : api context consumerKey : consumer key of API invoked client application resourcePath : API resource url pattern of API request method : HTTP Verb of API request [eg:GET/POST] total_request_count :Total request count for a particular API resource pattern hostname : APIM server hostname year : The year of initial API request occurred of the batch of API requests month : The month of initial API request occurred of the batch of API requests day : The date of API initial request occurred of the batch of API requests time : The time of API initial request occurred of the batch of API requests

   • API_Resource_USAGE_SUMMARY

     This table contains the summarized data for API Manager usage by resources and it is also derived from request event table.

     Code Block
     language sql title API_Resource_USAGE_SUMMARY table schema
     CREATE TEMPORARY TABLE API_Resource_USAGE_SUMMARY_FINAL USING CarbonAnalytics OPTIONS (tableName "API_Resource_USAGE_SUMMARY", schema "api string -i, version string -i, apiPublisher string -i, consumerKey string -i, resourcePath string -i, context string -i, method string -i, total_request_count int -i, hostName string -i, year int -i, month int -i, day int -i, time string -i, max_request_time long -i, key_api_method_path_facet facet -i, api_version_context_method_facet facet -i", primaryKeys "api,version,apiPublisher,consumerKey,context,resourcePath,method,hostName,year,month,day" );

   • API_RESPONSE_SUMMARY

     This table contains the summarized data from API responses. It is derived from the response event table.

     Code Block
     language sql title API_RESPONSE_SUMMARY table schema
     CREATE TEMPORARY TABLE API_RESPONSE_SUMMARY_FINAL USING CarbonAnalytics OPTIONS (tableName "API_RESPONSE_SUMMARY", schema "api_version string -i, apiPublisher string -i, context string -i, serviceTime int -i, total_response_count int -i, hostName string -i, year int -i, month int -i, day int -i, time string -i, max_request_time long -i, api_version_context_facet facet -i", primaryKeys "api,version,apiPublisher,context,hostName,year,month,day" );

   • API_FAULT_SUMMARY

     This table contains the summarized data of faulty API invocations and is derived from the fault event stream.

     Code Block
     title API_FAULT_SUMMARY table schema
     CREATE TEMPORARY TABLE API_FAULT_SUMMARY_FINAL USING CarbonAnalytics OPTIONS (tableName "API_FAULT_SUMMARY", schema "api string -i, version string -i, apiPublisher string -i, consumerKey string -i, context string -i, total_fault_count int -i, hostName string -i, year int -i, month int -i, day int -i, time string -i, max_request_time long -i, consumerKey_api_facet facet -i, api_version_apiPublisher_context_facet facet -i", primaryKeys "api,version,apiPublisher,consumerKey,context,hostName,year,month,day" );

   • API_DESTINATION_SUMMARY

     This table contains the summarized data of the API destinations and is derived from the destination event stream.

     Code Block
     language sql title API_DESTINATION_SUMMARY table schema
     CREATE TEMPORARY TABLE API_DESTINATION_SUMMARY_FINAL USING CarbonAnalytics OPTIONS (tableName "API_DESTINATION_SUMMARY", schema "api string -i, version string -i, apiPublisher string -i, context string -i, destination string -i, total_request_count int -i, hostName string -i, year int -i, month int -i, day int -i, time string -i, max_request_time long -i, api_version_context_dest_facet facet -i", primaryKeys "api,version,apiPublisher,context,destination,hostName,year,month,day" );

   • API_LAST_ACCESS_TIME_SUMMARY

     This table contains the summary data of the last access times of the API and is derived from the request event stream.

     Code Block
     language sql title API_LAST_ACCESS_TIME_SUMMARY table schema
     CREATE TEMPORARY TABLE API_LAST_ACCESS_TIME_SUMMARY_FINAL USING CarbonAnalytics OPTIONS (tableName "API_LAST_ACCESS_TIME_SUMMARY", schema "tenantDomain string -i, apiPublisher string -i, api string -i, version string -i, userId string -i, context string -i, max_request_time long -i", primaryKeys "tenantDomain,apiPublisher,api" );

   • API_THROTTLED_OUT_SUMMARY

     This table contains the summary of the throttle out API invocation data. It is derived from the throttle out event table and request table.

     Code Block
     language sql title API_THROTTLED_OUT_SUMMARY table schema
     CREATE TEMPORARY TABLE THROTTLED_OUT_FINAL_SUMMARY USING CarbonAnalytics OPTIONS (tableName "API_THROTTLED_OUT_SUMMARY", schema "api string -i, api_version string -i, context string -i, apiPublisher string -i, applicationName string -i, tenantDomain string -i, year int -i, month int -i, day int -i, week int -i, time string -i, success_request_count int -i, throttleout_count int -i, max_request_time long -i, api_year_month_week_day_facet facet -i, applicationName_facet facet -i", primaryKeys "api,api_version,context,apiPublisher,applicationName,tenantDomain,year,month,day" );

...