Top asks

Users ask for contributions for the following services and scenarios:

• Azure Synapse and Azure Data Warehouse

• Azure Data Factory v2 (Resource-Specific Diagnostics)

• Security Center Continuous Export

• Azure Databricks

• a query that identifies sequences (sequence_detect doesn't provide the desired results). For example:

input:

Datetime	ProcId	EventStr
datetime(2020-06-01 8:00)	0	"Start"
datetime(2020-06-01 8:01)	1	"Start"
datetime(2020-06-01 8:02)	1	"Exit"
datetime(2020-06-01 8:03)	2	"Start"
datetime(2020-06-01 8:04)	2	"Exit"
datetime(2020-06-01 8:05)	1	"Start"
datetime(2020-06-01 8:06)	1	"Exit"
datetime(2020-06-01 8:10)	0	"Exit"

The expected output:

ProcId	Start_Time	Stop_Time	Duration
0	2020-06-01T08:00:00Z	2020-06-01T08:10:00Z	00:10:00
1	2020-06-01T08:01:00Z	2020-06-01T08:02:00Z	00:01:00
1	2020-06-01T08:05:00Z	2020-06-01T08:06:00Z	00:01:00
2	2020-06-01T08:03:00Z	2020-06-01T08:04:00Z	00:01:00