↳ GitHub sourceAnalytics ruleMedium

Snowflake - Possible discovery activity

Description

'Detects possible discovery activity.'
Rule type
Scheduled
Version
1.0.2
Declared status
Available
Query frequency
1h
Query period
1h
Trigger
gt 0

Declared MITRE coverage

Declared sources

Metadata from the source file. No dependencies inferred from KQL.

Connectors

Data types

KQL query

Original query, unchanged.

let threshold = 20;
Snowflake
| where QueryType =~ 'SHOW'
| where QueryExecutionStatus =~ 'SUCCESS'
| summarize count() by TargetUsername, bin(TimeGenerated, 5m)
| where count_ > threshold
| extend AccountCustomEntity = TargetUsername

Declared entities

Account

Related content

Links established from declared identifiers and solution manifests.

Source provenance

GitHub

Displayed values come from files in Azure/Azure-Sentinel. They describe the published template, not your workspace configuration.

Source identifier
09b8dfc7-87b0-4215-b34b-bab363d685cb
Additional source files 2Solutions/Snowflake/Analytic Rules/SnowflakeDiscoveryActivity.yamlsource ↗Solutions/Snowflake/Data/Solution_Snowflake.jsonsolution-membership ↗
GSTEP / CATALOG TRACKING

Added to catalog : 16 Sept 2026 · 05:49 UTC
Last change observed : 16 Sept 2026 · 05:49 UTC

GSTEP sync dates, separate from the source content’s publication dates.