Snowflake - Multiple login failures by user

Back


Id	e05cc333-d499-430f-907c-7f28a9e4d1b5
Rulename	Snowflake - Multiple login failures by user
Description	Detects multiple login failures by user.
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/SnowflakeMultipleLoginFailure.yaml
Version	1.0.2
Arm template	e05cc333-d499-430f-907c-7f28a9e4d1b5.json

KQL

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

YAML

OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Snowflake/Analytic Rules/SnowflakeMultipleLoginFailure.yaml
severity: High
queryFrequency: 1h
status: Available
entityMappings:
- fieldMappings:
  - identifier: Name
    columnName: AccountCustomEntity
  entityType: Account
triggerOperator: gt
query: |
  let threshold = 10;
  Snowflake
  | where EventType =~ 'LOGIN'
  | where LoginIsSuccess =~ 'No'
  | summarize count() by TargetUsername, bin(TimeGenerated, 5m)
  | where count_ > threshold
  | extend AccountCustomEntity = TargetUsername  
queryPeriod: 1h
kind: Scheduled
id: e05cc333-d499-430f-907c-7f28a9e4d1b5
relevantTechniques:
- T1078
description: |
    'Detects multiple login failures by user.'
requiredDataConnectors:
- dataTypes:
  - Snowflake
  connectorId: Snowflake
triggerThreshold: 0
tactics:
- InitialAccess
name: Snowflake - Multiple login failures by user
version: 1.0.2

ARM