Snowflake - Multiple login failures from single IP

Back


Id	b7d22407-1391-4256-b09a-414a9719443c
Rulename	Snowflake - Multiple login failures from single IP
Description	Detects Mmltiple login failures from single IP.
Severity	High
Tactics	InitialAccess
Techniques	T1078
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 Rules/SnowflakeMultipleLoginFailureFromIP.yaml
Version	1.0.2
Arm template	b7d22407-1391-4256-b09a-414a9719443c.json

KQL

let threshold = 10;
Snowflake
| where EventType =~ 'LOGIN'
| where LoginIsSuccess =~ 'No'
| summarize count() by SrcDvcIpAddr, bin(TimeGenerated, 5m)
| where count_ > threshold
| extend IPCustomEntity = SrcDvcIpAddr

YAML

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:
- fieldMappings:
  - identifier: Address
    columnName: IPCustomEntity
  entityType: IP
triggerOperator: gt
description: |
    'Detects Mmltiple login failures from single IP.'
tactics:
- InitialAccess
severity: High
queryFrequency: 1h
kind: Scheduled
name: Snowflake - Multiple login failures from single IP
triggerThreshold: 0
status: Available
id: b7d22407-1391-4256-b09a-414a9719443c
requiredDataConnectors:
- connectorId: Snowflake
  dataTypes:
  - Snowflake
relevantTechniques:
- T1078
version: 1.0.2
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Snowflake/Analytic Rules/SnowflakeMultipleLoginFailureFromIP.yaml
queryPeriod: 1h

ARM