Skip to content

Instantly share code, notes, and snippets.

@PedramNavid
Created February 10, 2022 23:28
Show Gist options
  • Save PedramNavid/71f73c98d98373053674f19b8239b06c to your computer and use it in GitHub Desktop.
Save PedramNavid/71f73c98d98373053674f19b8239b06c to your computer and use it in GitHub Desktop.
{
"title":"Sync Observability",
"description":"",
"widgets":[
{
"id":3690770394359244,
"definition":{
"title":"Total Completed Syncs",
"title_size":"16",
"title_align":"left",
"type":"query_value",
"requests":[
{
"formulas":[
{
"formula":"query1"
}
],
"response_format":"scalar",
"queries":[
{
"query":"avg:hightouch.sync.complete{status:success}.as_count()",
"data_source":"metrics",
"name":"query1",
"aggregator":"sum"
}
]
}
],
"autoscale":true,
"precision":0
},
"layout":{
"x":0,
"y":0,
"width":2,
"height":2
}
},
{
"id":7497776464370060,
"definition":{
"title":"Total Rows Processed",
"title_size":"16",
"title_align":"left",
"type":"query_value",
"requests":[
{
"formulas":[
{
"formula":"query1"
}
],
"response_format":"scalar",
"queries":[
{
"query":"avg:hightouch.sync.row_processed{*}.as_count()",
"data_source":"metrics",
"name":"query1",
"aggregator":"sum"
}
]
}
],
"autoscale":true,
"precision":0
},
"layout":{
"x":2,
"y":0,
"width":2,
"height":2
}
},
{
"id":5627649739876104,
"definition":{
"title":"Successful and Failed Operations",
"title_size":"16",
"title_align":"left",
"show_legend":true,
"legend_layout":"auto",
"legend_columns":[
"avg",
"min",
"max",
"value",
"sum"
],
"type":"timeseries",
"requests":[
{
"formulas":[
{
"alias":"Success",
"formula":"query1"
}
],
"response_format":"timeseries",
"queries":[
{
"query":"sum:hightouch.sync.row_processed{succeeded:true}.as_count().rollup(sum, 600)",
"data_source":"metrics",
"name":"query1"
}
],
"style":{
"palette":"green",
"line_type":"solid",
"line_width":"normal"
},
"display_type":"line"
},
{
"formulas":[
{
"alias":"Failed",
"formula":"query0"
}
],
"response_format":"timeseries",
"queries":[
{
"query":"sum:hightouch.sync.row_processed{succeeded:false}.as_count().rollup(sum, 600)",
"data_source":"metrics",
"name":"query0"
}
],
"style":{
"palette":"red",
"line_type":"solid",
"line_width":"normal"
},
"display_type":"line"
}
]
},
"layout":{
"x":4,
"y":0,
"width":4,
"height":3
}
},
{
"id":463588339618398,
"definition":{
"title":"Sync Operation Daily Change",
"title_size":"16",
"title_align":"left",
"type":"change",
"requests":[
{
"formulas":[
{
"formula":"day_before(query1)"
},
{
"formula":"query1"
}
],
"order_by":"change",
"order_dir":"desc",
"compare_to":"hour_before",
"response_format":"scalar",
"increase_good":true,
"queries":[
{
"query":"sum:hightouch.sync.row_processed{*} by {op_type}.as_count()",
"data_source":"metrics",
"name":"query1",
"aggregator":"avg"
}
],
"change_type":"relative"
}
]
},
"layout":{
"x":8,
"y":0,
"width":4,
"height":2
}
},
{
"id":7695485145575162,
"definition":{
"title":"Failed Syncs",
"title_size":"16",
"title_align":"left",
"type":"query_value",
"requests":[
{
"formulas":[
{
"formula":"query1"
}
],
"response_format":"scalar",
"queries":[
{
"query":"avg:hightouch.sync.complete{status:failed}.as_count()",
"data_source":"metrics",
"name":"query1",
"aggregator":"avg"
}
]
}
],
"autoscale":true,
"precision":0
},
"layout":{
"x":0,
"y":2,
"width":2,
"height":1
}
},
{
"id":4489993194953672,
"definition":{
"title":"Warning Syncs",
"title_size":"16",
"title_align":"left",
"type":"query_value",
"requests":[
{
"formulas":[
{
"formula":"query1"
}
],
"response_format":"scalar",
"queries":[
{
"query":"avg:hightouch.sync.complete{status:warning}.as_count()",
"data_source":"metrics",
"name":"query1",
"aggregator":"avg"
}
]
}
],
"autoscale":true,
"precision":0
},
"layout":{
"x":2,
"y":2,
"width":2,
"height":1
}
},
{
"id":5352102488178254,
"definition":{
"title":"Top Syncs with Warnings or Failures",
"title_size":"16",
"title_align":"left",
"type":"toplist",
"requests":[
{
"formulas":[
{
"formula":"query1",
"limit":{
"count":10,
"order":"desc"
}
}
],
"conditional_formats":[
{
"comparator":">",
"palette":"white_on_red",
"value":5
},
{
"comparator":">",
"palette":"white_on_yellow",
"value":3
}
],
"response_format":"scalar",
"queries":[
{
"query":"sum:hightouch.sync.complete{status:failed OR status:warning} by {sync}.as_count()",
"data_source":"metrics",
"name":"query1",
"aggregator":"sum"
}
]
}
]
},
"layout":{
"x":8,
"y":2,
"width":4,
"height":4
}
},
{
"id":1269371689062434,
"definition":{
"title":"Completed Syncs by Status",
"title_size":"16",
"title_align":"left",
"show_legend":true,
"legend_layout":"auto",
"legend_columns":[
"avg",
"min",
"max",
"value",
"sum"
],
"time":{
},
"type":"timeseries",
"requests":[
{
"response_format":"timeseries",
"queries":[
{
"query":"sum:hightouch.sync.complete{*} by {status}.as_count()",
"data_source":"metrics",
"name":"query1"
}
],
"formulas":[
{
"formula":"query1"
}
],
"style":{
"palette":"dog_classic",
"line_type":"solid",
"line_width":"normal"
},
"display_type":"bars"
}
],
"custom_links":[
{
"override_label":"containers",
"is_hidden":true
},
{
"override_label":"hosts",
"is_hidden":true
},
{
"override_label":"logs",
"is_hidden":true
},
{
"override_label":"traces",
"is_hidden":true
},
{
"override_label":"profiles",
"is_hidden":true
}
]
},
"layout":{
"x":0,
"y":3,
"width":4,
"height":3
}
},
{
"id":277854439117968,
"definition":{
"title":"Completed Rows by Status",
"title_size":"16",
"title_align":"left",
"show_legend":true,
"legend_layout":"auto",
"legend_columns":[
"avg",
"min",
"max",
"value",
"sum"
],
"type":"timeseries",
"requests":[
{
"formulas":[
{
"formula":"query1"
}
],
"response_format":"timeseries",
"queries":[
{
"query":"sum:hightouch.sync.row_processed{*} by {status}.as_count()",
"data_source":"metrics",
"name":"query1"
}
],
"style":{
"palette":"dog_classic",
"line_type":"solid",
"line_width":"normal"
},
"display_type":"bars"
}
]
},
"layout":{
"x":4,
"y":3,
"width":4,
"height":3
}
},
{
"id":3058290056841092,
"definition":{
"title":"Hourly Failed/Warning Syncs",
"title_size":"16",
"title_align":"left",
"show_legend":true,
"legend_layout":"horizontal",
"legend_columns":[
"avg",
"min",
"max",
"value",
"sum"
],
"time":{
},
"type":"timeseries",
"requests":[
{
"response_format":"timeseries",
"queries":[
{
"name":"query1",
"data_source":"metrics",
"query":"sum:hightouch.sync.complete{!status:success} by {status}.as_count().rollup(sum, 3600)"
}
],
"formulas":[
{
"formula":"query1"
}
],
"style":{
"palette":"warm",
"line_type":"dashed",
"line_width":"normal"
},
"display_type":"bars"
}
]
},
"layout":{
"x":0,
"y":6,
"width":8,
"height":2
}
}
],
"template_variables":[
],
"layout_type":"ordered",
"is_read_only":false,
"notify_list":[
],
"reflow_type":"fixed",
"id":"qn5-wdy-4mg"
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment