Snowflake - Abnormal query process time | Microsoft Sentinel Analytic Rules

Back


Id	1376f5e5-855a-4f88-8591-19eba4575a0f
Rulename	Snowflake - Abnormal query process time
Description	Detects query with abnormal proccess time.
Severity	Medium
Tactics	Impact
Techniques	T1499
Required data connectors	Snowflake
Kind	Scheduled
Query frequency	1h
Query period	1h
Trigger threshold	0
Trigger operator	gt
Source Uri	https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Snowflake/Analytic%20Rules/SnowflakeLongQueryProcessTime.yaml
Version	1.0.1
Arm template	1376f5e5-855a-4f88-8591-19eba4575a0f.json

KQL

let threshold = 10000;
Snowflake
| where QueryTotalElapsedTime > threshold
| extend AccountCustomEntity = TargetUsername

YAML

name: Snowflake - Abnormal query process time
triggerOperator: gt
query: |
  let threshold = 10000;
  Snowflake
  | where QueryTotalElapsedTime > threshold
  | extend AccountCustomEntity = TargetUsername
queryFrequency: 1h
description: |
  'Detects query with abnormal proccess time.'
id: 1376f5e5-855a-4f88-8591-19eba4575a0f
triggerThreshold: 0
queryPeriod: 1h
version: 1.0.1
kind: Scheduled
status: Available
severity: Medium
requiredDataConnectors:
- connectorId: Snowflake
  dataTypes:
  - Snowflake
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Snowflake/Analytic%20Rules/SnowflakeLongQueryProcessTime.yaml
relevantTechniques:
- T1499
tactics:
- Impact
entityMappings:
- fieldMappings:
  - identifier: Name
    columnName: AccountCustomEntity
  entityType: Account

ARM

{
  "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
  "contentVersion": "1.0.0.0",
  "parameters": {
    "workspace": {
      "type": "String"
    }
  },
  "resources": [
    {
      "apiVersion": "2024-01-01-preview",
      "id": "[concat(resourceId('Microsoft.OperationalInsights/workspaces/providers', parameters('workspace'), 'Microsoft.SecurityInsights'),'/alertRules/1376f5e5-855a-4f88-8591-19eba4575a0f')]",
      "kind": "Scheduled",
      "name": "[concat(parameters('workspace'),'/Microsoft.SecurityInsights/1376f5e5-855a-4f88-8591-19eba4575a0f')]",
      "properties": {
        "alertRuleTemplateName": "1376f5e5-855a-4f88-8591-19eba4575a0f",
        "customDetails": null,
        "description": "'Detects query with abnormal proccess time.'\n",
        "displayName": "Snowflake - Abnormal query process time",
        "enabled": true,
        "entityMappings": [
          {
            "entityType": "Account",
            "fieldMappings": [
              {
                "columnName": "AccountCustomEntity",
                "identifier": "Name"
              }
            ]
          }
        ],
        "OriginalUri": "https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Snowflake/Analytic%20Rules/SnowflakeLongQueryProcessTime.yaml",
        "query": "let threshold = 10000;\nSnowflake\n| where QueryTotalElapsedTime > threshold\n| extend AccountCustomEntity = TargetUsername\n",
        "queryFrequency": "PT1H",
        "queryPeriod": "PT1H",
        "severity": "Medium",
        "status": "Available",
        "subTechniques": [],
        "suppressionDuration": "PT1H",
        "suppressionEnabled": false,
        "tactics": [
          "Impact"
        ],
        "techniques": [
          "T1499"
        ],
        "templateVersion": "1.0.1",
        "triggerOperator": "GreaterThan",
        "triggerThreshold": 0
      },
      "type": "Microsoft.OperationalInsights/workspaces/providers/alertRules"
    }
  ]
}