detection.wiki

Detection rules › Kusto

Snowflake - Abnormal query process time

Status
available
Severity
medium
Time window
1h
Source
github.com/Azure/Azure-Sentinel

'Detects query with abnormal proccess time.'

MITRE ATT&CK coverage

TacticTechniques
Impact

Rule body

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

Stages and Predicates

Parameters

let threshold = 10000;

Stage 1: source

Snowflake

Stage 2: where

| where QueryTotalElapsedTime > threshold

Stage 3: extend

| extend AccountCustomEntity = TargetUsername

Indicators

These rows show field, operator, and value matches.

FieldKindValuesSearch
QueryTotalElapsedTimegt
  • 10000
field:"QueryTotalElapsedTime" kind:gt value:"10000"

Output fields

These fields are emitted when the rule matches.

FieldSource
AccountCustomEntityextend