Detection rules › Kusto
Snowflake - Multiple login failures from single IP
'Detects Mmltiple login failures from single IP.'
MITRE ATT&CK coverage
| Tactic | Techniques |
|---|---|
| Initial Access |
Rule body
id: b7d22407-1391-4256-b09a-414a9719443c
name: Snowflake - Multiple login failures from single IP
description: |
'Detects Mmltiple login failures from single IP.'
severity: High
status: Available
requiredDataConnectors:
- connectorId: Snowflake
dataTypes:
- Snowflake
queryFrequency: 1h
queryPeriod: 1h
triggerOperator: gt
triggerThreshold: 0
tactics:
- InitialAccess
relevantTechniques:
- T1078
query: |
let threshold = 10;
Snowflake
| where EventType =~ 'LOGIN'
| where LoginIsSuccess =~ 'No'
| summarize count() by SrcDvcIpAddr, bin(TimeGenerated, 5m)
| where count_ > threshold
| extend IPCustomEntity = SrcDvcIpAddr
entityMappings:
- entityType: IP
fieldMappings:
- identifier: Address
columnName: IPCustomEntity
version: 1.0.2
kind: Scheduled
Stages and Predicates
Parameters
let threshold = 10;
Stage 1: source
Snowflake
Stage 2: where
| where EventType =~ 'LOGIN'
Stage 3: where
| where LoginIsSuccess =~ 'No'
Stage 4: summarize
| summarize count() by SrcDvcIpAddr, bin(TimeGenerated, 5m)
Stage 5: where
| where count_ > threshold
Stage 6: extend
| extend IPCustomEntity = SrcDvcIpAddr
Indicators
These rows show field, operator, and value matches.
| Field | Kind | Values | Search |
|---|---|---|---|
EventType | eq |
| field:"EventType" kind:eq value:"LOGIN" |
LoginIsSuccess | eq |
| field:"LoginIsSuccess" kind:eq value:"No" |
count_ | gt |
| field:"count_" kind:gt value:"10" |
Output fields
These fields are emitted when the rule matches.
| Field | Source |
|---|---|
SrcDvcIpAddr | summarize |
IPCustomEntity | extend |