This content originally appeared on DEV Community and was authored by Armaan Khan
[
{
"chart_type": "line",
"x_axis": "USAGE_DATE",
"y_axis": [
"SPILLED_QUERIES",
"OVER_PROVISIONED_QUERIES",
"PEAK_HOUR_LONG_RUNNING_QUERIES",
"SELECT_STAR_QUERIES",
"UNPARTITIONED_SCAN_QUERIES",
"REPEATED_QUERIES",
"COMPLEX_JOIN_QUERIES",
"ZERO_RESULT_QUERIES",
"HIGH_COMPILE_QUERIES",
"UNTAGGED_QUERIES"
],
"title": "Daily Trend of Bad Practices",
"tooltip_fields": ["USAGE_DATE", "bad_practice_type", "query_count"]
},
{
"chart_type": "bar",
"x_axis": "ISSUE_TYPE",
"y_axis": "COST_IMPACT",
"title": "Total Cost Impact by Bad Practice",
"tooltip_fields": ["ISSUE_TYPE", "COST_IMPACT", "RECOMMENDATION"]
},
{
"chart_type": "table",
"title": "Bad Practice Summary",
"columns": ["ISSUE_TYPE", "QUERY_COUNT", "COST_IMPACT", "RECOMMENDATION", "EXAMPLE_QUERY"]
}
]
This content originally appeared on DEV Community and was authored by Armaan Khan